Jayant
New member
I wish to create a excel macro to print only section of sheet1 on each day text is entered.
On 25th November, section of text is created in column A from Row1 to Row7. It is printed on 25th November.
On 26th November, New section of text is added in Column A from Row9 to Row15.
On giving print command on 26th November, printer should print only text added on 26th November leaving top print margin upto Row8 blank.
Idea is to print only the text added on following day without printing text of above sections.
Is there anyway, we can create a print macros to print section/sections with print command button autosetting top print margin.
This is just like Bank passbook printing done by banking software printing records from start date to end date, autosetting top margin.
On 25th November, section of text is created in column A from Row1 to Row7. It is printed on 25th November.
On 26th November, New section of text is added in Column A from Row9 to Row15.
On giving print command on 26th November, printer should print only text added on 26th November leaving top print margin upto Row8 blank.
Idea is to print only the text added on following day without printing text of above sections.
Is there anyway, we can create a print macros to print section/sections with print command button autosetting top print margin.
This is just like Bank passbook printing done by banking software printing records from start date to end date, autosetting top margin.