auto pasting

**Davycc** · 08-20-2010, 09:04 AM

Hi all

Please help....

I have a roster which is to be made out everyday, in cols D and I have drop down lists with staff names. When a staff members name is chosen say in D10 the corresponding name on the list in col M is highlighted to show it has been used on the roster.

My question is, when I choose a staff member I have to manually insert their start finish times beside their name in cols E and J. Is there a way to automatically paste what ever start finish times are beside their names in col N i.e Patricia Phillips entered in D11 and the times of 1300-2200 automatically pasted into E11.

If anyone could help me with this I could probably be home earlier for a beer.

Thanks

**arthurbr** · 08-20-2010, 09:42 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**Davycc** · 08-20-2010, 10:53 AM

Hope this is better

**Davycc** · 08-20-2010, 12:11 PM

If this can't be done please let me know I'm going bonkers trying to sort it.

**Davycc** · 08-20-2010, 03:34 PM

Please any help would be great

**Davycc** · 08-22-2010, 03:43 PM

Please help

**arthurbr** · 08-24-2010, 02:18 AM

In E9 enter =IF(COUNTIF($M$5:$M$25,D10),VLOOKUP(D10,$M$4:$N$23,2,FALSE),"") and pull down as needed

be aware you are using lots of merged cells. If they are to be used for darta manipulation they will cause lots of trouble. Better use " center across selection" if you really need the cosmetics

**Davycc** · 08-24-2010, 07:05 AM

arthurbr YOU ARE A STAR !!!

I take on board re the merged cells and will set up the sheet again and refer back to the formula (I'll learn from having to adjust it .

Thanks again