-
Insert a row and copy data if condition is met
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules