View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
malcolm malcolm is offline
external usenet poster
 
Posts: 57
Default Linking Columns between worksheets

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