Auto Fill Different Sheets same cell on each sheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 ")
 

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

Similar Threads

Code to format cells on several worksheets 2
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Reference to sheet name in another workbook 3
Formulas referencing different sheets in workbook 1
Auto fill across multiple worksheets 3
Sheet Names and Auto-calculation 2
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Excel Excel Vlookup formula based on cell data 7

Back
Top