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