Paste from one to many

[wegkruip]

Dear Sir/Madam

I need some help.

I’ve got a folder on my C: drive named Test. This folder contains a sub folder “TestSubFolder” and a workbook “Primary Workbook.xls”. “TestSubFolder” contains all my customer’s individual accounts. The total customer accounts are unspecified.

Every day I enter customer payments into “Primary workbook.xls”. At the end of the day I will have a list of all customer payments received.

I want a macro that when a button is pressed, updates all the individual customer accounts with the payments made and then clear the list in “Primary Workbook” for the same procedure the next day.

It sounds tricky. I hope someone can help me with this.
Find attached a sample of the “Primary Workbook.xls” and a few customer account samples.

Thank you very much for all the help.

[antoka05]

See attached file where I added below macro.

Macro will automatically insert formula in column 'E' of customer sheets. Initially you need only to put first theree rows (titles and row with Opening Balance).

Please Login or Register  to view this content.

Regards,
Antonio