Info From Different Workbooks...


G

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
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top