Okay
I need help in extracting sheets in a workbook. And I need to make all related sheets into a simplifed version of no formulas or whatsoever, but just figures. How do I do this? I think I am beginning to lose my mind
Okay
I need help in extracting sheets in a workbook. And I need to make all related sheets into a simplifed version of no formulas or whatsoever, but just figures. How do I do this? I think I am beginning to lose my mind
Select all the cells in all the sheets. Copy and Paste Special as values.
regards
johnjohns
When you are not sure where to go, every road takes you there!
If you have some cells which show values according to the formula, do this:
1. Copy the cells containg values
2. Right click where you would like to paste these values
3. Select 'Paste Special' from the pop up form
4. In 'Paste Special' window select the "values" from option buttons
I am sorry if it does not helps your problem. Its better to attach your excel sheet to better understand your problem.
Regards
Hmm, that's the problem. Someone ask me to write a VBA code to extract files from a folder, and I did that, now that person wants me to extract tab from each files and put it into another workbook instantly; and that tab must be a simplified version; without any formulas or anything, just figures I guess.
Than copying all your sheets to a new workbook and then pasting all the formulas as values, you better save the same w.book in another name and then convert the formulas to values. If you can detail the requirement with sample workbook(s), it would be better.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks