I have a workbook that has two work sheets. Work sheet one has a column containing ten digit service order numbers and the invoicing data related to these service orders. Work sheet two has a column with the same service order numbers but data relating to the hours spent by technicians on the service orders, I would like a user to be able to select a cell with a service order number in one work sheet and then trigger a macro via hot keys to go to the same service order number in the other work sheet to view the other data. I have tried to do this via the macro recorder by copying the selected service order number, switching do the next work sheet, going to edit -.> find, paste and then find. However this only finds the service order number used when I created the macro. Can someone please help with a way I can make this work?