Hi All,
I have a .xlsm workbook that I use to create invoices for an organisation.
The workbook contains 2 worksheets:
Kliente - this is tabular list of client and their details. client (row) details (columns)
Faktuur - a form that is populated using data from the "kliente" worksheet.
I currently use a data validation list to select each name, and vlookup to populate the fields of the "Faktuur" sheet.
To save. I use a macro that creates a new workbook using the sequential number and save the new workbook, I then increment the sequential number and clear the "Faktuur" sheet for use by the next name.
The process is becoming tedious as the list gets longer.
I would Like to ask for help that process the list "automatically" using VBA. I have very limited coding knowledge and do not even know where to begin.
If required I can provide a copy my current workbook if it will help.
Thank you,
Dave Rapson
I have a .xlsm workbook that I use to create invoices for an organisation.
The workbook contains 2 worksheets:
Kliente - this is tabular list of client and their details. client (row) details (columns)
Faktuur - a form that is populated using data from the "kliente" worksheet.
I currently use a data validation list to select each name, and vlookup to populate the fields of the "Faktuur" sheet.
To save. I use a macro that creates a new workbook using the sequential number and save the new workbook, I then increment the sequential number and clear the "Faktuur" sheet for use by the next name.
The process is becoming tedious as the list gets longer.
I would Like to ask for help that process the list "automatically" using VBA. I have very limited coding knowledge and do not even know where to begin.
If required I can provide a copy my current workbook if it will help.
Thank you,
Dave Rapson
