Hello Everyone. I have a macro that saves a specific sheet from the master workbook into it's own workbook. It's nothing but raw data that we can use as a snapshot of a moment in time weeks down the road. No formatting or anything. Here is the VBA code.
I need to modify it. Currently another macro copies and pastes a lot of data to the backfill sheet so it's all in one place to save as it's own workbook. I changed the sheet so that formulas directly pull the data without having to go thru the whole select, copy, paste values etc. The data is simply there. So I ran the macro and it created a backfill file but it retained the formulas. I was wondering if up in the code where it saysPlease Login or Register to view this content.
can it be modified so that it only saves the values?Please Login or Register to view this content.
I can make it work by opening the new file and just copying and pasting over itself with values but I'd rather not.
Thanks for looking and any and all insight appreciated. And, if an obvious answer isn't available I will be happy to take pointers on where to go and study more.
Bookmarks