Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking multiple sheets
I need to set up a spreadsheet that links to 12 others. On each of the
others there may be 100 rows(or less) of information to bring in to the master. Is it possible to write a formula that enables the link to pull in only rows that contain information? I don't want blank rows between each of the 12 groups of information |
#2
|
|||
|
|||
I'm sure an expert will chime in with something better, but I've done similar
with lookup functions. don't do it direct or it will be slow. I let everything come over to one master workbook, then use a lookup page that consolidates the data. "JMR" wrote: I need to set up a spreadsheet that links to 12 others. On each of the others there may be 100 rows(or less) of information to bring in to the master. Is it possible to write a formula that enables the link to pull in only rows that contain information? I don't want blank rows between each of the 12 groups of information |
#3
|
|||
|
|||
Thanks for the input. I don't have much experience using lookup functions.
I asked someone I work with for assistance. "widman" wrote: I'm sure an expert will chime in with something better, but I've done similar with lookup functions. don't do it direct or it will be slow. I let everything come over to one master workbook, then use a lookup page that consolidates the data. "JMR" wrote: I need to set up a spreadsheet that links to 12 others. On each of the others there may be 100 rows(or less) of information to bring in to the master. Is it possible to write a formula that enables the link to pull in only rows that contain information? I don't want blank rows between each of the 12 groups of information |
#4
|
|||
|
|||
Once you get the hang of the Vlookup you will wonder how you got along
without it. Each week or month (depending on size) my distributors send me the txt or excel file with their inventories. I open my master inventory control workbook, go to their page, and run a vlookup down a column to import their inventory, calculating their sales to project needs. No typing other than the formula, which is mostly point-and-shoot. "JMR" wrote: Thanks for the input. I don't have much experience using lookup functions. I asked someone I work with for assistance. "widman" wrote: I'm sure an expert will chime in with something better, but I've done similar with lookup functions. don't do it direct or it will be slow. I let everything come over to one master workbook, then use a lookup page that consolidates the data. "JMR" wrote: I need to set up a spreadsheet that links to 12 others. On each of the others there may be 100 rows(or less) of information to bring in to the master. Is it possible to write a formula that enables the link to pull in only rows that contain information? I don't want blank rows between each of the 12 groups of information |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking References from Multiple Sheets to One Summary Sheet | Setting up and Configuration of Excel | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Multiple sheets selected | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |