I'd like to streamline some of my spreadsheets so that I only have to enter labor allocation in one place and it will flow through into multiple spreadsheets.
Attached is an example:
- Alloc tab - sample of a Labor Allocation spreadsheet where labor will be allocated by percentage based on departments and sub-departments
- PR Oct 10 through PR Dec 10 tabs - samples of a separate spreadsheet that will hold all the payroll data which will calculate totals by department based on the Labor Allocated spreadsheet (the Alloc tab in the sample).
What I'm trying to do is have:
1. Column D in the Alloc tab pull into Column D on the PR Oct 10 tab.
2. Column G in the Alloc tab pull into Column D on the PR Nov 10 tab.
3. Column J in the Alloc tab pull into Column D on the PR Dec 10 tab.
etc
Basically each month needs to be updated so that the current month's Labor Allocation flows into that month's tab for the Payroll (PR) spreadsheet (and a few other spreadsheets that I did not include here).
Any help? I can't figure out how to get the IF statement to work so that each month will be pulled properly.
Thanks!!
Bookmarks