Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    1

    Red face Unanswered: managing a payroll

    Hi, I created a payroll in the excel sheet called sheet1. It contains the entire list of all the employees. Now I am creating individual sheets for everyone in the same workbook. Is there any option if I change the salary details and the allowances in sheet1, it should also reflect in the respective sheets automatically? Your help and opinions are most welcome

  2. #2
    Join Date
    May 2009
    Posts
    258
    In order to achieve this, you will want to use a formula in the individual sheets that references the salary details and the allowances cell(s) in sheet1.

    The formula in the individual sheets would be something like this:
    Code:
    =sheet1!A2
    Replace "A2" with the cell reference that you want to be applied to the other sheets.

    Regards,

    Ax

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •