calculations or macros?
I have a spreadsheet that I copy a new worksheet with additional info each week. I need certain info that has multiple criteria to add to one of the "permanent" worksheets. For example: A B C IRS IRSA 20.00 IRP ... 14 Sep 2009 03:05
Add blank columns to long list of data - Excel 2007
is it possible to auto add a blank row based on criteria in 3 adjacent columns? the data is sorted based on these 3 columns, but we don't need subtotals, just blank rows. Thank you. ... 9 Sep 2009 17:40
To Display Negative Dates
Hello ! Thanks to all you for helping out me in my previous problem. This i have a problem with diplaying negative times, Say A1= 10:30 (format is hh:mm) and B1 = 8:30 (format is hh:mm). when C1=B1-A1, the value is displayed as ##### with notification negative dates and times are displayed as ######. Is t... 8 Sep 2009 12:34
Custom footer date format
How can I change the custom footer date format from 27-08-09 to 27-Aug-09 in Excel 2007? ... 4 Sep 2009 15:27
excel spreadsheet not visible
I open an exisiting spreadsheet, and it's maximized in the Excel window. When I minimize the spreadsheet (within teh Excel Window), it is no longer visible, although it's there: if i select Full Screen from teh View menu, I can see the file. If I close Full Screen view or select another view, I can no longer... 7 Feb 2009 21:48
RSEXCEL.XLL Not Found
When I open up EXCEL 2007, I receive the following error message: 'C:\Program Files\IBM\QMF forWindows\rsexcel.xll not found.....'. I have QMF for Windows installed. I just upgraded to EXCEL2007 from EXCEL. How can I get rid of this message? ... 30 Jan 2009 11:19
2007 Name Manager "automatic" entries?
I have begun using Named Ranges with a vengance, but as I manage them now I see many named ranges that I did not create (looking in Name Manager). Where do the following come from? Can I delete them? ..PrintTitles ..wvu.cols ..wvuPrint.Area FIlterDatabase ... 27 Jan 2009 10:04
Missing Add-Ins tab - Excel 2007 & Jet Reports
Problem solved. Reinstall the Jet reports, then activate the new install. The new Add-In tab is there with the Jet Report links. Thanks for everyone input. "Jim" wrote: I just completed this new Office 2007 install. Does anyone know how to install the Add-Ins tab for Excel. I can't seem to find any... 23 Jan 2009 15:10
I have a spreadsheet which has been used for many years by several different people who have each applied their own particular "footer" to the spreadsheet. The footer listing is now far too long. Is there any way to to delete those items in the footer "history" listing which no longer apply? Thank you. -- ... 14 Jan 2009 21:04
How can I determine and display my Time Zone?
I am creating a EXCEL Spreadsheet that will be distributed worldwide. As data is entered in the Spreadsheet, it will be transmitted to the homeoffice. I would like to capture the timestamp of the workstation that is sending the document to the Home Office, including Time Zone. ... 12 Jan 2009 17:48