is there a way via vba to save and export a copy of a workbook as an xlsx using the original workbook and keeping that one open?
saying this is there a way to copy only sheets 3-8?
at the same time remove all queries and formulas keeping only the data
i tried PDF it is not possible to view or explore the cellls or see the separate worksheets it is very confusing
saying this is there a way to copy only sheets 3-8?
at the same time remove all queries and formulas keeping only the data
i tried PDF it is not possible to view or explore the cellls or see the separate worksheets it is very confusing