I have 3 columns
Part No Description Qty
Ineed a macro to go to column (Qty) and insert that no of rows in, -1
and to copy the data down as well
Example
A B C
01009 Ram 3
01009 Ram 3
01009 Ram 3
01005 Spacer 2
01005 Spacer 2
010002 Door 1
hope this is clear enough
thank you
Part No Description Qty
Ineed a macro to go to column (Qty) and insert that no of rows in, -1
and to copy the data down as well
Example
A B C
01009 Ram 3
01009 Ram 3
01009 Ram 3
01005 Spacer 2
01005 Spacer 2
010002 Door 1
hope this is clear enough
thank you