Questions for VBA in Excel
Hi I'm new here. I was wondering if anyone knew how to use VBA in Excel. I am currently trying to do an assignment for a class and I don't know where to go. I am desperate for help. The tutors have not shown up to help for the past two days. All semester we have been taught on VB and they suddenly sprung this VBA on me and I don't understand!
Here are the definitions:
-The employee.csv file has 5 employees, each with a unique employee number and full name.
-The transactions.csv file has 50 records, an employee number, and total of the invoices they submitted.
-Create a Workbook with a command button on the first sheet.
-The button should read all the records in the file one line at a time and create an individual sheet for each employee in the Excel workbook.
-The transaction file should be read one line at a time and each transaction should be written to that appropriate employee's worksheet.
-Once all the transactions are read the records are sorted and totaled.
-The worksheet should be sorted into alphabetical order.
-The employee's names and totals should be written into a Report sheet in alphabetical order.
They suggest making individual modules for the following sub procedures: delete existing worksheets, process employees, process transactions, sort worksheets and generate report.
The things in bold are what I need help in.
If anyone has any idea how I should go about doing this, your help would be greatly appreciated! Thanks!
Here are the definitions:
-The employee.csv file has 5 employees, each with a unique employee number and full name.
-The transactions.csv file has 50 records, an employee number, and total of the invoices they submitted.
-Create a Workbook with a command button on the first sheet.
-The button should read all the records in the file one line at a time and create an individual sheet for each employee in the Excel workbook.
-The transaction file should be read one line at a time and each transaction should be written to that appropriate employee's worksheet.
-Once all the transactions are read the records are sorted and totaled.
-The worksheet should be sorted into alphabetical order.
-The employee's names and totals should be written into a Report sheet in alphabetical order.
They suggest making individual modules for the following sub procedures: delete existing worksheets, process employees, process transactions, sort worksheets and generate report.
The things in bold are what I need help in.
If anyone has any idea how I should go about doing this, your help would be greatly appreciated! Thanks!
