In Excell 2003, when I have multiple documents open and I click on the big X in the upper corner all docs close at once. In Word 2003 this does not happen. Is...

I have 31 worksheets in a workbook each worksheet contains the same macros, I have two questions. 1.Can the macros be saved in a central place so they are not...

Does anyone know how to get excel to print on 3 X 5 cards. Under the page setup feature I don't have that option. The smallest it shows is 4 X 6.

Is there a function similar to SUMIF for numerical data that will return text? I have a list of item #'s that have no description. I want to be able to lookup...

Under date formating, the default option (the one with the * at the top of the list) has recently changed from *3/14/2001 to *3/14/01 (4 digit year to 2 digit...

I have about 800 records that look like this: id diag 0001 11.0 0001 4.56 0003 10.5 0003 41.7 0003 52.5

How do you repeat page setup for different worksheets within a workbook? I want the same headers/footers/page numbering, etc. on each worksheet. Thanks.

Does anyone know how to remove the duplicated from a long list of (say) codes. Eg: I have a single column of 10,000 codes many repeating several times. I want...

I am trying to put together a summary sheet for hours worked from timecard sheets from different employees. The timecard sheets can have multiple job numbers...

At work, every hour on the hour. I take the contents of certain cells and paste them into notepad and then copy them in to a lotus notes stationary. This is...

I'm trying to create a loop that will repeat a procedure until it encounters a worksheet that is named "X". I can't get the "Do Until..." part working right. ...

I have a several worsheets in a workbook. I would like to be able to run a macro that would rename many of the sheets based on the values in a range of cells....

I have a QueryTable (i.e. the results of Get External Data - New Database Query)in a worksheet and when I refresh it, it disapears. If I choose to edit the...

I have a macro that inserts a new worksheet based on a template. I am having problems naming this worksheet however. Here is the code: Sheets("Cover...

I have a pivot table with a row I want to Hide Detail for. I recorded a macro by clicking on the row heading I want to hide, then right clicking and selecting...

How do I get the the sum formula to recognize all the values in a column? The rows in the column in question are formula based: e.g., =IF($L6="Us",$J6,"")...

I have been able to reduce the file size by unclicking the option "save data in pivot table". I can't seem to find an article on the web that will explain to...

I have created a button to save my spreadsheet as a webpage here is the code when I hit the button: ActiveWorkbook.PublishObjects.Add(xlSourceSheet,...

I've been asked to provide a chart that will show where each state stands compared to all others. This information will be pulled from two columns, I'm...

Hey all, I'm on the last day of my workterm and I'm trying to print of a bunch of work of done but i don't know how to print multiple pages with the same...