Is there something I can add (a formula) to the formula below so that when it brings over the value from the MAINDATA worksheet cells into the new worksheet, that is pastes the value?
In other words, the users will save the worksheet with the MAINDATA formula into a new spreadsheet/excel file and send it to an external company, and we need to have values and not formulas in the cells.
Fyi - I have the Excel 365
=IF(MAINDATA!S2<>"",MAINDATA!S2,"")
Bookmarks