Hi,
I have a data in which device movement will be tracked, I wanted your support in creating a user form code for the same. The details are as follow.
There is a data for 30+ columns for 27 centres, each centre will be managed by different employee, we will be giving them a user and password, if the user name and password matches then only that centre data should be visible to edit in the user form. You may see in the screen shotSections Screen Shot.png. There are 3 sections I have made for better understanding,
Section 1:
This will contain the user name and password and location all thee should match, if these are matching then data should be appear in “Live inventory or with me devices” box in section 2. IF "Device Actual Status" column contains "In Transit" and "Currently used centre" contains that particular centre name the device ID should appear in “Device sent to me from others and to be acknowledged by me” box in section 3 only of that particular centre which is available in excel already. Here the live inventory means the same location in column A and sent to me mean the last column location (For these column A is different and Column AC is different.
If the user name and password not matching then error should be occurred and workbook should close.
Section 2:
While section A meets its criteria then live inventory tab should contain data. If the executive wanted to modify any data he should click on those particular record, as and when he click on the record further details of those records should be automatically appear in required columns given there.
Section 3:
Here the data is whoever sends me the devices for my project use from his centre will be considered as sent to me devices, for example, if column A is Bangalore that means Bangalore person having the device 1 and he is sending that to me for my project use to Mumbai. And he will update my centre name as Mumbai in last column “Currently used centre”, hence whoever is sending me the devices from their centre should be appear in my “Device sent to me from others and to be acknowledged by me” box, as and when I receive these devices via courier I will acknowledge these and add them in my live inventory, so here whatever the devices are available I will select them and click on “Acknowledge device” tab and it should move to my live inventory, when this process done these devices should be moved from section 3 to section 2, and also these devices should only have the data in only two columns 1. Device ID and 2. Manufacturing ID, and also once this is acknowledged the entry should be removed from the sender list as well.
Access rights
Admin – Should have the complete rights when they use India as Location with their name and password accordingly and also can view all sheets.
Team Lead: Should have the executives rights with New Entry making rights (here the new entry means these are not at all there in excel already and newly purchased devices. This person can view main data and pivot sheet and not backup sheet.
Executive: should only have the right to update the details as and when they update the correct password, these should not have the new entry making rights(only editing). Apart from Admin nobody should be able to change the data via main sheet they should change the same by using the user form only.
I have created a few columns in user form which can be seen in the drive I am here by sharing the link
https://drive.google.com/open?id=0B-...kNxWXJZUWRFTGs
Bookmarks