Wrox Programmer Forums
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 2nd, 2006, 09:56 AM
Registered User
Join Date: Aug 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default lookup using VB

I need some help writing some code. What I have is an excel worksheet that has a column with a bunch of Task IDs. What I want to do is to use the Task ID as a driver to look a value in a pivot table based on the Task ID. The thing is the pivot table changes on a monethly basis so I cannot use range references.

Old August 2nd, 2006, 04:32 PM
Friend of Wrox
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts

This sounds like a job for Access, not Excel...

Are there definable features that will enable you to determine when you have run out of data? (Like, always starts at B2, runs down B until the cel value is "", or something like that.)

Could you explain a little more what the "look [up] a value in a pivot table" means, in terms of manifestation? Move to that cell? Send the value to a file? Put all the values thus found into an array? ...?

Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup value in table Vince_421 Access 16 February 13th, 2007 08:15 AM
LookUp and Hyperlink frankjuel Excel VBA 1 January 12th, 2007 03:03 AM
lookup function Vince_421 Access VBA 14 May 19th, 2006 07:27 AM
Lookup Tables mossimo Access 4 December 5th, 2003 11:27 AM
File name lookup acdsky Classic ASP Basics 3 November 22nd, 2003 11:49 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.