Have created a statement of account report in Excel that will be used to process a range of creditor codes and page breaks upon change of creditor code. This report is designed using an Excel add-in. In the layout of this report there is a Page No. field in the Header section, and for this field it is required to display 'Page No.' of 'Total Page No.'. I am trying to create a user designed output using vb that will display display the Page No and Total Page No. for each creditor statement, and this Page No. needs to be reset to start from 1 again upon each change of creditor code. How do I do that?
Regards,
kinrarateoh
Bookmarks