I wish to do a small project for the department I work for.
I wish to automate some of the paper works from the showroom sales level.
Here is the story:
The document to be automated is called the ‘Sales Sheet’ which has a unique series number for each sales sheet. The sales sheet has many columns to be filled by the sales advisors, similar to a form. This would be at showroom level as per the immediate requirements of the potential customer.
There should be a single Master excel file for this purpose. On double click, this file opens directly as a userform for user inputs. This will be similar to the columns on the sales sheet. Each userform that opens will have a unique sales sheet number generated by the VBA program. When the sales advisor finishes the input, he saves the set of data. These data saves as a single record(row) in a sheet on the master excel file. There will be multiple sales advisors saving data at the same time, each saving his own unique record. The record is saved against the unique sales sheet number. The sales advisor on another occasion can retrieve the sales data saved under his name and make changes to the same. A sales advisor can also open and read the sales sheet record created by another sales advisor but cannot make changes to the same. A sales administrator/manager has the right to make changes to the sales sheet record of any sales advisor.
Please contact for further details.