I have a chart that has 3 columns.
Warehouse #, Item #, and Description.
When i import data into this worksheet there are certain headers in the description column that i would like copied into the rows that are under that description. Example:
Description:
Title 1
Data 1
Data 2
Data 3
Title 2
Data 1
Data 2
Data 3
Title 3
and so on...
So what i am asking for: Is there a macro to move the titles to the end of the rows which have the data in them and then delete the title rows so that only the data is left in the description column with the matching title at the end of the data rows?
Warehouse #, Item #, and Description.
When i import data into this worksheet there are certain headers in the description column that i would like copied into the rows that are under that description. Example:
Description:
Title 1
Data 1
Data 2
Data 3
Title 2
Data 1
Data 2
Data 3
Title 3
and so on...
So what i am asking for: Is there a macro to move the titles to the end of the rows which have the data in them and then delete the title rows so that only the data is left in the description column with the matching title at the end of the data rows?