• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating a reference sheet to employee file listing

Y

yawwwn

New Member
Hi guys,

I intending to create a listing that includes all the details of our employees, present in their personnel files. Although the listing would be good to keep track, it could not be viewed as easily. I've created a tab for reference and 2 tabs for employees listings of different divisions.

I'm not too sure if this is possible but I hope it could
frown.gif
.

For a new employee file, I would key the required in tab "Reference", and based on the division in Cell C1, the details would be produce in its respective tabs as well (as shown in the example in excel). After I have a whole long list of details in the division tabs, for easy viewing, the details would be reflected in Tab 'Reference' when I key in the ID of the employee in Cell C4. So i could either print the sheet or for easy reference.

Hope that was clear!
 

Attachments

Hi:

Find the attached , Click on the smiley to run the code. I am not sure how you want to capture the data if you have more than one category in documents removed. Anyways here is the first pass.

Thanks
 

Attachments

Nebu said:
Hi:

Find the attached , Click on the smiley to run the code. I am not sure how you want to capture the data if you have more than one category in documents removed. Anyways here is the first pass.

Thanks
Click to expand...
Hi Nebu,

Thanks alot. It worked fine! Can I request for a few minor changes though :)?

To capture the data if I have more than one category, is it possible if it just creates 2 more columns(categories; documents removed) in the respective tabs. So lets say if I have 20 documents of that sort, it automatically creates (20 x 2) additional columns?

Also, can the reference sheet reflect the details in the respective tab when I key in the ID No. in C1? i.e. if I key in 00001 in C1, all the neccessary details would change, triggered by that change. e.g. Chris Pratt in C5, etc

THanks!

-yawwwn
 
Hi:

The additional columns for the documents removed is added , you do not have to add it manually the code will do it for you. I did not understood the second part of your question, as per your OP you are using the excel spread sheet as a data entry form not as a data retrieval form where in you key in ID no and the others fields are populated automatically, you need a different set of macros to do that.

Thanks
 

Attachments

Nebu said:
Hi:

The additional columns for the documents removed is added , you do not have to add it manually the code will do it for you. I did not understood the second part of your question, as per your OP you are using the excel spread sheet as a data entry form not as a data retrieval form where in you key in ID no and the others fields are populated automatically, you need a different set of macros to do that.

Thanks
Click to expand...
Ohhh ic. I thought they could work both ways. I would actually require the data retrieval one more urgently than the data entry one :/
 
Hi:

Find the attached. the add button is to add new record to the data sheet and the retrieve button is to retrieve data from the data sheet based on ID No if you key in ID No in C4 and press retrieve it will fetch the corresponding data for you.

Thanks
 

Attachments

Hi Nebu, thanks alot! much appreciated. Could you also help me add in an "edit" button such that when i retrieve to the reference sheet i can simply edit and the changes would reflect in the same row?

Also, when i select the "Checkbox" and click "Add", it shows "(Unchecked)" in the new sheet. I couldn't figure out why
 
Hi:

It is showing Unchecked since I have code it that way what you want to show in the data sheet if the check box is unchecked? The operation you are asking is Update function which will be another set of codes. First you decide which all operations you want to perform from the data entry tab, Like Add, Delete, Update, show next record , show previous record etc and let me know rather than feeding it as piecemeal.

Thanks
 
Hi Nebu,

What i meant was it is showing unchecked when the checkbox is checked. I apologise for feeding it as piecemeal as I wasn't really sure what I needed initially. Not too adept with this. Anyway, if you wouldn't mind, I would need update, show next record and show previous record. THanks alot.
 
Hi Nebu,

I couldn't use the "update" button. Everytime I use it, it shows "No record Exists", even if the ID no. matches.
 
Hi Nebu,

the update works fine. Does it also include the update for the "documents removed". Meaning if I add more documents removed, and click "update", does it add more columns.

Man...I'm really sorry for the hassle
 
Hi:

The code should ideally do that , the reason I asked you to play around in the file by trying out all the possible operations you want to perform.

Thanks
 
yup. done that. I realise it will only add more of new 'documents removed' into the sheets if there is a heading in Row A. E.g. so lets say initially I only have 4 documents removed. When I add in a fifth one in the reference sheet and click 'Update', it does no change to the other sheet. However, only when I manually type in "Category 5" and "Documents removed 5" at the top, the changes will appear.
 
You must log in or register to reply here.
Back
Top