Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a cell in workbook A. I want the information to transfer to a
cell and update to workbook B, when the values in A change. How can I accomplish this? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Enter an equal (=) sign in the cell in workbook B,
Then navigate to workbook A, and click in the cell that contains the data, Then hit <Enter. Now, click in the workbook B cell, and look at the formula in the formula bar. Using this syntax, you can duplicate the formula anywhere you wish. Of course, you could continue doing it the same way you did the first one!<g -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- wrote in message ups.com... I have a cell in workbook A. I want the information to transfer to a cell and update to workbook B, when the values in A change. How can I accomplish this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
Merge Cells | Excel Discussion (Misc queries) | |||
Use the Merge & Center Button with unprotected Cells - sheet prote | Setting up and Configuration of Excel | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |