Beladorizid
New Member
- Joined
- Mar 27, 2002
- Messages
- 1
Greetings all. I'm hoping to tap into your wisdom for a problem I am having.
I have designed a simple little spreadsheet in Excel 2000 that allows me to track active job candidates we deal with on our website. The information listed for each candidate is their name, then 5 coloumns (Interview Notes, Picture, PI, References and Test Scores) Now, the 5 coloumns are there to track when they have completed that stage of registration, so if Jane Doe completes her PI I can go to that coloumn next to her name and place an X there. In an additional coloumn to the far right of all others, I have a seperate coloums called "active"
Now as to the question, and what I am hoping to do.
I am hoping to be able to merge, link, group ... whatever .. an entire row so that if I move it, all of the appropriate x's will follow it. If I sort coloumn A by name, I want the appropriate row data to follow .. I hope I am clear enough on that.
I also want to be able to delete a name, have it delete the entire row of data, and slide the rest of the list up to cover the blank line.
I am able to send what file I do have via email if anyone wishes it, and could really use any aid I could get my hands on. I thank you in advance for all your help.
I have designed a simple little spreadsheet in Excel 2000 that allows me to track active job candidates we deal with on our website. The information listed for each candidate is their name, then 5 coloumns (Interview Notes, Picture, PI, References and Test Scores) Now, the 5 coloumns are there to track when they have completed that stage of registration, so if Jane Doe completes her PI I can go to that coloumn next to her name and place an X there. In an additional coloumn to the far right of all others, I have a seperate coloums called "active"
Now as to the question, and what I am hoping to do.
I am hoping to be able to merge, link, group ... whatever .. an entire row so that if I move it, all of the appropriate x's will follow it. If I sort coloumn A by name, I want the appropriate row data to follow .. I hope I am clear enough on that.
I also want to be able to delete a name, have it delete the entire row of data, and slide the rest of the list up to cover the blank line.
I am able to send what file I do have via email if anyone wishes it, and could really use any aid I could get my hands on. I thank you in advance for all your help.