Hi there.
I'm creating an excel workbook and I want to create a macro which moves
to the correct worksheet. It retrieves this correct worksheet from a
VLookup formula, linked to a drop down box.
Example:
On the DataSheet the values a
1 | Worksheet name
2 | Other worksheet name
and on the page with the macro and form the formula is
=VLOOKUP(D2,DataSheet!B2:D5,2) (D2 is a drop down box from which the
worksheets are chosen)
Any ideas how I can get
VB to read the VLookup to get the worksheet
name?
Thanks.
--
xander1987
------------------------------------------------------------------------
xander1987's Profile:
http://www.excelforum.com/member.php...o&userid=27236
View this thread:
http://www.excelforum.com/showthread...hreadid=467453