Summary of what I want to do:
I have been working on this part of my macro where I want it to add some rows with text in the rows based on a letter that is in a cell of that row. I also want a separate part of the script to cut and paste a row based on the letter that is found in a particular cell of that row. lastly, I want to check if a column has something in it or not and delete columns that don't have anything in it...
First Script:
If there is an "N" in Column B, then I want the macro to insert 2 blank rows above that "N" if there is no "N" already in the row above it. Also type in bold font "Row inserted" in column A of the first inserted blank row (The one above the column with the "N" in it).
For an example, if Row3 Column B had the letter "N" in it, then the result would be the words typed "Row Inserted" in Row1 Column A in bold font with Row2 being completely blanks and then Row3 Column B having the letter "N" in it.
Second Script:
In a separate part of the script script. If there is an "O" in Column B, then I want to cut the entire row which contains the clumn with the "O" in it and paste it below the last row that has an "N" in column B … but this time I want to skip 2 rows so there are two blanks rows bafter the row with the "N" in the B column and before the row with the "O" in the B column. then type in bold font "Row Inserted" in Column A of the row that was inserted and is right above the column that has the "O" in it. The result would be the column with the O cut and pasted two rows below the last column with the "N" in it and the words typed 'Row Inserted" in bold above it in Column A
Third Script:
I want the script to check if there are empty cells in column A, and if there are then delete the rows with the empty cells.... not just deleting the cells, but the entire rows so that the rows come together and column A does not have any gaps in it between cells that have values in them.
Visual examples of what I am describing in Script 1 and 2 are attached.
Any help is appreciated. Thanks in advance.
Bookmarks