I keep track of payroll for my father in law's Care Workers, I have weekly time sheets set up for the whole year, then I have the summary page at the end (I've tried in the same workbook and a different workbook). The summary page references back to each weeks payroll to get the date and each person's weekly hours. I would like to be able to have each week automatically go to the correct worksheet without having to manually enter in everyone. I want to copy and paste it down the sheet and have it reference the correct worksheet, if that makes sense. Currently I type in =then click in the correct spot on the worksheet for that persons total hours and hit enter. But I have to do it for each employee every week and would prefer to have it automatically do it for me.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copy formulas down a summary page to individual time sheets
- Thread starter pbebow
- Start date
Excel Facts
Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Ok so honestly I have no idea what I'm doing... I reopened the file so it was where we left off with the first code. I deleted all of the weeks that weren't filled in on the payroll page like you said to do. I clicked on Developer and Macro, then Edit?
Then it came up with these 2 pages open.
If I delete instead of edit it comes up like this
so I try physically deleting the code and replacing it with the new code but that's when I got the error before.
I'm sooo sorry that I'm so
Upvote
0
Yes! how do I do that?!
Upvote
0
kanadaaa
Active Member
- Joined
- Dec 29, 2019
- Messages
- 348
- Office Version
- 365
- Platform
- Windows
Ok I got it. You pasted the code into sheet modules.
In the Project tab in the code tab, you have the Microsoft Excel Objects section and the Modules section, right?
You pasted the code into a worksheet in the former section, which is why it didn't work.
The code must be in a STANDARD module, not in a SHEET module.
In the Project tab in the code tab, you have the Microsoft Excel Objects section and the Modules section, right?
You pasted the code into a worksheet in the former section, which is why it didn't work.
The code must be in a STANDARD module, not in a SHEET module.
Upvote
0
Um OK, honestly not sure what all of that means. Can you walk me through how to delete the first one completely and do the second one completely, like step by step?
Upvote
0
kanadaaa
Active Member
- Joined
- Dec 29, 2019
- Messages
- 348
- Office Version
- 365
- Platform
- Windows
In the Microsoft Excel Objects section, open the Sheet55 and Sheet56 modules.
I think you have the code in those sheet modules, but you can erase it altogether.
If you get rid of the code in the worksheet modules the right way, you should only have the Payroll macro in Macros in the developer tab.
So if the macros other than Payroll are gone in the image, you did it the right way.
And if the macro runs properly, it should ask you if you'd like to proceed to the next week, if there's more than one set of data available for output.
Once you're done with outputting the data you want, hit "no" when the message box asks you if you'd like to proceed.
With this function, you don't need to delete worksheets.
I hope this does the trick you needed?
But remember that data which have already been output can't be output again. (if you need a function to modify outputted data by a macro, you'll need another distinct code.)
But you'll just need to delete the relevant data on sheet "Payroll" the way you did to test the code in #14.
I hope this isn't too much of a hassle for you.
I think you have the code in those sheet modules, but you can erase it altogether.
If you get rid of the code in the worksheet modules the right way, you should only have the Payroll macro in Macros in the developer tab.
So if the macros other than Payroll are gone in the image, you did it the right way.
And if the macro runs properly, it should ask you if you'd like to proceed to the next week, if there's more than one set of data available for output.
Once you're done with outputting the data you want, hit "no" when the message box asks you if you'd like to proceed.
With this function, you don't need to delete worksheets.
I hope this does the trick you needed?
But remember that data which have already been output can't be output again. (if you need a function to modify outputted data by a macro, you'll need another distinct code.)
But you'll just need to delete the relevant data on sheet "Payroll" the way you did to test the code in #14.
I hope this isn't too much of a hassle for you.
Upvote
0
kanadaaa
Active Member
- Joined
- Dec 29, 2019
- Messages
- 348
- Office Version
- 365
- Platform
- Windows
Ok sorry actually there's a faster way to do that.
1. In this dialog box, select Sheet55.Payroll or Sheet56.Payroll and press Delete (ignore the red square in the image)
2. Do the same for the other
3. Done
1. In this dialog box, select Sheet55.Payroll or Sheet56.Payroll and press Delete (ignore the red square in the image)
2. Do the same for the other
3. Done
Upvote
0
Ok thank you for all of your time. I do appreciate it!
Upvote
0
Similar threads
- Solved
