Auto Fill Different Sheets same cell on each sheet?
 

I have several worksheets with different client names. I am making a master
sheet that references a cell in each of the worksheets. How do I keep
referencing the same cell but on different worksheets, using autofil?

Auto Fill Different Sheets same cell on each sheet?
 

Hi

In you have a list of your sheet names in column A, enter this in B1 and
copy down

=INDIRECT("'"&A1&"'!A5")
where A5 if the cell that you wish to reference on each sheet. Amend to suit
your case.

Note the number of double and single quotes used
(" ' " &A1& " ' ! A5 ")
--
Regards
Roger Govier



"confused" wrote in message
...
I have several worksheets with different client names. I am making a master
sheet that references a cell in each of the worksheets. How do I keep
referencing the same cell but on different worksheets, using autofil?