Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
querys from multiple sheets
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. -- tlachena ------------------------------------------------------------------------ tlachena's Profile: http://www.excelforum.com/member.php...o&userid=29119 View this thread: http://www.excelforum.com/showthread...hreadid=488367 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
querys from multiple sheets
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 On Sat, 26 Nov 2005 11:16:48 -0600, tlachena wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
querys from multiple sheets
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 -- tlachena ------------------------------------------------------------------------ tlachena's Profile: http://www.excelforum.com/member.php...o&userid=29119 View this thread: http://www.excelforum.com/showthread...hreadid=488367 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
selecting multiple sheets | Excel Worksheet Functions | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Multiple sheets selected | Excel Discussion (Misc queries) |