querys from multiple sheets

[tlachena]

I have a workbook that conatins 31 sheets, 1 for each day of the month
and a report sheet. Each day has information i need to query but i have
been unsuccesful at creating a query to pull all the data into a
seperate sheet.
I'm not to savy on computer lingo so hopefully this makes sense.

 

[Gord Dibben]

It can be done either via formula or VBA.

Without knowing which cells from each sheet are to be queried it is hard to
say how this should be done.

Can you be more specific?

An example.........

You want to get a total from G23 on each sheet.

In a cell on Report sheet enter =SUM(ISheet1:Sheet31!G23)


Gord Dibben Excel MVP

 

[tlachena]

What it is is a text box and i need to create a list from thoses boxes.

IE

A B C D E F G
H I
0000 1 Zone 4
LAT LONG
0100
0200 2 Zone 9
LAT LONG

Thats a small section, A is the 24 hour clock,B thru D have information
that doesn't affect E thru I. E and F are counts for different types of
events. G is the area where the event occured. H and I are tha lats and
longs.

I was wondering if there is a way to query the rows that have
information. Is there a way to have excel create a query that sends the
information to a seperate sheet and eliminates the rows that only have
information in Colum E or F. IF there is info in E or F then G,H, I
will all be filled in