TheSetBack
New Member
- Joined
- Apr 15, 2024
- Messages
- 1
- Office Version
- 2021
- Platform
- Windows
Hello all,
Been an avid follower the recent months looking to create a tracking sheet that delineates to the right after each ending week passes. The tracker has been made and now wanting to introduce a module with the intent to automate the the storing of tracked data. The code I'm looking for should be able to grab the last columns of data and copy and insert to the right (7 different Columns). All the formulas are set in the last column and the copying and inserting will reflect the new week aka the last column (to the right). The VBA code should grab the last column in the type of data tracked to copy and insert to the right, and if possible paste values of the original copied data to the formulas are then "hard keyed" as they will change. I understand this is a big ask, and have been working up the courage to make this post. Thanks for taking the time to read!
Been an avid follower the recent months looking to create a tracking sheet that delineates to the right after each ending week passes. The tracker has been made and now wanting to introduce a module with the intent to automate the the storing of tracked data. The code I'm looking for should be able to grab the last columns of data and copy and insert to the right (7 different Columns). All the formulas are set in the last column and the copying and inserting will reflect the new week aka the last column (to the right). The VBA code should grab the last column in the type of data tracked to copy and insert to the right, and if possible paste values of the original copied data to the formulas are then "hard keyed" as they will change. I understand this is a big ask, and have been working up the courage to make this post. Thanks for taking the time to read!
