Hi all,
I am a VBA noob trying to automate my Excel and I wonder if the following can be done through VBA and if doable, how it should be done. To shorten the post, this is only PART 1 of the outcomes that I desire.
PART 1
Relevant Worksheets: "Invoice Date Entry Sheet", "Invoice Summary Sheet"
Brief Description:
In the "Invoice Date Entry Sheet", users are required to select the clients' name and month of billing (drop down lists). Users will then key in the transaction details e.g. consignment note number, description, type of service, etc. for the entire month. The transactions are arranged in rows and the details in columns.
Desired Outcome(s):
1. To have an "Update Summary" macro button in "Invoice Date Entry Sheet"
i. Copy data of all the transactions for the month from the "Invoice Date Entry Sheet" and paste the data on next empty row of "Invoice Summary Sheet".
ii. Clear all the data from "Invoice Date Entry Sheet" and go to clients' name cell.
Note: The purpose of the "Invoice Summary Sheet" is to have a full transaction details invoiced for the whole of the year. I am hoping that it will also be a source for soft copy invoices to be generated (see Part 2).
Thank you for your patience and I hope to hear from the experts in this forum real soon.
Kel
I am a VBA noob trying to automate my Excel and I wonder if the following can be done through VBA and if doable, how it should be done. To shorten the post, this is only PART 1 of the outcomes that I desire.
PART 1
Relevant Worksheets: "Invoice Date Entry Sheet", "Invoice Summary Sheet"
Brief Description:
In the "Invoice Date Entry Sheet", users are required to select the clients' name and month of billing (drop down lists). Users will then key in the transaction details e.g. consignment note number, description, type of service, etc. for the entire month. The transactions are arranged in rows and the details in columns.
Desired Outcome(s):
1. To have an "Update Summary" macro button in "Invoice Date Entry Sheet"
i. Copy data of all the transactions for the month from the "Invoice Date Entry Sheet" and paste the data on next empty row of "Invoice Summary Sheet".
ii. Clear all the data from "Invoice Date Entry Sheet" and go to clients' name cell.
Note: The purpose of the "Invoice Summary Sheet" is to have a full transaction details invoiced for the whole of the year. I am hoping that it will also be a source for soft copy invoices to be generated (see Part 2).
Thank you for your patience and I hope to hear from the experts in this forum real soon.
Kel