Vlookups and Macros

Hi

Thanks for getting in touch. With VLOOKUPs just use your function as usual, but reference other sheets. e.g.

=VLOOKUP(A1, Sheet2!A1:B55, 2)

Will return the second column of data from a separate sheet.

Using macros in other sheets is perfectly acceptable, just record the actions you require (View > Macros > Record Macro).

This can be quite an indepth topic so do feel free to reply with your particular scenario.
Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector