I have an Excel file with several hundred stores and their operating data, but I want to update the file with sales data from a monthly sales report. How can I...

HOW DO I INSTALL A LITTLE BOX ( FOR A CHECK MARK) IN FRONT OF A SENTENCE? I AM USING THE MICROSOFT EXEL TO PRODUCE YOUR OWN FORMS.

Hi, Is it possible to create another tab when opening General Templates? What I see is a General Tab and Spreedsheet Solutions. I like to create another Tab...

Ok, don't laugh. I want to know how to set up a row that will stay at the top of the screen when I scroll down the spreadsheet. An example would be...

I like to be able to click on "New" and have the General Template Window come up. Presently Workbook pane comes up and I have to click on the General Template...

I want to add the prices I have in column C if column A is x and column B is Y? SUMIF is like what I need but with more ifs. Does that make sense?

I am trying to set up a macro that will save a sheet based on the vaule in a cell of the same workbook. Anyone got any ideas Regards Peter

I am being silly but is there a way of setting a workshhet so that when I type in 4.9 in a percentage formatted cell it does not appear as 490%? I suppose I...

I want to move several rows of sub-totals (averages within sub-groups) to a summary worksheet, but I get the Ref error. How can I copy sub-group averages to...

Can you tell me whether there is a similar newsgroup to this one for Microsoft Access users? Thanks douglas

Here's my formula: =YEARFRAC(B3,$D$2) I get an error (#NAME$) What am I doing wrong? Thanks, Doug

I enter data in a column e.g. A1 : A50 How do I then in another sheet , by using the cell references, enter the data as a row in sheet 2 without having to do...

How do I enter a formula to apply to each individual line of a document?

Hello, Using Excel 97 on WINNT. Column C contains a start date (for example 20/12/2004 ) and column D an end date (for example 31/12/2004) for about 3000...

I would like to know the error message that appears when excel give when it cannot open a corrupt file ,or how do i corrupt a file to get the...

please help; how can i revover my excel file lal

I need to loop through the column and Copy entire rows where CellValue0 I get only one row. I will appreciate your help. Thank you Sub Macro3() ' ' Macro3...

Frank, Drats! Will have to do it the old fashion way. : ( Thanks for your reply! -- Galen W. Sievert "Frank Kabel" wrote in...

I created a document that has three pages. There are subheadings (cells) for each "group" of information and these subheadings (cells) are shaded...

Gord you're a genius! Thanks so much - that works a treat! Sorry I didn't get back to you last night - I'm in London and it was past my bedtime. The reason...