Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get excel to copy one cell to another page automaticaly
Can any one help I have two pages in my exell document and some of the data
on each page is the same as the other. I would ike excel to enter this data to the cecound page automatically. ie. if i type 125743 on page one in g13 it enters also 125743 on page two f12 Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get excel to copy one cell to another page automaticaly
Hi Tiddler,
Assume the sheets are Sheet1 and Sheet2, in cell F12 on Sheet2, enter the formula: =Sheet1!G13 --- Regards, Norman "Tiddler" wrote in message ... Can any one help I have two pages in my exell document and some of the data on each page is the same as the other. I would ike excel to enter this data to the cecound page automatically. ie. if i type 125743 on page one in g13 it enters also 125743 on page two f12 Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions | |||
cell on one page equals cell on another page in excel? | Excel Worksheet Functions | |||
When I copy a cell in Excel it will print how do i stop this | Excel Discussion (Misc queries) | |||
Can I copy a combo box in Excel 2002 with a relative cell link? | Excel Discussion (Misc queries) | |||
Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) |