I am stuck trying to do the following. Can someone please help. I am
novice and have Excel 2003.

I am in Sheet10.

I want the code to look at cell C2 in Sheet10.
If cell C2 in Sheet10 is blank, then go to C3 in Sheet10. (offset 1,0)

The range can go down to cell C23


If a cell in the range has a value then I want it to open a sheet ( th
name of the sheet is in the corresponding Column A of Sheet10.)

For example

The code looks starts in Sheet10 (Column C, Row2) finds that it i
empty and goes to the next row in that column. Finally in Row 10 i
finds a value. So then I want it to go to the corresponding ro
(Column A) or activecell.offset(0,-2) and open that sheet. So in thi
example, say Column A, Row 10 value is (Fiesta). So I want the code t
open Sheet45(Fiesta) and put the value in column c row 10 in Fiest
sheet "A1"), then print Fiesta Sheet. And finally loop thru rows 3:2
in Sheet10.

Sorry, this probably wasn't explained very well.

I would appreciate any help.

thanks Jos

--
jhahe
-----------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...fo&userid=2359
View this thread: http://www.excelforum.com/showthread.php?threadid=47187