LinkBack URL
About LinkBacks
I have a workbook that is generated biweekly for payroll. How can i use the same totals tab (formulas) (in attachment) to total up each pay period?
I have a workbook that is generated biweekly for payroll. How can i use the same totals tab (formulas) (in attachment) to total up each pay period?
What do you want to see? Your current formulae are slighly incorrect... some $ were missing. I've tidied them up. But, what are they NOT doing that you want them to do?
Your explanation is too brief and you provided no expected results, so we're just left guessing.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
I'm so sorry...thank you for updating formula's...each payroll period i will download a workbook like the attached (sheet 1/2...1 sheet per employee) without the totals sheet...how can i copy the totals sheet to that workbook without reference errors,etc?
Thank you again
Hello craig37862 and Welcome to Excel Forum.
Try the following:
1. Right click on the Totals sheet tab
2. Select Move or Copy
3. Select the open workbook to which you want to copy the Totals sheet
4. Select Create a copy
5. Select (move to end)
Note that this assumes that AC will always be on Sheet1, AS Sheet2 etc.
Let us know if you have any questions.
PS Love the Smokey Mountain National Park. Especially elk rut in the fall at the Oconaluftee visitor's center and bears with cubs in the spring in Cade's Cove.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks