I have a workbook that contains a macro to save a copy of 2 tabs out on a
network drive, and then it loops, populates new data and saves those two tabs
again. The macro loops about 1200 times.  
My issue is that on the second tab I want to have a macro that copies and

I've created a roll-up worksheet within a workbook.
Numerical results are posted to C1 using results from B1/A1.
If numerical data in C1 is < 65% cell color in D1 turns red
If numerical data in C1 is > 80% cell color in D1 turns green

I have a problem somewhere in this formula but I can't determine
where:
=IF(ISERROR(ROUNDUP(AVERAGE(J5:M5),0)),0, ROUNDUP(AVERAGE(I5:L5),0))
If there isn't an error it should return the average of J5:M5 but its

If a column of data consist of currency, % and unformatted numbers, how do
you total only the data formated as currency?

Is it possible to hav auto-filter on multiple rows, say, row 3 for one group
of data AND row 10 for another group of data?
thank you !! jane

I have a graph built that automatically updates based on data that is
entered.  One of the columns that is graphed, has a formula of =MIN(cell
#,500), because I wanted it set so that if data entered is above 500, the
graph only charts 500.  If the data entered is below 500, then ...

Could someone advise, on finding annual growth rate equation.
Example is:-
An X items was valued at 13500 and after 24 Years it is
valued at 180000.

I am matching two sheets of data to each other through vlookup, and
even though i know that there are matches, vlookup isnt returning
them . the data in both the sheets in the same workbook is of the same
format (text) and all leading and trailing spaces have been removed,

I would like to have the "Range" portion of the VLOOKUP command be populated
from a user input.  Is this possible?
Ex: A2 has the formula VLOOKUP(1,A4:C12,1,TRUE) works.  Instead, I would
like for cell A1 to have the value: "A4:C12" and the formula in A2 to be

First, sorry for the long post and thank you for helping and looking.
I'm have this formula but it doesn’t work:
SUMPRODUCT(--(LEFT('[Spares Quotes List V22
26Apr2007.xls]All'!$A$2:$A$5000,4)=$A26*(YEAR('[Spares Quotes List V22

I Have a problem i try to solve...
I am building a Bowling spreadsheet workbook...
I am trying to do something, since they are assigning PTS, by total
pinfall....

I am trying to make a sheet that will auto populate the end of month date. I
found the "EOMONTH" and works great, but I need to dispurse this sheet to
many people who many different machines, and to have them try to add the
toolpak will be overwelmingly bad. I read someone had a ...

I have a work sheet that cell A1 requires you to enter a date in the
following format DD/MM/YYYY.
What I would like is if a date is entered into that cell that is not a
working day (i.e. Weekend or Bank Holiday) then I would like excel to either

2 Sheets: 1 data, 1 form..
I wish to enter data (or select from drop ) into a cell on Sheet One that
when it matches the column entry in Sheet2 Column A, it will take the data in
that matching row on Sheet 2 and populate other cells in Sheet One..

I'm using VLOOKUP to look up a value on another worksheet. The lookup works
fine when I use a constant for the sheet name but I get 'The Formula You
Typed Contains an Error' message when I try to pull the sheet name from a
cell on the current worksheet.