combining/compiling multiple worksheets into a master

  • Thread starter Thread starter KJ
  • Start date Start date
K

KJ

I need to create a workbook with multiple sheets (<255) on
which will be tracked activities. The info on these
sheets will be sorted by columns as needed. When
combined, these sheets will respresent all the activities
done within an identified geographical area or by a
particular service provider. I would like to have a
function, macro, command, (???), something to
automatically combine this info into a master worksheet
without copying each sheet or entries. Is there a way of
doing this?
 
Hi,

Your best bet is to avoid all this combining in the first
place, by having all information on one single sheet in a
simple table structure. Then you can use Excel's excellent
built-in options to extract summary data from that single
sheet. Your users can use the Autofilter (data, filter,
autofilter) to filter the data for their own region.

Regards,

Jan Karel Pieterse
Excel TA/MVP
 
Hi


Jan Karel Pieterse said:
Hi,

Your best bet is to avoid all this combining in the first
place, by having all information on one single sheet in a
simple table structure. Then you can use Excel's excellent
built-in options to extract summary data from that single
sheet. Your users can use the Autofilter (data, filter,
autofilter) to filter the data for their own region.
Click to expand...


Or you create a special report sheet, where you can select a particular
service provider, and all info about him will be displayed, using links to
main sheet or functions like VLOOKUP(), OFFSET(), SUMIF(), SUMPRODUCT(),
etc.
And when your main sheet grows too huge, then you obviously have selected a
wrong tool at all - you have to use p.e. Access instead.

Arvi Laanemets
 
Back
Top