Database

[Sandra_Sada]

Good Afternoon,

I have to create a Tracking Spreadsheet that contains an Employee Name, position, Training Required, Date Trained & Date Verified. Keep in mind that different positions require different training. Position A would contain 9 different training rows and position B could be 3 different training rows. Each training row would need the name of the training required with a column for Date Trained, date verified, score required and score received.

ps, i can't use access because our company does not allow it.

What would be your best suggestion?

Please help and many thanks in advance!
Sandra

[Cerbera]

Hi Sandra,

It may be best if you could mock up in excel what you are expecting as the output of this project - if you post that it would be easier for people to comprehend what you are after.

Also what have you attempted thus far?

Cheers

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[Sandra_Sada]

I hope the attachment explains what I am looking for better. I would like for column C3 - C23 to automatically populate when B3 is inserted. and then i would move to row 24 and start all over again and add a title to B24 and so on. The drop down would be from Columne I, J & K.

I started using drop downs but then realized i wasnt going any where because i coudnt figure out how to insert the training required automatically. so then i started looking into v-look up but never suceeded.

Any help or suggestions of a better process is greatly appreciated!

Sandra

[Sandra_Sada]

the problem is that i don't even know what i am looking for. so to begin to be more descriptive is not working for me. Any suggestions?

http://www.excelforum.com/excel-form...ml#post3842725

[Cerbera]

Hi Sandra,

I'd go for something along the lines of "Autofill cells on cell update"

When you update the title - send the above url to Ford via private message.

I'll try to take a look for you at the sheet.

[FDibbins]

@ Sandra and Cerba....Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification.

All participants:
Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.