I've attached an example, but basically I need to copy something entered in the Total Jobs sheet by using the Store column into the matching Store Sheet. I want to keep everything in the total sheet though, so it's just duplicating. So if Row 5 was the first "Store2" it would populate the correct info under the headers (Row 5) in the individual sheets. Any help I would greatly appreciate. Thanks for your time.
Nate
Or if it's easier to do it vice versa that could work as well.... meaning you could enter values into individual worksheets and then it would auto-populate the Total Jobs sheet. Thanks.
See notes in my signature for how to implement. Hope this helps.
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".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks