XcelNoobster
New Member
- Joined
- Jun 7, 2022
- Messages
- 40
So I have the following report:
I would like to create a VBA macro that when run does the following:
- removes the first 4 rows,
- adds new column "Item Number" and "Description" followed by all headers in row 7(ex. Item Number, Description, Level, Part Type/ Document Type, etc...)
- Adds that sections Item Number and Description to all the entries in that section(for example, Item Number: N711 should be added to the the rows from 8 - 13 THEN Item Number N6501-5 to rows 17-20:
This is what it should look like at the end:
I would like to create a VBA macro that when run does the following:
- removes the first 4 rows,
- adds new column "Item Number" and "Description" followed by all headers in row 7(ex. Item Number, Description, Level, Part Type/ Document Type, etc...)
- Adds that sections Item Number and Description to all the entries in that section(for example, Item Number: N711 should be added to the the rows from 8 - 13 THEN Item Number N6501-5 to rows 17-20:
This is what it should look like at the end: