There are 20 worksheets within one Spreadsheet. I

want to automate the ‘export’ of the data values

out of ‘selected’ columns (8 out of 20) from all the

worksheets to a new spreadsheet in order to build

PivotTables.



The need for a ‘new’ spreadsheet is

due to the presence of many ’blank ‘ cells (null)

within the columns. I’m not permitted to modify

the source spreadsheet.



The Client wants to have a way to facilitate the

analysis of the huge amount of data that is in the

source spreadsheet – thus the use of PivotTables.





VB Code to export to the ‘new’ spreadsheet

using Label names  and Range names would help.



I’m open to any alternative approaches that you, or

the others could suggest. Any help would be

appreciated.