G
Guest
I want to enter text in cell in sheet 1 and have it appear in a cell on sheet 2 also
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
CLR
Select both sheets, using Shift and left-click on the sheet
tabs.............then select a cell and type away........the values will
appear in the same cells on both sheets
Vaya con Dios,
Chuck, CABGx3
tabs.............then select a cell and type away........the values will
appear in the same cells on both sheets
Vaya con Dios,
Chuck, CABGx3
sheet 2 alsojack said:I want to enter text in cell in sheet 1 and have it appear in a cell on
E
Earl Kiosterud
Jack,
If it's the same cell (same address) in the two sheets, you can select both
sheets (use Ctrl as you click the other). Then whatever you enter into any
cell goes into the same cell in the other selected sheet. Don't forget to
deselect (right-click and ungroup) the other sheet before you put stuff into
a sheet that isn't supposed to go into both.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
If it's the same cell (same address) in the two sheets, you can select both
sheets (use Ctrl as you click the other). Then whatever you enter into any
cell goes into the same cell in the other selected sheet. Don't forget to
deselect (right-click and ungroup) the other sheet before you put stuff into
a sheet that isn't supposed to go into both.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
sheet 2 alsojack said:I want to enter text in cell in sheet 1 and have it appear in a cell on
R
Ragdyer
If the cells are not identical on both sheets, then you can simply link them
together.
Click in the cell in sheet2,
Enter an equal sign (=),
Now, navigate to the cell on sheet1 that has or will have the original data,
click in it and hit <Enter>,
And you're done !
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
together.
Click in the cell in sheet2,
Enter an equal sign (=),
Now, navigate to the cell on sheet1 that has or will have the original data,
click in it and hit <Enter>,
And you're done !
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
sheet 2 alsojack said:I want to enter text in cell in sheet 1 and have it appear in a cell on