The sheet name PRF in my workbook is the filtered from the table in "payment" sheet.
H1:M18 is actually meant to be the footer of PRF but if i put it at the bottom once I filtered to the next data it will be deleted.
Anyone here can assist me on the VBA codes to set the footer? The footer is meant to be in the last page should the list goes on further than 1 page long.
Bookmarks