Copy row by the number in a specific column
Hi,
If there is a 1 in column B do not copy, but if there is a 2 in column B then insert a copy of that row below.
If there is a 3 in column B then copy that row and insert it twice below and if it is a 4 in column B then insert it 3 times below. The row copied does not have to be inserted directly under the row.
Thanks for any help,
David
attach a sample before and after
Maybe this works:
I hope that helps.
Please Login or Register to view this content.
---------- Post added at 01:42 PM ---------- Previous post was at 01:37 PM ----------
Just a small comment, that code won't work too well if you have rows which have nothing on column B.
.?*??)
`?.???.?*??)?.?*?)
(?.?? (?.?Pichingualas <---
??????????????????????????
Wrap your code with CODE TAGS.
Thank those who helped you, Don't forget to add to their REPUTATION!!! (click on the star below their post).
Please mark your threads as [SOLVED] when they are (Thread Tools->Mark thread as Solved).
Thank you very much, that works perfectly and column B always has a number but thanks for the comment
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks