Hey Guys,


I'm still farily new to VBA.

Was wondering how to do a copy and paste code from 2 different workbooks. situation as follows:

every month, I have to copy and paste updated ledgers into this workbook that has 30 sheets of different products.

each sheet within this workbook has monthly expenses( i.e. debits and credits) for the products.

so the one workbook has has all of the product sheets, and the other workbook has the updated monthly product info.

so instead of copying and pasting each updated product sheet to each excel product sheet monthly,

can anyone provide some assistance of how to paste the updated monthly data onto the master worksheet product tab

by using the last row used. Greatly appreciated, thanks.

Darell