I've got a two-sheet workbook on Excel 2003. One sheet will hold various
information about employees and their paid benefits--one employee per row,
each column a benefits category. The other sheet is a calculator of how all
those benefits add up so employees can see their full compensation package.
I finally figured out the calculations based off one row of the first sheet,
but my question is how (short of copy-pasting and re-entering row numbers in
each formula) I can get that second page to vary according to which employee
(row) I want to print and present.
In other words:
if one of my formulae reads:
=(Census!$F8*52*Census!$E8+Census!$G8*52*1.5*Censu s!$E8-C14)
(Census is the first sheet's name)
and 8 is the row number for a specific employee.
How can I make that "8" variable so I can choose which row from the census
sheet is currently represented in the Calculator sheet?
Would there also be a way that with one action I could print that data sheet
with all possible employee iterations (one page per employee/row)?