linking cells in worksheets

[gazzapoh]

hi all.

got a problem,when i update changes in a column of cell in sheet 1, i need to reflect these changes in a particular row in sheet 2..

In sheet1, in cell F3 is the S/N title, from F4 onwards is the respective nos.
B3is the status title, From B4 onwards is where the user is able to type in either "r"."g" or "y". these are in columns..

In sheet2, in cell A8 is the S/N title and row 8 contains all the S/N no, the problem is there r gaps of column which contain no information. For eg, S/N no. appears in cells F8, J8,M8.N8.... stuff like that.. Then in cell A10 is the status title and in row 10 is the various values of either "r",
"y", or "g", i need these values to change according to the user input in sheet 1. These has to correspond to the S/N nos in sheet 1..

Guess some kind of looping is needed..
Any help is much appreciated...Thanks..

cj

 

[Fergus]

Hi,

On Sheet2 in Cell B10 paste in this formula =IF(ISBLANK(B8),"",INDEX(Sheet1!$B$4:$B$6,MATCH(B8,Sheet1!$F$4:$F$6,0)))
which you can then copy across row 10. Modify ranges B4:B6 and F4:F6 to suit.

HTH