hello,
my workbook has 12 sheets. each sheet represents a month.
in each sheet i can have 4 to 8 tables depending on the workbook
each table(product) has four columns
date - incoming - outgoing - running balance
naturally the running balance from one month is carried forward to the next month for each product.
i am building a workbook which will be used as a standard since ill copy paste the workbook around 60 times for the 60 clients I have.
how do i write a vba code that is transferrable in all the workbooks that no matter how many tables in the first month, the code will transfer all these tables in every single month sheet with the same format with the dates updated for each month and a runnning balance carried over.
Bookmarks