Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to know which row to append for the last row
dear all,
i manage to create header(from header sheet) and details(from detail sheet) data and paste in final sheet. i face the problem of putting the last row which is the trailer of the record from trailer sheet. all i use macro to do it. in the copy and paste what function to use in macro to identify which is the row immediately after the last detail row. please help and thanks alot. 142130091000100Merseng Khung 16102004 14213009100018811218900112373000000000005000D.S KRISA A/P D. SEL821105146056 14213009100018815402200005114000000000012025DAVID ANAK PALIT 770623135923 14213009100018816218400030391000000000009500ELLY MARINA SAERDG 791010105396 1421300910001881111111111 000000000009900THIS IS TESTING 9999999999 14213009100018822222222 000000000004500THIS IS 2ND 33333333333 14213009100018833333333 000000000034500THIS IS 3RD 444444444 HOW TO KNOW THIS IS THE TRAILER |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to know which row to append for the last row
I think the line wrapping has screwed with your example.
Just a guess, but could you check to see if the first character of each line is numeric? -- Rob van Gelder - http://www.vangelder.co.nz/excel "tango" wrote in message om... dear all, i manage to create header(from header sheet) and details(from detail sheet) data and paste in final sheet. i face the problem of putting the last row which is the trailer of the record from trailer sheet. all i use macro to do it. in the copy and paste what function to use in macro to identify which is the row immediately after the last detail row. please help and thanks alot. 142130091000100Merseng Khung 16102004 14213009100018811218900112373000000000005000D.S KRISA A/P D. SEL821105146056 14213009100018815402200005114000000000012025DAVID ANAK PALIT 770623135923 14213009100018816218400030391000000000009500ELLY MARINA SAERDG 791010105396 1421300910001881111111111 000000000009900THIS IS TESTING 9999999999 14213009100018822222222 000000000004500THIS IS 2ND 33333333333 14213009100018833333333 000000000034500THIS IS 3RD 444444444 HOW TO KNOW THIS IS THE TRAILER |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you append one row to another? | Excel Worksheet Functions | |||
Append worksheets together in one | Excel Discussion (Misc queries) | |||
Qn: How to Append??? | Excel Programming | |||
append row | Excel Programming | |||
open for append | Excel Programming |