| Thread | Last Post | Replies |
|
| Macro or Formula? | 20 Sep 2006 17:26 GMT | 1 |
I assume this needs a macro, but here is what I am trying to do: Sample Data: AB 93 OK 93 AB ABC 9370 OK 9370 ALL
|
| object behind text and gridlines | 20 Sep 2006 17:25 GMT | 2 |
How can I order a text box or other drawing object to the back, and behind the text and gridlines of the spreadsheet?
|
| Create a formula to calculate when info. was last updated | 20 Sep 2006 17:23 GMT | 5 |
I'm not sure if this is the appropriate forum, but I'd creating a file that includes multiple lines and I'd like a cell for each line to act as a status cell and note the last update to that line. Is there a way to do that?
|
| I cannot see some columns and some menu items are grayed out | 20 Sep 2006 17:10 GMT | 3 |
we are missing some colums from our spreadsheet and we cant unhide them beacuse the button is grayed out the information is still there because i can do a mail merge and put in to a word document from that spreadsheet.
|
| Input color and formula color | 20 Sep 2006 16:59 GMT | 5 |
Is it possible that on a spreadsheet, whenever you have cell with a formula in it, the font color is black and if you have another cell where it is a simple input field the cell font color is blue. I do want to goto each cell and select black or blue. I do not want to use
|
| Excel 2003: Print Area | 20 Sep 2006 16:59 GMT | 4 |
I have a workbook with 12 worksheets in it. They are all basically the same so when I set the print area for one it could be the same for all 12 worksheets. Is there a way to do this all at once rather than 12 times?
|
| Trying to add a drop down list of all worksheets for the user | 20 Sep 2006 16:59 GMT | 2 |
We have 50 worksheets in an Excel file. I would like to provide a drop down box or something of that nature for the user to select and automatically take them to the worksheet. Is there a way to do that? Is there also a way for the user to get back?
|
| Excel - How to compare two spreadsheets | 20 Sep 2006 16:59 GMT | 1 |
Need to compare two long complex spreadsheets with primarily text entries in the spreadsheets. Wanting to cull out a report on how they are different
|
| How do I get rid of an external link which I can't find? | 20 Sep 2006 16:54 GMT | 1 |
I have a spreadsheet that *somewhere* has an external link. I want to get rid of it, but I need to find the link first to check that I am not hard-coding over a formula that does actually need to change. However Excel 2002 is too stupid to show me the actual link. I can "Break
|
| Cleaning Up Data | 20 Sep 2006 16:40 GMT | 3 |
Ok i have close to 10000 records and they look like bg1234 and i need to add 00000 after the bg but i also have to make the bg capital letters. How do i set up a marco to just look for the bg because i have other records that begin with other letters. Another problem is
|
| sumproduct for month and year | 20 Sep 2006 16:29 GMT | 1 |
I am trying use sumproduct to add totals for a month when the criteria or date column is in the date format mm/dd/yyyy. For example the month column could have the following dates 06/04/2006
|
| Macro help please | 20 Sep 2006 16:22 GMT | 3 |
I have two macros I'll put in order below after I explain, can I join them into one, or can I make another macro that runs the first, then the second? Each works fine, but second one loops, so combining them is beyond me, unless there is a way to benchmark loops in code?
|
| VLOOKUP error in VBA | 20 Sep 2006 15:57 GMT | 1 |
I am doing some VLookups in visual basic and am running into an issue. Basically, I am running 7 vlookups on the same value in different columns. If the vlookup does not return an error, I want to report the number in column 3 of the range; if it is an error (ie, the lookup
|
| print preview | 20 Sep 2006 15:54 GMT | 4 |
Print preview has suddenly dissappeared - how can I get it back. Why has this happened?
|
| Looking for Mortgage Calculation Spreadsheet | 20 Sep 2006 15:24 GMT | 2 |
I am looking for a Mortgage Calculation Spreadsheet which calculates the following: Term Loan Amount
|