search and replace number

Hi everyone,

A friend of mine asked me if it's possible to make a timetable.
I started with a basic table, where you can fill in the hours per day, per employee with a validation list.
Easy but it works.
However he asked me something else :

Is it possible to don't use a validation list, but use numbers/codes which stands for a certain time period?
for example : every time he fills in "1" it stands for 08:00-17:00 ; "2" is 08:00-15:30,....
After a macro has run, the numbers and codes will change into the right hours.

I hope the attachments makes it clear. I've used both methods

Should I work with VLookup?

Thanks for your advice
Star

Hey Maras, Ochimus,

Thank you for your solutions. I've tried both and the worked fine. At the moment I'm using the code of Ochimus, but I have an issue.
The sh.Range doesn't work. Whatever I fill in, the code keeps working over all cells of the sheet. And it needs only working over a range.
Star

Starchaser,

Can you please replace the code with this version, which sets SHIFTS in the sample as "C9:J10", not "C9:O19", and includes an Error trap that for some reason I omitted!

Please Login or Register  to view this content.

As in the original message, I assume you will change the range to the full range of those you want this to work on?

Hope this helps

Ochimus

Hey Ochimus,

It still doesn't work. Whatever range I use, you can fill in the codes on every cell of the entire worksheet.
Very strange...

Hi everyone,

I still can't figure out why the range doesn't work.
Anybody an idea?
thanks for the help
grtz