Hello Everyone,
Your help would be greatly appreciated. I am looking for some code that would copy some specific rows and paste them on the same sheet, one below the other, equal to a number put in a separate box. At the same time I would like to rename one of the cells in each copied groups. For example:
A1=3
Original
XXXXX =Name1
YYYYYY
ZZZZZZ
Copy
XXXXX =Name2
YYYYYY
ZZZZZZ
Copy
XXXXX =Name3
YYYYYY
ZZZZZZ
Any help with this would be so great.
Thanks!!!
Your help would be greatly appreciated. I am looking for some code that would copy some specific rows and paste them on the same sheet, one below the other, equal to a number put in a separate box. At the same time I would like to rename one of the cells in each copied groups. For example:
A1=3
Original
XXXXX =Name1
YYYYYY
ZZZZZZ
Copy
XXXXX =Name2
YYYYYY
ZZZZZZ
Copy
XXXXX =Name3
YYYYYY
ZZZZZZ
Any help with this would be so great.
Thanks!!!