Hi There,
I have gone through your files. I have two questions:
1. Your requirement says that you need a ledger developed with cumulative amount from the two sheets. So, what you are saying is the "Amount" column in both the sheets are same. I mean are they supposed to be cumulative?
2. Is "Product" a criteria in calculating the cumulative amount?
About me, I am a professional VBA Developer, Excel Guru and Visual Basic 6 expert with over 21 years of experience. Everyday I create spreadsheets, Visual Basic applications, macros, VBA coding (for Windows) in Access and Excel to provide my clients with the business solutions they need.
If you think that I am the right person, for your job, then let's discuss this project further.
Thanks & Regards,
Sanjay.