mswon20
10-04-2018, 05:30 AM
I'm trying to write a code that will do the following
1) If cells in column D is larger than 99
2) Insert a row below
3) copy data from columns A-C:E-F into the new row created below
4) If cells in column D in the new row created is larger than 99, repeat step 2-3 again
As I am still new to VBA, I could not to write anything that works. I appreciate any help you can provide. Thanks.
1) If cells in column D is larger than 99
2) Insert a row below
3) copy data from columns A-C:E-F into the new row created below
4) If cells in column D in the new row created is larger than 99, repeat step 2-3 again
As I am still new to VBA, I could not to write anything that works. I appreciate any help you can provide. Thanks.