| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to I create picking another sheet data with 2 different cell
For example:
For sheet 2, Cell C 5, and C7 already got data as 1015 and $30 respectively when I'm in sheet 1, at cell G 5, if I link "Sheet 2 C 5" to this cell, it will replicate "1015" tho this cell.... but at the same time I would like to have C 7 to be replicated t Sheet 1 at cell G7 as well..... can it be done or another method can be use.... Appreciate anyone advise.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to I create picking another sheet data with 2 different cell
Copy G5, paste in G7.
The formula =Sheet2!C5 will paste as =Sheet2!C7 -- David Biddulph "DC" wrote in message ... For example: For sheet 2, Cell C 5, and C7 already got data as 1015 and $30 respectively when I'm in sheet 1, at cell G 5, if I link "Sheet 2 C 5" to this cell, it will replicate "1015" tho this cell.... but at the same time I would like to have C 7 to be replicated t Sheet 1 at cell G7 as well..... can it be done or another method can be use.... Appreciate anyone advise.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| picking out a specific cell in a row | Excel Discussion (Misc queries) | |||
| Picking the list from data | Excel Worksheet Functions | |||
| create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
| Picking figures out of a cell | Excel Discussion (Misc queries) | |||
| Picking data | Excel Worksheet Functions | |||
Linear Mode
