Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Insert Data
I have two worksheet on the same workbook called sheet1 and sheet2.
I want data entered on sheet1 to automatically show on sheet2. Example. "Sheet1" C C1 EMP ID 101 102 103 104 Now on "Sheet2" C C1 EMP ID 009 008 007 Now when i change 101 on sheet1 then "009" should automatically change to 101 Please can anybody advice on what to do. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Insert Data
Hi,
Not sure if I understand what you want to do, if you want to populate information entered in sheet1 into sheet2 and supposing that the number you are changing in sheet1 is in cell C1, in sheet2 cell C1 enter =sheet1!C1 "Kanmi" wrote: I have two worksheet on the same workbook called sheet1 and sheet2. I want data entered on sheet1 to automatically show on sheet2. Example. "Sheet1" C C1 EMP ID 101 102 103 104 Now on "Sheet2" C C1 EMP ID 009 008 007 Now when i change 101 on sheet1 then "009" should automatically change to 101 Please can anybody advice on what to do. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto insert row while entering raw data | Excel Discussion (Misc queries) | |||
Auto insert of blank row depending on data | Excel Discussion (Misc queries) | |||
How can I have data auto insert into another pg in workbook? | Excel Worksheet Functions | |||
Auto insert data to seperate sheets? | New Users to Excel | |||
Auto Insert Rows of Data?? | Excel Discussion (Misc queries) |