View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shek5150 Shek5150 is offline
external usenet poster
 
Posts: 14
Default One cell to many cells (two different work book/sheets)

Greetings...

I would like to know if there is a way to link a single cell from one work
sheet to several cells from another worksheet (from a different workbook).
Kind of like a one-to-many relationship; however, on the many side, only one
of the several cells in this second workbook would have data at a time and
it would be this data that would migrate to my main workbook on the "One"
side of the relationship.

Hope that mades sense...

v/r,

Steve