Relative Reference to Multiple Worksheets

[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.

 

[Jim]

Have a look at http://www.j-walk.com
....search for INDIRECT

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays

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.