Threads Replies Last Post 2139 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Compatibility Problem Excel 2003 x 2007 Excel 2007 imcorporated some functions which used to be in a add in previous versions. This is the case, for example, for the workday() and networkdays() functions but there are some others. When I open a 2003 spreadsheet with this functions Excel prompts I'm using "reserved" names for user defined function which is now internal. The problem is when I save this 2003 spreadsheet in Exce... 2 12/30/2008 11:02:29 PM Indirect question I want range ("CB4:CN289") to indirectly reference Range ("BL4:BX289") As far as I can see I have to enter the indirect command into each cell individually. Is there an obvious way of mass producing and doing it in one go? Many thanks ... 3 12/30/2008 10:54:15 PM Macro Commands I want to be able to search through an imported text file for the first instance of a work (no problem doing this) and then select all the "Row" above it and delete them. So . . . How do I programatically determine which row the "Search" string is in and then pass that to the next line to delete all rows above that row? -- ... 6 12/30/2008 10:44:44 PM Getpivotdata Question Hi, I am working with a spreadsheet and I'm trying to use the getpivot data function with dollar amounts. It has worked for all other figures on my spreadsheet but when I try to get a number that is $$ the function isn't working I get the REF error. My formula looks like this: =GETPIVOTDATA("Average Salary",Sheet1!$A$6,"C-R Band",".85-.89") Thanks for any help you can offer! ... 4 12/30/2008 9:46:43 PM Macro buttons for gray scale and color print I have a logistics workbook with a summary page that has print macro buttons. I'm looking at having two (2) print buttons for certain worksheets. I can figure out how to add the print function into a button, however the problem I'm running into is when I set the references for printing, it stays in that reference. I'm wanting one (1) button for color print and one (1) for gray scale prin... 3 12/30/2008 9:33:34 PM Conditional Move I have the need to copy the content of a cell to another cell based on the value of a totally different cell. If A1 is =>1 and =<10, then I need to copy the content of a3 to a4. Any clues on how to get this to work? Thanks, Mike... 6 12/30/2008 9:23:35 PM Conditional Formatting on a Linked Cell When I apply conditonal formatting to a linked cell in my spreadsheet it does not work. Is there someway to get this to work? I am trying ot get eh vale to be bold if it is geater than a fixed value. The cell link is =UPLOAD!J107 that I am trying to format conditionally. Thanks... 5 12/30/2008 9:21:42 PM How can I Round up to the nearest .25 How can I Round up to the nearest .25. I have Cells B3 thru G3 with Values: 3.02, 3.41, 3.65, 3.91, 4.29, and 4.79. I would like them rounded up to the nearest .25 (3.25, 3.50, 3.75, 4.00, 4.50, 5.00). Is there a function for this?... 12 12/30/2008 9:19:37 PM 2Q:Indirect worksheet selection in macro, Calc off for specific sh I'm having trouble finding the code to use within a macro to select a worksheet based on the value entered into a certain cell. What I have is a worksheet for entering data and a macro that organizes and copies the data to other sheets, one being a catch-all for all data and another being a sheet corresponding to a specific value entered in B2. Options for data in B2 are validated from... 2 12/30/2008 9:11:45 PM Macro for check box I have the following information: Column A Column B Column C Revenue 1000.0 1200.0 1300.0 Expense $500.00 $300.00 $200.00 Margin $500.00 $900.00 $1,100.00 I am adding a check box in the bottom of each column and I need to created a macro that when I check the box (true) it will copy and paste as a value the data above the check box. thanks for your help. Pantera ... 3 12/30/2008 8:59:32 PM counting starting with a number other than 1 I am creating automatically generated tracking numbers for groups of data by using the following formula: =IF('Sheet !'!A1 = 0,COUNT($A$6:A6)+1, " ") ( in these groups of data the header row is 0 in the A column, if that ake sense). What I need to do now is make the count start at a number other than 1, say, 2000. What do I need to add to the forumla to accomplish that?... 2 12/30/2008 8:42:49 PM How do I re-format the content in populated cells in Excel? I have a column of dates that I want to switch to another date format. So far I know how to do that only by formatting the column, then double-clicking on a single cell, clicking on the column header, and repeating this action with each subsequent cell... There has to be a better way, no?... 4 12/30/2008 8:40:41 PM Compiling email addresses from individual cells I'd like to send a single email to a couple hundred associates. Each email address is listed in a separate cell in a single file column. I've concatenated the list but can't figure out a way to capture the text (I can capture the formula but I don't need that) so I can take it and paste it in the address field. I'm using Excel 2003 SP1.... 3 12/30/2008 8:30:32 PM Locking Excel cell formating and editing, copying and pasting cont Is there a way to lock Excel cell format on just part of a worksheet AND allow editing of same cell contents AND allow copy and paste of entire worksheet? This is needed particularly for areas that have "check boxes" in the area that I want to protect the formating. The "check boxes" tend to move in relation to their original placement each time the worksheet is copied and pasted after... 2 12/30/2008 8:29:21 PM Creating a macro to print the date a document was last saved. Good morning! I am looking to add a macro to a workbook that will automatically print the date last saved (in the bottom right corner, I think). Can you help? THANK YOU! ~judi... 3 12/30/2008 8:17:23 PM Compare two cells, if equal move a third cell to another cell Need a formula to compare the content of two cells and if equal, move (copy) the content of a third cell to another cell. Any help would be appeciated. Mike... 4 12/30/2008 7:26:38 PM calculate number of days Hi guys. Ok i have items that run between two dates, each month i have to calculate how many days in that month relate to that item, eg. in Jan Item From To Jan Days a3 14/11/08 16/02/09 x a4 19/12/08 09/01/09 x So x = 31 x = 9 Is there a quick way to produce the number of jan days for each item between the two dates ... 7 12/30/2008 7:15:01 PM Excel 2007 - Sorting 3 columns I am not very good with Excel nor 2007 version so hopefully I can explain this so you can understand. I have an excel spreadsheet for work that I am trying to sort 3 columns at once. Column A is titled Classes, Column B is Grades and Column C is Type. I turned on the filter sor sorting and used the down arrow of Column A to select what Classes I wanted and it did fine; however when I tr... 4 12/30/2008 6:47:21 PM entering timecode into cells I'm trying to enter metadata for video assets. When I enter "35:55" for 35 minutes and 55 seconds, it keeps being changed to a fraction or a date or sometimes "0:35:55". I've tried formatting the cells to general or MM:SS, but it won't work Does anyone know what to select when entering TRTs for tapes? Thanks!... 3 12/30/2008 6:42:09 PM Pivot Table Report Filter Sorting Is there a way to sort the items in a Pivot Table Report Filter alphabetically or numerically in Excel 2007? I notice that that they currently appear in the order in which they are present in the raw data.... 4 12/30/2008 6:20:24 PM Clearing cells based upon criteria? I have a worksheet that I would like to have specific cells cleared to nothing if the value in one specific cell changes. So if I change the one cell at any time and point then the other specific cells clear out of anything. Can anyone tell me if this is possible and how I would go about it. Currently I have a macro set up that clears the cells if you "CTRL + c" but I would like it to... 6 12/30/2008 6:07:06 PM macro protection Hi everyone, Is there a way to password protect macros especially those written to command buttons. If someone fiddles with a macro, this can mess up the hole work. Thanks Albert... 4 12/30/2008 6:00:14 PM Excel file as two SEPARATE windows - Data and Chart? How can I have an Excel 2007 file with 2 sheets, Data and Chart, so that each sheet opens in a separate window? It USED to work like that, with the older version I had. I want to be able to switch between the windows with alt-tab. Any ideas? Thanks, Tim... 3 12/30/2008 5:59:01 PM Copy formula how can i copy a formula from one row to another with out changing the refrences and with out using absolute refrences "$" eg. In row 2 i have =average(B200:B300) I want to copy the exact formula into row 20 with out having to change the formula in row 2 to =average(B$200:B$300) is this possible?... 3 12/30/2008 5:54:00 PM Sorting Subtotals I have a spreadsheet that I am subtotaling. Most of the subtotals are zero, but I am only concerned with the subtotals that are not. I need to keep the detail. How can I segregate what has a zero total from another subtotal without manually looking through the spreadsheet and copying and pasting? I have already tried sorting by the total column, but it won't let me. FYI, I am using ... 12 12/30/2008 5:48:14 PM 2139 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>