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.

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? ...?