View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DC DC is offline
external usenet poster
 
Posts: 42
Default How to I create picking another sheet data with 2 different cell

For example:

For sheet 2, Cell C 5, and C7 already got data as 1015 and $30 respectively

when I'm in sheet 1, at cell G 5, if I link "Sheet 2 C 5" to this cell, it
will replicate "1015" tho this cell.... but at the same time I would like to
have C 7 to be replicated t Sheet 1 at cell G7 as well..... can it be done or
another method can be use....

Appreciate anyone advise....