in sheet1 i have data in A2,A4,A7,A13, AND SO ......(MULTIPLE BLANK ROWS). now i want to past data from sheet2 or new worksheet , how can i past my data into blank rows of sheet1 without disturbing data of shee1.
in sheet1 i have data in A2,A4,A7,A13, AND SO ......(MULTIPLE BLANK ROWS). now i want to past data from sheet2 or new worksheet , how can i past my data into blank rows of sheet1 without disturbing data of shee1.
If you are only pasting one row at a time, then
would put the copied data in the next empty cell of column A. As the blanks are filled, the 'Range("A1").End(xlDown).Offset(1)' looks for the next blank.Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks