Hi all,
I'm completely green at this moment in terms of VBA, but I know exactly what I need. Hopefully, this is a painless thing for someone to help with
I basically need a script which:
- filters column C by #N/A (result of a formula) - OR - does steps below before applying a filter, based on a match in C column (has to be #N/A)
- looks at each row of visible data, column B
- duplicates each row times equal to values in column B, if value is more than 1 then duplicates the whole row by that amount of times
Column A is just a reference number in this case.
Sample spreadsheet attached.
Thanks in advance!
Mat
Bookmarks