I want to make all of my data hard numbers, remove formulas or all reference values, similar to Copy and special paste but without doing it with copy and special paste, can I just do whole spreadsheet hard numbers with any function?
I want to make all of my data hard numbers, remove formulas or all reference values, similar to Copy and special paste but without doing it with copy and special paste, can I just do whole spreadsheet hard numbers with any function?
Why dont you want to use copy paste special values? I mean that might take two or three seconds.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
I have around 6 separate spreadsheets, that I need regularly to remove referenced values or formulas, I am guessing I cant do it without opening them one by one, so I thought at least there might be function to hardcode numbers automatically without choosing all cells and pasting back. So there is not that option right?
Are you saying that it is one workbook with six sheets in it or is it six separate workbooks?
yes six separate workbooks, basically I have one master excel file and 6 other excel files that are getting filled form master file, ideally once filled I want all of dependent files to have hardcoded numbers with minimal effort. So far only option I see is opening them one by one and copy pasting as hardnumbers
Since you have not provided any data to test, here is some untested VBA for each file
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
If you don't want to manual working every time, why not link up workbook from master file, you need only add one column as Pick Data & mentioned as PICK which you extract into your workbook. If you provide sample with dummy data master file & workbook that's more effective.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Save as > CSV?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks