Linking workbooks?

[dee student]

Two workbooks. #1 is MASTER list workbook of all employees with current wages. #2 workbook is the PAYROLL report. I've linked the cells in the PAYROLL (#2 workbook) to the MASTER (#1 workbook) so when wages change they are updated easily.

Problem: When I add a new employee to the bottom of the column in the PAYROLL (#2 workbook) & link it to the MASTER (#1 workbook) the wages in the PAYROLL (#2 workbook) become jumbled.

Note: #1 Workbook is alphabetized by last name. #2 Workbook is organized by date of hire.

What method will work to maintain the integrity of the #2 Workbook wages? Thank you for taking the time to read this and possibly respond with a solution. I truly appreciate it.

[GeneralDisarray]

is there anyway you can post an example of these workbooks?

[dee student]

I would be happy to provide more infomation, but am unsure how to post an example.

[GeneralDisarray]

ok, to post an example, press the "Go Advanced" button at the bottom of the "Quick Reply" box.

Then, scroll down to "manage attachments" and press that button.

Then, press "add files"

Then, press "select files", browse for the file you want, press open,

Then when you return to the upload manager press done. That will make a file available with your reply :D


It would be very helpful to see an example of some toy data without any private information.