Hi all,
I receive raw data and would like to manipulate it using VBA in an automated way so its in a format to be loaded into Access.
There is three (or potentially more) tables of data on one worksheet (with 20 column headings of data and an unknown amount of rows), and just above every table will be a heading of PRIORITY 1, PRIORITY 2, etc. For example, cell A10 will have heading PRIORITY 2, then A11 to S11 will have the table headings and from A12-S12 downwards will be the data until there is two blank rows, then another heading say PRIORITY 3. The number of tables and the number of rows of data in each table are therefore unknown.
I would like a macro that aggregates all the data tables by getting rid of the blank rows and headings (PRIORITY 3, etc) and the column headings (except for the first one), and then cutting column D and inserting it in column A, for the whole worksheet.
The first table's heading will always be row 11, the first tables data will always start from row 12.
I'm sure this is a quick macro for a pro and would very much appreciate your help.
Thanks in advance,
J
I receive raw data and would like to manipulate it using VBA in an automated way so its in a format to be loaded into Access.
There is three (or potentially more) tables of data on one worksheet (with 20 column headings of data and an unknown amount of rows), and just above every table will be a heading of PRIORITY 1, PRIORITY 2, etc. For example, cell A10 will have heading PRIORITY 2, then A11 to S11 will have the table headings and from A12-S12 downwards will be the data until there is two blank rows, then another heading say PRIORITY 3. The number of tables and the number of rows of data in each table are therefore unknown.
I would like a macro that aggregates all the data tables by getting rid of the blank rows and headings (PRIORITY 3, etc) and the column headings (except for the first one), and then cutting column D and inserting it in column A, for the whole worksheet.
The first table's heading will always be row 11, the first tables data will always start from row 12.
I'm sure this is a quick macro for a pro and would very much appreciate your help.
Thanks in advance,
J