recording totals in another workbook

[skycom]

I need a macro to copy the date, location and amount from an invoice an
paste it into another worksheet or workbook.
The result should provide a summary of all invoice processed.
Any ideas?:

 

[Frank Kabel]

Hi
i would start with recording a macro while doing this manually. this
should give you a starting point.

also see:
http://www.rondebruin.nl/copy5.htm