Excel Workbook to be pasted as Values
Posted on 2012-03-14
I have a Master file Report that has 189 Sheets. They are one page data results per a particular sales region. The data in the report results in multiple VLookUPs from many other data sources.
I have to email this report, but want to copy it and paste it as values so not so large with all the look up. How do I do this without going into each sheet copying and re pasting as values? Can I copy the entire Workbook and past as values?