Specific data from one worbook to another (Excel 2010).

Hello there,

I have two workbooks, one is an accounting spread sheet (named Cash Book) and the other has an Invoice Template (sheet 1) and Invoice Register (sheet 2) simply named Tax Invoice & Statement Template.

The Cash Book has 14 tabs (Totals, 12 tabs for each month of the year and a Summary). Each month has a separate Income and Expenses section. From the Invoice Register in the second workbook, I would like to extract the following data: Date Paid, Customer and Amount Paid and send this information to the Cash Book but to the relevant month e.g. any amounts paid during April go into the April income, amounts paid in May go into May income etc.(with the Date Paid and Customer details of course). There may be only one payment during a month or there may be a dozen payments in a month so a "NextRow" function would obviously be needed.

Anybody have any ideas for a macro or am I askig too much of VBA?

Cheers,
vcoolio

Hi Nathan,

No I haven't. The macro for my Invoice template works really well (increments the invoice number, saves the invoice to another file, clears contents and posts the basic invoice details to a register) but what I am asking is full of variables and I basically haven't got a clue where to start!

Cheers.