Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel - Multi Sheet lookup
CAVEAT: The workbook you want to query, must have Sheets formatted as Tables -- One or more Sheets with One row of Headings, rows of data under each heading and no other data on the sheet.- Silvery01
- Post #5
- Forum: Microsoft: Office
-
Excel - Multi Sheet lookup
Sadly the sheets that the data is pulled from contain LOTS of other vital information. I was looking for some kind of magical VBA script :) Silvery01- Silvery01
- Post #3
- Forum: Microsoft: Office
-
Excel - Multi Sheet lookup
I have a multiple sheet spreadsheet that looks like this: Names jan feb mar apr may jun jul Name1 1 1 1 1 1 1 Name2 1 0.5 0.5 1 1 0.5 Name3 1 1 1 1 And so on. The information for these sheets is pulled from 8 separate sheets that exist elsewhere within discreet project folders. This...- Silvery01
- Thread
- Replies: 7
- Forum: Microsoft: Office
