Automatically add records from a new sheet to master sheet


H

hamad.fatima

hi,
I have 15 sheets with same format . One of themis a master sheet whcich
is adding infomration from the cells and rows form the other sheets in
the same rows and cell.
Suppose Master sheet adds all the records from Sheet from cells B1 of
SheetA2 to SheetA14 in cell B1 of Master sheet.

The problem is the number of sheets is dynamic. everytime there is new
data ,a new sheet is inserted like A15 , A16 and so on .
Is there a way for the master sheet to recognize the new sheet and add
the same ( row col ) data in itself.

I would really appreciate your help.

Thanks
 
Ad

Advertisements

R

RagDyer

You can add 2 "dummy" sheets, one after the master, before SheetA2, and the
other after whatever your last sheet is ... A14 or whatever.
Name these sheets "Start" and "End" (no quotes).

Then, as you create new, additional sheets, place them before the "End"
sheet, keeping all sheets that you wish to have calculated in between the
"sandwich" of the "Start" and "End" sheets.

Now, you revise your formula to something like this:

=Sum(Start:End!B1)

You can create "what if's" by dragging a particular sheet *out* of the
sandwich, therefore removing it's values from the totaling formulas.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top