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

If you have done it with formulas why dont you just lock the cells with the
formulas in. Change the properties of those cells to locked, unlock the rest
of the sheet and protect the sheet using tools>protection>worksheet
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Akash" wrote:

> 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
>
>

HI jOHN,

IF I LOCK THE CELL THEN NO ONE CAN USE FILTER OPTION.

THATS Y I DONT WANT TO LOCK IT. THUS THE NEED OF THE MACRO IS
REQUIRED.

THANKS

AKASH

On Feb 23, 6:20 pm, john <j...@discussions.microsoft.com> wrote:
> If you have done it with formulas why dont you just lock the cells with the
> formulas in. Change the properties of those cells to locked, unlock the rest
> of the sheet and protect the sheet using tools>protection>worksheet
> --
> John
> MOS Master Instructor Office 2000, 2002 & 2003
> Please reply & rate any replies you get
>
> Ice Hockey rules (especially the Wightlink Raiders)
>
> "Akash" wrote:
> > 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