Hello,
I have a workbook with multiple worksheets - each containing the same format with data generated by Macro, Rand=() and Rand=() sorting colums by A to Z / Z to A.
Effectively, the same data/content just randomly different on each work sheet. I have two questions I hope somebody can answer.
Firstly, I would like to copy the workbook and 'extract' or output the value data only without any Macros or forumlas or Rand=() related output - so basically the copied workbook and worksheets would only contain 'text/data' with no formulas or macros, that will not be 'automatically' affected by any recalculation of the Rand=() function or any other forumla if I delete or refresh the worksheet/workbook. Sorry, I hope my explanation is clear enough and not too clunky.
Secondly, how to delete a colum i.e. B from each sheet in an enitre workbook by Macro or other means.
As ever, any assistance or suggestions greatly appreciated.
Thanks,
I have a workbook with multiple worksheets - each containing the same format with data generated by Macro, Rand=() and Rand=() sorting colums by A to Z / Z to A.
Effectively, the same data/content just randomly different on each work sheet. I have two questions I hope somebody can answer.
Firstly, I would like to copy the workbook and 'extract' or output the value data only without any Macros or forumlas or Rand=() related output - so basically the copied workbook and worksheets would only contain 'text/data' with no formulas or macros, that will not be 'automatically' affected by any recalculation of the Rand=() function or any other forumla if I delete or refresh the worksheet/workbook. Sorry, I hope my explanation is clear enough and not too clunky.
Secondly, how to delete a colum i.e. B from each sheet in an enitre workbook by Macro or other means.
As ever, any assistance or suggestions greatly appreciated.
Thanks,
