Currently in my spread sheet There is a Main page, on that there is a button called 'CREATE NEW CLIENT'. When clicked it runs this macro to import a template used for each client
Sub AddTemplateSheet()
Dim sTmplt As String
Dim sht As Object
That template is the completed with the clients details such as name, address etc.
Each template has a set of columns which start at the below cells
Date - C23
Bus - F23
Bus&Train - G23
Invoice - H23
Vouchers - M23
Cash - N23
PC2 - O23
Also in the workbook there are pages for Each month of the Financial year 'April_2017' and so on.
Is there a way, determined by what date is entered on the clients page, the data is duplicated onto the financial year month page?
The financial year columns start as below
Date - C15
Invoice - I15
Bus - J15
Bus and Train - K15
Cash - L15
PC2 - M15
Voucher - N15
Otherwise it means entering the details twice.
Also, on the clients page,
E4 - Name
E5 - Ref Number
Can that be duplicated in to columns on the financial year page
The name column starts at E15 and the Ref number column begins at H15
This needs to work for every template which is imported.
There is a first and last page where the clients page is concerned. The page before the first client page is called 'Totals' and the page after the last client page is called 'Last'
Hope you can help.
Many thanks
Luke
Related:
Copy template worksheet multiple times and rename based on a list
