Macro for Lookup

[macdca]

Can anyone tell me how to write a macro for a VLOOK up procedure, lining to a worksheet which looks up over 2 worksheets?

Thanks

 

[VoG]

OK, where did you put the code? It has to go in a regular module. Press ALT + F11 to open the Visual Basic Editor, select Module from the Insert menu then paste in the code.

 

[macdca]

Thets working now (very slowly however!), great thanks! I had hped however that i could have this in a macro rather than having to paste a formula, i have another macro in the sheet which will split the file into wider areas based on this new look up column. To import the data and press oe macro button for the look up and the splitting into sheets would be ideal, is there any way this can be done?