Joel,

Thanks much. Now I have several approaches to work with.

***Regarding the problem you experienced yesterday. Was it Error on page?
That's what I had and I solved it by changing the browser settings:
Internet/Options/Advanced/Browsing - uncheck Use Smooth Scrolling.

Give that a try.





"Joel" wrote:

for some reason yesterday I had trouble responding to this posting. there
was something wrong at my companies server in processing Javva scripts.
today its fixed.


If you want tto try VBA code I found this code in the VBA help. i've used
it before and it works pretty well. if you need any help let me know. This
will do the searching and identify the rows you are look for.


This example finds all cells in the range A1:A500 on worksheet one that
contain the value 2 and changes it to 5.

With Worksheets(1).Range("a1:a500")
Set c = .Find(2, lookin:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address
Do
c.Value = 5
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address < firstAddress
End If
End With

"xrbbaker" wrote:

I'm trying to do some resource forcasting and in the end display what
resources are needed,by month. Through a simple VLOOKUP or by using some of
Debra Dalgleish's Contextures TIPS, I can get the very first part of it, but
that's about it. That is, walk down column A until it finds "Needed" and
then return the associated needed skill. Then I hit a wall.

Can I get where I want to go without VBA? If VBA is required, I can do some
basic VBA stuff by myself, but not this. Can anybody point me to a site that
has something like this, or give me a jump start?

thanks very much - Russ

PROJECT 1 Jan Feb Mar
Mike cobol 1 1 1
Tom java 1 .5 .25
Needed C++ .5 .5 .5


PROJECT 2
Sally cobol 1 1 1
Kim .net .75 .75 .75
Needed Oracle .5 .5 .5

PROJECT 3
Needed Oracle .75


Desired results table...

Jan Feb Mar
Needed C++ .5 .5 .5
Needed Oracle 1.25 .5 .5