Consolidating??

  • Thread starter Thread starter David French
  • Start date Start date
D

David French

I have a situation where I need to consolidate several sheets up to one
master sheet.
Here's the scenario:
We have 4 branches for each of the departments to budget for. I'll use the
Sales Department in this example.
Branch 1 is where Smith and Jones work.
Branch 2 is where Johnson and Edwards work.
Branch 3 is where Hansen and Justino work.
Branch 4 is where Burger and Collins work.

The consolidated sheet contains all 8 names.
The individual sheets contain only the 2 names that work in that location.
There is a code that identifies them on the individual and the consolidated
sheet.
So far I'm planning on making individual formulas to bring the numbers to
the consolidated sheet.

Is there a consolidation method that will look to the codes to match the
correct code on the individual sheet to the correct code on the consolidated
sheet? I know that VLOOKUP would normally be the choice but in this case
there would be several LOOKUP TABLES.

Please help.

Dave French
 
David
Is this an ongoing task that you have to repeat every so often? Are
these "numbers" in the individual sheets in the same cells all the time?
If the source cell locations are constant then you can set up formulas
one time and be done with it. If the source cell locations are variable
then you might need a macro. The same situation exists if the destination
cell locations are variable. Post back with more detail of how your data,
both source & destination, is laid out. HTH Otto
 
Back
Top