Hello All,
I have searched a few sites but with no luck. I am in need a VBA code that will create new row based on a condition. The condition is whether Column "O" contains any information. If so, create a row below the original and copy "A:AT" and paste into that new row.
I will need to continue to run this unless there is a way to make the same condition above but for Columns P, Q, R...thru AD. I can change the code manually if it becomes too complicated.
Any help would greatly be appreciated!
I have searched a few sites but with no luck. I am in need a VBA code that will create new row based on a condition. The condition is whether Column "O" contains any information. If so, create a row below the original and copy "A:AT" and paste into that new row.
I will need to continue to run this unless there is a way to make the same condition above but for Columns P, Q, R...thru AD. I can change the code manually if it becomes too complicated.
Any help would greatly be appreciated!