Malcolm
Lets call the first one of the cells in "Hsk Assign" the destination
cell and the corresponding cell in the "End Bal" sheet the source cell. Go
to the destination cell. Type an equal sign. DO NOT HIT ENTER. Go to the
source cell and click on it. Hit ENTER now. That's it. Now in the
destination sheet, drag that formula down by the fill handle as far as
needed. HTH Otto
"Malcolm" wrote in message
...
I have a workbook and I would like to do the following: sheet 1 named €œEnd
Bal€� has 8 columns. In 2 of the columns; cells B5:B22 and H5:H21 contain
one
of the following; S, C/O, or BLOCK (text only). These designations are
random
and change from day-to-day. I would like to link these cells to another
worksheet named €œHsk Assign€�; with the cells C10:C27 and I10:I26. How is
this
done? I am using Excel 2007.

Regards,
Malcolm