Hi and thanx for your help...

I have column A which is 66 cells with a =if statments relating back to 36
different sheets(6 .xls files with 6 sheets in each. I need to figure out
how to get the Lots(from the 6 other sheets) to auto fill in on another sheet
into 24 cells. Without multiple lots and able to update.
A B
123 123
345 345
567 567
123
345

I also have the amounts used of each lot pulling off those other sheets by
using a Vlookup of the lot used then Sumif to total up the amount used of
each Lot from each of the 36 sheets.

I wastold to use this but it pulls the formulas over not what shows

go to data | filter | advance filter | choose copy to another location
| List range = $A:$A | copy to : $C$1 | check unque records only | ok


Any Ideas????????????