Thread: [Solved] Alternative ways to populate a spreadsheet
View Single Post
 
Old 05-09-2022, 12:10 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
Create the spreadsheet using formulas. Before sending the workbook to your boss, copy the range with all formulas, and from right-click menu use PasteSpecial.Values on same range. (In case you want to keep the formulas for later use by yourself, save the workbook as 1st step, then overwrite formulas with values using PasteSpacial, and then save the workbook with different name - and send the last one to your boss.)
Reply With Quote