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...

please help; how can i revover my excel file lal

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...

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...

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

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...

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

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

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...

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 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 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 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...

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...

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...

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.

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...

I have a file in excel. Accidently I wrote in it and saved it which I didnot want. Now I want the original file in which I have not over written. I want the...

i can't find the worksheet tab in the bottom line,when open an exist xls file,i can see only one worksheet, but it has more than 3 ,what happen? how can i...

I am currently hosting a vote for forum logo. So far we have 13 submissions. I would like to have an instant runoff vote that allows the participants to give...