Index/Match in VBA

[Justmegan93]

Currently I used this formula to check the data on a table (separate workbook) and if the date of the shift and the employee's pay number match with my master sheet "paste" their start and finish time into the master sheet cell so further calculations can be done.

Please Login or Register  to view this content.

This seems to do the trick although a little slow as I have around 200 employees
The thing is I now want the "pasted" cell to also carry the same format which I don't think would be possible as a formula and I may have to create a user defined function ?
I am not really sure how to go about this so any help is greatly appreciated

[LokeshKumar]

Hi,
If it works slowly then please upload both the sample workbook......will try to help...

[Justmegan93]

Sample Master.xlsmSample Table.xlsm

Hi
I have attached sample files of both the master and the table

Thank you

[Justmegan93]

Hi,
If it works slowly then please upload both the sample workbook......will try to help...

Attachment 391967Attachment 391966

Hi
I have attached sample files of both the master and the table

Thank you