Info From Different Workbooks...

[Guest]

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

 

[Guest]

Make sure both Workbooks are open.

Then click '=' in the sheet you want the values to copy into then. Then
Select Window and choose the sheet from which you want the values to mirror.
Then click on the cell you want to see and hit {ENTER}.

The formula should look something like this....

='[Jan Sales.xls]Sheet1'!$A$3
='[Jan Sales.xls]Sheet2'!$A$3
='[Jan Sales.xls]Sheet3'!$A$3

As to updating...

Updates with this type of formula should be instant.

HTH