In A62 put in the formula

=if(Left(trim(B62),7) = "STOCK#:",B62&B60,"")

Then drag fill down (and/or up) column A.

--
Regards,
Tom Ogilvy

"jeffbert" wrote in message
...
Here is what I am after. I have a large download from a major retailer's
website. Unfortunately, it is not available in a format that is very user
friendly to get information from. I am setting up a "database" worksheet
to
lookup all of the information off of the download, and put it into a
format
that can be used in a pivot table. What I need to do is evaluate column B,
everywhere that STOCK#: ??????, (the ? is a wildcard) then enter a formula
in
column A.

For instance:
Evaluate column B
Stock#: XXXXXX is found in cell B62
In cell A62 enter the formula =(B62&B60)

Then continue on for 2500 rows repeating the procedure wherever "STOCK#:
?????) appears.

I would like to thank everyone in advance for looking into this for me.

Side note. If anyone knows of any good "Teach yourself VB" books or
programs, please feel free to e-mail me.