Finding data

[ctw_3]

Hi all, first post here at these forums

I have a question/ problem that hopefully someone can answer for me.

If anyone has the time, could they have a look at the attachment, i
was easier that trying to explain it. But in a nutshell it involve
finding data within sheets and totaling them on another sheet.

The problem is that in my real world example, I will have 40 sheets
and 100 rows of data, so performing it manually is out of th
question.

cheers, and thanks for your time.

Charli

+-------------------------------------------------------------------
|Filename: help1.zip
|Download: http://www.excelforum.com/attachment.php?postid=2792
+-------------------------------------------------------------------

 

[crispbd]

Use the excel help menu to lookup the SUMIF Function

To get the unique values in column A of sheet2, sheet3 etc, you can
select Data->Filter->AdvancedFilter etc to get unique records.


Alternatively, you could use VBA to setup an ADODB connection tha
treats the other sheets as database tables, and use SQL to query
summarize against them