Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Vlookup, updating data

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

vba courses london - Vlookup, updating data

Resolved · Low Priority · Version Standard

Reply Thu 18 Jan 2007, 15:56Delegate Gunaratnam said...

Gunaratnam has attended:
Excel VBA Intro Intermediate course
Excel Advanced course

Vlookup, updating data

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

For upcoming training course dates see: Pricing & availability

Reply Fri 26 Jan 2007, 11:09Trainer Carlos said...

RE: Vlookup, updating data

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

VBA articles

· VBA - What Is It, And Should You Learn It?
· VBA For Beginners - Only A Script Away From Endless Possibilities...
· How To Find A Good VB For Access Trainer
· Share Your Improved Microsoft Products Via VBA
· VBA: It's Easy To Record Macros In Excel 2007

Vba tip:

Use GoTo to Select A Cell With VBA

To select a certain cell on a Worksheet you can use:

Application.Goto Reference:=Range("V300")

or more simply

Range("V300").Select

If, on the other hand, you want the selected cell to be the top/left cell on the screen you use:

Application.Goto Reference:=Range("V300"), Scroll=True

View all VBA hints and tips