Auto Invoicing using data in multiple worksheets

[amberosamemosa123]

Have been trying to find some example VBA codes to create original invoice numbers, print all invoices, print invoices not paid and to auto populate data from multiple worksheets when a specific customer is selected.

I have tried doing the auto population of data on invoices for each customer using VLOOKUP and INDEX-MATCH and I am have difficulty retrieving the next set of customer charges on each worksheet. HELP much appreciated! Thank you!

Sample workbook attached with sample data.

 

[Abdul Matheen]

Hi,

could you explain in better way what exactly you want, i will try to resolve that.

Regards,
Abdul Matheen

 

[amberosamemosa123]

I have the invoice layout as I would like it set up on the invoice worksheet. The boxes on the side describe the macros I would like.
Save and clear
Method
Select customer in top merged cell, below the company logo.
Auto populate mailing address -vlookup
Auto populate all services specific to customer. Service data is separated by category in different worksheets. For example: I want to select customer 1 in the invoice worksheet, have their mailing address pop up, then under the column headers (description, duration, amount, quantity, total), I want all services from customer 1 to auto populate to show all services. Customer 1 has a bunkhouse, 2 lockers, and boat.
Save as an original invoice number, clear contents, then generate next original invoice number for customer 2

Print all invoices
Print all invoices after every customer has been given an original invoice number with all services displayed

Print unpaid invoices
As customers make payments (do not want these to create new invoice numbers, keep original invoice number)
Input payment data in payments worksheet
Auto update/populate invoice worksheet for each customer as payments are made
Print all invoices that still have a remaining total after payments have been made