How to apply changes to multiple sheets

  • Thread starter Thread starter sowetoddid
  • Start date Start date
S

sowetoddid

I have a "master" spreadsheet with all of the fields of data that ar
being collected (ex. Name, Phone No., Address, etc).


I would like the master sheet to have all of the columns (A through H
and a separate sheet that will have only rows A, C, and F from th
master sheet. How can I do this?

It should work so that when I update the master sheet, then the othe
sheet is automatically updated.


Thank you!
 
Hi
a simple solution. On your second worksheet enter the following in row
1:
A1: IF('master sheet'!A1<>"",'master sheet'!A1,"")
B1: IF('master sheet'!C1<>"",'master sheet'!C1,"")
C1: IF('master sheet'!F1<>"",'master sheet'!F1,"")
and copy this line down

HTH
Frank
 
I am running into a problem when I use that equation....


Some of my cells are empty, and that translates as a zero in the ne
spreadsheet.

Is there any way around this
 
Thank you!
Out of curiousity, what does <> do in your formula?
Click to expand...

The <>"" just checks if the cell in your master sheet is not empty. If
this evaluates to TRUE, the cell value is copied, otherwise nothing is
copied
Frank
 
...
...
=INDIRECT("Master!"&CELL("address",A1))
Click to expand...
...

And what happens if the OP or one of the OP's users inserts or deletes rows or
columns in this other worksheet? The A1 reference could be changed.

If the goal is that the formula in Other!A5 always refers to Master!A5 no matter
what changes are made to either worksheet (short of deleting all formulas in the
Other worksheet - self-destruction should remain an option), the most robust
form is

=INDIRECT("Master!RC",0)

While R1C1-style addresses may be a PITA to use interactively, they're more
robust than A1-style addresses for constructing robust textrefs.
 
Back
Top