Copy selection based on Cell content...

[neilcarden]

Hi all,

I have a sheet which lists peoples annual leave as seen on sheet 'Copied'.

I want to be able to populate the 'Timetable' sheet when a name is typed in cell B2. In the example I have used Zenka Moore. When I type her name in B2 I want it to search the data on the 'Copied' sheet and display the 'Date' 'Time' and 'Paid Hours' values on sheet 'Copied' - as shown in the example.
Then obviously if I type in someone else name it throws up their holiday etc...

Thanks in advance.
Neil

[VBA Noob]

See if link helps

http://www.rondebruin.nl/copy5.htm

VBA Noob

[neilcarden]

Thanks - I'll take a look!!!