Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Info From Different Workbooks...
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 "alice" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need assistance linking workbooks by date | Excel Worksheet Functions | |||
i need info from the top workbook to be read in multiple workbooks | Excel Worksheet Functions | |||
Reflecting info between an excel file and a word one or two excel file. | Excel Worksheet Functions | |||
How do I get MS Query to pull info from 3 different workbooks? | Excel Discussion (Misc queries) | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) |