LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 125
Default Data of Sheet1 should gets autometically posted in Sheet2

Hi,

I have two sheets:

Sheet1
Sheet2

In Sheet1 i have 12 coulmns. Out of which few are as mentioned below:

1. Drg No
2. Project Name
3. FH
4. FL
5. RD
6. FPI
7. QTY

In Sheet2 i have the 10 clolums. The 7 Columns mentioned in Sheet1 are
similar to the Shee2

Now I want that as soon as i enter the data in Sheet1 it should
autometically gets posted in Sheet2.

How to do it. I want a macro becoz the formula gets deleted by the
users by mistake then i had to sit to rectify the entire format.

pls help me in this regards

Thanks in Advance.

Regards

Akash

 
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
how to sheet1 data goes to sheet2 automaticaly ? ABDUSSALAM Excel Worksheet Functions 2 March 10th 10 04:12 PM
copy data from sheet2 to sheet1 when sheet2 has variable # of rows Anne Excel Discussion (Misc queries) 6 February 27th 09 09:48 PM
How To Retrieve Data from Sheet2 into Sheet1 compconnj Excel Worksheet Functions 3 March 21st 06 07:56 PM
Transfering data from sheet1 to sheet2 redhat Excel Programming 1 December 3rd 05 04:00 PM
Transfer data from sheet1 to sheet2 Tommy Excel Programming 6 May 11th 05 06:39 PM


All times are GMT +1. The time now is 02:46 PM.

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"