Hiten Vakharia
Board Regular
- Joined
- Sep 25, 2013
- Messages
- 66
Hi,
I would like to create a macro where data is picked from the row and is copied to 10 additional worksheet on the same spreadsheet.
If the worksheet is not the spread sheet then to create a new worksheet and paste the data.
eg. On sheet1 I have;
Row 1 - abc
Row 2 - def
Row 3 - ghi
Row 4 - jkl
Row 5 - mno
Row 6 - pqr
Row 7 - stu and so on....
I would like to copy ENTIRE row1 and to be pasted on sheet2, same as row2 on sheet3 and so on....
Please let me know if I am not clear
Thanks in advance
Regards,
Hiten
I would like to create a macro where data is picked from the row and is copied to 10 additional worksheet on the same spreadsheet.
If the worksheet is not the spread sheet then to create a new worksheet and paste the data.
eg. On sheet1 I have;
Row 1 - abc
Row 2 - def
Row 3 - ghi
Row 4 - jkl
Row 5 - mno
Row 6 - pqr
Row 7 - stu and so on....
I would like to copy ENTIRE row1 and to be pasted on sheet2, same as row2 on sheet3 and so on....
Please let me know if I am not clear
Thanks in advance
Regards,
Hiten