Relative Reference to Multiple Worksheets

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

Guest

How do I copy a formula that refers to another worksheet but uses a relative worksheet name

For example, I have worksheets labelled Emp1, Emp2, Emp3, etc. I have a summary worksheet with rows for each employee. I want to be able to type in a formula to refer to a specific cell in the EmpX worksheet and copy that formula down throughout the entire summary worksheet. I have not been able to type in a relative reference for a worksheet - I have to enter the worksheet as Emp1 - and then when I copy it down to the next row (and want Emp2), it stays Emp1.
 
Have a look at http://www.j-walk.com
....search for INDIRECT

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
Janet said:
How do I copy a formula that refers to another worksheet but uses a relative worksheet name?

For example, I have worksheets labelled Emp1, Emp2, Emp3, etc. I have a
Click to expand...
summary worksheet with rows for each employee. I want to be able to type in
a formula to refer to a specific cell in the EmpX worksheet and copy that
formula down throughout the entire summary worksheet. I have not been able
to type in a relative reference for a worksheet - I have to enter the
worksheet as Emp1 - and then when I copy it down to the next row (and want
Emp2), it stays Emp1.
 
Back
Top