I have a data sheet where the number in Column C is a number that fluctuates between 0 and 64. I need to be able to add (x-1) rows above it. So if the number is 4, I'd like to add 3 rows above it (and copying all the other data from the same row). If above is not possible, then below is OK too. As an additional condition (but less important one), it would be good if in the inserted rows could count from 0 to the number it was based off (so in the previous example, the 3 rows would have 1, 2, 3 and end with 4). If that last sentence was too confusing, then just ignore it and I can make an IF function to build that out.
I think a macro is possible to make this happen but I have no macro experience at all.
Any help on this problem?
Thank you so much for any help you may provide.