Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check rows and paste
Hi,
Can VBA check that the last row is the empty without data from sheet1 of "test.xls" first,follow by copy the data from sheet1 from "test.xls"and paste it to new sheet1 of new "book1.xls". If the last row is blank, append another rows of data from another sheet eg sheet2 from "test1.xls" eg In test1.xls, sheet1 Row 1 Date Name Contact Row 2 20/04 John 2346712 Row3 20/06 Jane 1234678 Row 4 20/06 Kelly 2345678 imagine i delete row3 "Kelly" above, I hane left only Row 1 Date Name Contact Row 2 20/04 John 2346712 Row 3 20/06 Kelly 2345678 Copy the above data from sheet1 of "test1.xls" and paste into sheet1 of "Book1.xls". I will have data as in sheet1 of "Book1.xls" as below: Row 1 Date Name Contact Row 2 20/04 John 2346712 Row 3 20/06 Kelly 2345678 This will append the data from row 0 from sheet2 of "test1.xls" as shown below: sheet2 of "test1.xls" have Row 0 Date Name Contact Row 1 20/04 Jerry 2346712 Row 2 20/06 susan 2345678 therefore, I will have overal data in sheet1 of :Book1.xls" as shown below: Row 1 Date Name Contact Row 2 20/04 John 2346712 Row 3 20/06 Kelly 2345678 Row 0 Date Name Contact Row 1 20/04 Jerry 2346712 Row 2 20/06 susan 2345678. please advise. regards, Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check box, copy / paste or insert / delete row | Excel Worksheet Functions | |||
Copy and Paste Check Boxes | Excel Discussion (Misc queries) | |||
if formula to check text and paste link | Excel Discussion (Misc queries) | |||
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) |