| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto fill of cell with information from seperate sheet | Excel Worksheet Functions | |||
| how to auto fill information from a table to another sheet | Excel Worksheet Functions | |||
| auto fill from another sheet in excel | Excel Worksheet Functions | |||
| Help!: lead sheet data needs to fill appropriate subject sheets | Excel Worksheet Functions | |||
| Help!: lead sheet data needs to fill appropriate subject sheets | Excel Worksheet Functions | |||
Linear Mode
