I am trying to create a macro which could copy information from a datasheet and past it into sheets which are named as one of the Cells in column A.
I have a datasheet which contains five columns full of data. Column A contains the Client references. There are 200 sheets and each client reference has a seperate sheet which has datafields.
I need a mcro which could lookup client reference in datasheet column A and find the sheet named with the client reference then copy information from datasheet row B:E and paste it in column A:E of reference sheet.
thank you for your help,