Hi - I have a refreshed report that I pull in daily/weekly from our HR system. How can I preserve the formuals within the template? After each refresh, all the formuals get wiped out. Any help is appreciated!
Thank you.
Hi - I have a refreshed report that I pull in daily/weekly from our HR system. How can I preserve the formuals within the template? After each refresh, all the formuals get wiped out. Any help is appreciated!
Thank you.
I think that what you need to do is to start the macro recorder.
And step through the spreadsheet and fill the formulas in each cell.
Stop the recorder.
Import your new data.
Run the Macro,
Your formulas should be reinstated.
perhaps have the formulas on a different sheet (or even different WB)?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks