Was wording if anyone knew of a way to run a SQL to create a new block of data from a pre-existing block of data in the current active workbook???
I am very used to using SQL statements to extract data from databases into excel workbooks and would dearly love to use SQL to manipulate the data already in the current active workbook.
Is this remotely possible or just a pipe dream???
Thanking in advance