Hello,
I have an excel 2007 worksheet that I need to insert break page in order to print the pay receipt for one person in each page.
What I need is whenever column B showing "Net payable before taxes:", I need to add a blank row. Then add another row and write a statement "Have a nice day" on column A. Then insert a page break after the sentance.
I have about 200 employees for each pay period. I want to see if there is a macro can help me to do this work. I attached the file for your reference. Any help is highly appreciated!!!
Q
Bookmarks