Hello,
I have the attached file with data from multiple employees. In tab LEAVE SOURCE I have a bottom that requests a password. Employees will have their own passwords.
First of all tab LEAVE SOURCE should only show the headers of the two tables. I would like to show the information from the employee of both tables based on the password submitted. The tab LEAVE TARGET is what my result would look like. Is this possible?
Thanks,
FG
Unfortunately, Excel does not allow you to filter each table separately. When you filter one table, the whole row is affected. If it would work for you to have the 2 tables on 2 separate sheets, I may have a solution for you. Please let me know.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thank you @Mumps1 for the explanation.
I can work with two sheets, I look forward to hearing from you.
I was thinking in another option. Maybe put the table that is located at the right at the very top and then the other table beneath this. However having two sheets also work for me.
Try the attached file. I have hidden the EMPLOYEES sheet because I added a column with a password for every employee (pw1, pw2, pw3, etc.). This way the passwords are not visible. You can make the sheet visible and change the passwords. I have also replaced the button with a drop down list where an employee can select his/her name. Upon selecting a name in cell F1, the tables in sheets LEAVE SOURCE and DAYS OFF will be sorted automatically. Also, when the file is opened, only the headers will be visible. To prevent any employee from manually removing the filters so they can see all the data, the sheets LEAVE SOURCE and DAYS OFF are protected with the password "myPassword". You can change the password in the macros to suit your needs. There are two macros. One is in the sheet code module for sheet LEAVE SOURCE and the other macro is in the code module for 'ThisWordbook'. Please let me know how it works out.
Thank you Mumps1. It worked great!
You are very welcome.
Hi Mumps1,
After doing some test I realized that when another employee opens up the file, he shows for a couple of seconds what the last employee saved. Is there a way to avoid this?
Also, when the employee is watching his records, he is not allowed to enter new data such a new leave.
When I tried opening the file, there was no data visible even for a split second. Are you using the file that I attached? When you sayon which sheet and in which column would the new data be entered?he is not allowed to enter new data such a new leave
Yes, I am using your file. Letīs suppose that employee1 used the file. When employee2 opens it up, he sees what employee1 was doing for a couple of seconds.
it would be from ColB through ColD. They need to select his name, start date and end date.on which sheet and in which column would the new data be entered?
Are you saying that the employee may want to add a new row with new data?
That is correct. That new row will go to last non empty row of the table. Is this possible?
Try the attached file.
Thank you again Mumps1, that worked great!!
My pleasure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks