View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rajat Rajat is offline
external usenet poster
 
Posts: 39
Default linking (?) fields from one worksheet to another?

Hi Kateapotomous

i am not an expert but as per as my understanding you want to call data from
another Excell file or worksheet to an seperate sheet or file. Am i correct?

open your summery sheet, select the cell where data from Sales Orders sheet
will show press F2 and put '=' (without quote) and after that select the cell
from Sales Orders sheet and press "Enter". Data from that sheet will be shown
there.

when you chage in the Sales Orders sheet the summary sheet will be updated
automatically. Am i able to solve ur problem?