Hi,
I need a small help
i have created a macro which formats the text file into excel and creates page breaks after every 50 lines. If the data of a party goes beyond one page i would not come to know that for which party the data is continued on next page. I want to print the name of that party in first line of next page.
for eg.
this will be output assuming (--------)as a page break
DMJ JAG BEE Stores, SeONI
305-00505 BHENDI
305-00507 BHENDI
306-00302 HY BRINJAL
306-00402 HY BRINJAL
306-00502 HY BRINJAL
306-01002 HY BRINJAL
306-01902 HY BRINJAL page 1
----------------------------------------------------------------------------
page 2
306-03302 HY BRINJAL
307-00107 GUAR
308-00107 LOBIA
312-01304 CHILLY
312-01805 CHILLY
313-00107 CORIAN
314-00204 CUCUM
316-00204 HY BIT
319-00204 SPONG
322-00307 ONION
323-00104 PUMPK
326-00803 TOMA
326-00904 TOMA
I want output like this
DMJ JAG BEE Stores, SeONI contd.........
306-03302 HY BRINJAL
307-00107 GUAR
308-00107 LOBIA
312-01304 CHILL
312-01805 CHILL
313-00107 CORIA
314-00204 CUCU
316-00204 HY BI
319-00204 SPON
322-00307 ONIO
323-00104 PUMP
326-00803 TOMA
326-00904 TOMA
The sample file is attached for the kind reference.
Thanks in advance.
pk
Bookmarks