Formulas referencing different sheets in workbook

  • Thread starter Thread starter lori
  • Start date Start date
L

lori

I have a workbook for calcing backpay. Each worksheet is an employee. There
are around 50. Then I have a summary sheet listing the employees going down.
On the first employee in the summary, I have formulas adding different cells
on his sheet. I would like to copy those formulas down for each employee.
How do I get the formula to copy the same cells but referencing a different
worksheet. Is it even possible?
 
Well, you can retain the cell numbers by putting dollar signes in front of
the letter and number like so:

A1 would be $A$1. This way, you can copy in any row or column, and it will
always reference A1.

As for the tab name, I find it easiest to copy the formula that references
the first sheet, paste it all the way down, then highlight your 2nd
employee's data, go to Edit - find - Replace, put the 1st employee's tab name
in the find box and the 2nd employee's tab name in the replace box, then hit
replace all.

Do the same for employee 3 to employee 50 using employee 1's tab as the
find, and changing the replace poriont with your 3rd through 50-th employee's
tab names.

Hope that jumble made sense.
 
Back
Top