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

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

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

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