LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 76
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto insert row while entering raw data mandapanda625 Excel Discussion (Misc queries) 1 July 7th 08 10:03 PM
Auto insert of blank row depending on data [email protected] Excel Discussion (Misc queries) 4 December 5th 07 04:31 PM
How can I have data auto insert into another pg in workbook? beaker0103 Excel Worksheet Functions 0 August 17th 06 04:53 PM
Auto insert data to seperate sheets? greig2000_uk New Users to Excel 2 May 27th 06 01:10 PM
Auto Insert Rows of Data?? tojo107 Excel Discussion (Misc queries) 2 May 28th 05 09:28 PM


All times are GMT +1. The time now is 10:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"