rbowie1980
New Member
- Joined
- Aug 3, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
hunted all day for a solution so really hope you guys can help?
I have a data table (used for a s-curve) that returns a value from another table, once I am happy with the data I manually copy and paste values for that week.
I'm looking to automate the copy and paste values process by means of a button.
So once I click the button all the formulas under the date that are = to a date in "B1" are removed and I'm left only with the values.
Thanks in advance
I have a data table (used for a s-curve) that returns a value from another table, once I am happy with the data I manually copy and paste values for that week.
I'm looking to automate the copy and paste values process by means of a button.
So once I click the button all the formulas under the date that are = to a date in "B1" are removed and I'm left only with the values.
Thanks in advance