copy column data from one array to another - Code to create colSortedArr fully functional
My google/duckduckgo foo have utterly failed me this morning. Everything I am finding has to do with .AutoFilter on a worksheet. NOT what I need, will not do the job.
2 workbooks:
1 = Master multiple tables with 100+ identical columns in each table.
2 = Comm, with 1 table having 41 column headers that use the exact same column name as the tables from the Master.
As a temp. process of learning, I have successfully made an array from 1 hard coded table in the Master to build an array that is in memory for the Comm containing the columns with their full data.
This full data will, in some cases, be more data than is required. I now need to filter down the data in the Comm array floating out there in memory by the sub-network and delete all rows that do not match the sub-network criteria. Followed by deleting any rows that are empty based on the group column.
The deleting of rows within array searches have also pointed me to ONLY deleting rows within a worksheet, not within an array in memory.
Do I?
1. use some form of filter?
2. loop through the colSortedArr to find the sub-network I am looking for and somehow copy that row to a new array?
2a. if I do #2, do I need to copy the column headers over?
3. other options?
Desired outcome. Data in colSortedArr is 1st filtered on City/Network either !=, or = sub-network and delete all rows that are unwanted. 2nd filter remaining data on the group column if any cells in that column are blank, delete that entire row. 3rd paste remaining data into the Overview2 worksheet in the Comm workbook.
My google/duckduckgo foo have utterly failed me this morning. Everything I am finding has to do with .AutoFilter on a worksheet. NOT what I need, will not do the job.
2 workbooks:
1 = Master multiple tables with 100+ identical columns in each table.
2 = Comm, with 1 table having 41 column headers that use the exact same column name as the tables from the Master.
As a temp. process of learning, I have successfully made an array from 1 hard coded table in the Master to build an array that is in memory for the Comm containing the columns with their full data.
This full data will, in some cases, be more data than is required. I now need to filter down the data in the Comm array floating out there in memory by the sub-network and delete all rows that do not match the sub-network criteria. Followed by deleting any rows that are empty based on the group column.
The deleting of rows within array searches have also pointed me to ONLY deleting rows within a worksheet, not within an array in memory.
Do I?
1. use some form of filter?
2. loop through the colSortedArr to find the sub-network I am looking for and somehow copy that row to a new array?
2a. if I do #2, do I need to copy the column headers over?
3. other options?
Desired outcome. Data in colSortedArr is 1st filtered on City/Network either !=, or = sub-network and delete all rows that are unwanted. 2nd filter remaining data on the group column if any cells in that column are blank, delete that entire row. 3rd paste remaining data into the Overview2 worksheet in the Comm workbook.