I need a way to change the cell value with the value of another cell on certain sheets. On the attached workbook, there will be roughly 75 sheets like the one named Gerardo Rivera. In those sheets, I need the value of D49 to update with the value of F49 each week I run payroll.
It would be nice to have a button I could click that would accomplish this just on the employee tabs, no the rest of the workbook.
As always, thank you in advance for the help!
2013 Payroll (3).xlsm
Please make a copy of your workbook and test on that copy. I wasn't entirely clear from your original post, but gave it a shot. Good luck.
Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
This works perfectly! Thank you very much...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks