I gang

AUTOMATION

Hi Everyone,

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.

Færdigheder: Excel, Visual Basic

Se mere: sales sheet automation, program administrator, excel sheet customer details, data input administrator, advisors excel, vba right, right vba, showroom, sales sheet, excel automate, automation project , automation program, contact form columns, excel data automation, excel right click, excel unique, form saving, excel inputs, vba userform, vba data form, master project manager, immediate excel vba, automate number, vba sheet, master paper

Om arbejdsgiveren:
( 0 bedømmelser ) ABU DHABI, United Arab Emirates

Projekt-ID: #303728