vba courses london - Vlookup, updating data

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Vlookup, updating data

Gunaratnam has attended:
Excel VBA course
Excel Advanced course

by - delegate Gunaratnam [2 posts] (2007 Jan 18 Thu, 15:56) Reply

Is is possible to build in a macro which has vlookup up included in it and be able to lookup data relating to privouse months.

This might be a excel or a VBA question.

Example for my management accounts i need to up date the budget and last year figure on a monthly basis. is it possible to do this using macro without me having to manualy chand the budget and last year data.

thanks

RE: Vlookup, updating data

by - trainer Carlos gold contributer [479 posts] (2007 Jan 26 Fri, 11:09) Reply

Yes

You would have to Create the VLOOKUP in a macro and then edit it to take into account which range of data it was looking at

You would need to set the data range before running the VLOOKUP

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Visual Basic Returns To The Macintosh
· How To Find A Good VB For Access Trainer
· Company Roles in Visual Basic Training
· Should You Send Managers To VBA Training?

Vba tip:

Display Text In a Msgbox On Multiple Lines

When displaying text in a MsgBox you may need to show it over multiple lines. To do this use:

vbCrLf

As in:

MsgBox "The System has detected an error." & vbCrLf & "Contact your System Administrator"

The first sentence in quotes will appear above the second in the MsgBox.

View all VBA hints and tips

Rate this page: