View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
alice
 
Posts: n/a
Default Info From Different Workbooks...

Hi

I have two files, 'jan sales' and 'monthly sales'. I need cell A3 of sheets
1, 2 and 3 from 'jan sales' to mirror in cells A3, B3 and C3 of sheet 1 of
'monthly sales'.

What is the formula for this? Also I change the information in 'jan sales',
will it update in 'monthly sales'?

Hope this all makes sense.

Alie