How to setup summary sheet to transfer worksheet data

In your summary sheet, I changed the summary formulas at the bottom and added a blank row, be sure to NOT delete that blank row, it insures the rows that get added at the bottom each time you run the macro automatically expand the range those formulas evaluate.

This macro does what you want with the exception of the Memo column as that data does not appear to be anywhere on the invoice. We are currently using the shorter Item Name descriptions.

Please Login or Register  to view this content.

The macro must be activated with an Invoice onscreen, and it will check to make sure the Inv # is not already on the Summary sheet.