SCoonrodQS
New Member
- Joined
- Aug 24, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Howdy all,
I have some code that parses data from a CAD csv BOM and it aligns text sets font, inserts 23 rows with category names after cell A2.
I then have to manually find information and cut and paste rows of data under those categories, then color code them. Then I have to color code a column based on if it has data in it until it gets to the last category, which is left normal. I then have to use another color for 3 column based on if they have data in the cell.
I also have to add borders around each category and the rows underneath to separate the categories.
Is there a way to cut and paste a row based on text in that row to the "next empty row" under a category?
I have some code that parses data from a CAD csv BOM and it aligns text sets font, inserts 23 rows with category names after cell A2.
I then have to manually find information and cut and paste rows of data under those categories, then color code them. Then I have to color code a column based on if it has data in it until it gets to the last category, which is left normal. I then have to use another color for 3 column based on if they have data in the cell.
I also have to add borders around each category and the rows underneath to separate the categories.
Is there a way to cut and paste a row based on text in that row to the "next empty row" under a category?