Good morning,
I tried to copy Sheet1 from row 2 to the second last used row and then paste to Sheet 3 from row 7.
Then copy Sheet 2 from row 2 to the second last used row and then paste to Sheet 3 just after the row which contains the second last used row of Sheet1 data.
The second last rows in sheet1 and sheet 2 are volatile.
Any ideas will be highly appreciated.
Dennis
I tried to copy Sheet1 from row 2 to the second last used row and then paste to Sheet 3 from row 7.
Then copy Sheet 2 from row 2 to the second last used row and then paste to Sheet 3 just after the row which contains the second last used row of Sheet1 data.
The second last rows in sheet1 and sheet 2 are volatile.
Any ideas will be highly appreciated.
Dennis