lisaspencer
New Member
- Joined
- Jul 20, 2020
- Messages
- 21
- Office Version
- 365
- Platform
- MacOS
Hi
I've been looking online and have found a few options of people to help with this but because it needs to use Macro (and I'm new so not 100% sure), don't know how to configure it for my own sheet.
Basically I have live information updated frequently on Workbook 1 and the information is Vlookup-ed using a formula and ImportRange into Workbook 2. Workbook 1 is often changed here and there but after a certain date, it becomes locked information. I want the formula I currently have in Workbook 2 to paste itself as the current value so that it never changes.
Closest answers I've found are below: can anyone help at all?
stackoverflow.com
I've been looking online and have found a few options of people to help with this but because it needs to use Macro (and I'm new so not 100% sure), don't know how to configure it for my own sheet.
Basically I have live information updated frequently on Workbook 1 and the information is Vlookup-ed using a formula and ImportRange into Workbook 2. Workbook 1 is often changed here and there but after a certain date, it becomes locked information. I want the formula I currently have in Workbook 2 to paste itself as the current value so that it never changes.
Closest answers I've found are below: can anyone help at all?
Paste formula as value on a certain date
I've been digging around on line for a couple of hours now to no avail. I'm trying to write a formula(which I assume is only possible through AppScript), that based on a certain date, will re-paste
