Is there something easier than a merge???

[Guest]

I have a spreadsheet containing multiple worksheets. Each worksheet contains
different info. for the same 73 centers. I now need to print out the data
for each center individually & would like to condense the info. to a minimal
amount of pages (3-4).

Is there a way to do this besides manually creating a Merge doc. in Word?
My spreadsheet has a grand total of at least 30 headers. It could get
ugly...

I still haven't figured out how to do a Merge using multiple worksheets
anyway...

 

[Guest]

What do you mean by "headers"? Do you mean describptive column headers such
as Address, City, State? Can you treat each worksheet like a database table,
meaning, does each worksheet have some sort of ID code for the 73 centers,
with data pertinent to each center across a row?

If that is the case, you can use Microsoft Query (Data->Get external
data->New database query) and treat each worksheet like a separate table in
Access or SQL server. Then you create a query that links all the sheets on
the basis of the center ID columns and pull all the data into one results
table.

If your sheets are structured some other way, then you are probably stuck
doing the cust and paste routine.

FWIW and IMO, using Excel as a data management tool is bound to lead to
problems like you are encountering here. It's almost always worth the effort
to put the data into Access or some other database software and maintain it
there.