Moveing Data to another Worksheet

I hope I put this in the correct place.
Let's say I have a workbook that contains 2 Worksheets named "Worksheet 1"
and "Worksheet 2"

In "Worksheet 1" I have the following information. In cell A1 = 1, B1 = 2,
C1 = 3 now based on this information anytime that cell B1 = 2 I want to copy
that entire row to "Worksheet 2"

First off is this possbile, second if it is how?

Thanks,
Alan

On Thu, 8 Sep 2005 07:21:03 -0700, "Alan"
wrote:

I hope I put this in the correct place.
Let's say I have a workbook that contains 2 Worksheets named "Worksheet 1"
and "Worksheet 2"

In "Worksheet 1" I have the following information. In cell A1 = 1, B1 = 2,
C1 = 3 now based on this information anytime that cell B1 = 2 I want to copy
that entire row to "Worksheet 2"

First off is this possbile, second if it is how?

Thanks,
Alan


There is no worksheet function which will achieve this, you can only
do it with a VBA macro

When you say anytime cell B1 = 2, is this a cell which is changed from
time to time?

If so you could use the worksheet change event of VBA with cell B1 as
the target range. In the Change Event code you would write something
like:

Worksheets("Worksheet 1").range("B1").entirerow.copy destination:=
Worksheets("Worksheet 2).range("your required range")

Untestested but that's the general principle.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Thank you Very much!!!! That did help!

"Richard Buttrey" wrote:

On Thu, 8 Sep 2005 07:21:03 -0700, "Alan"
wrote:

I hope I put this in the correct place.
Let's say I have a workbook that contains 2 Worksheets named "Worksheet 1"
and "Worksheet 2"

In "Worksheet 1" I have the following information. In cell A1 = 1, B1 = 2,
C1 = 3 now based on this information anytime that cell B1 = 2 I want to copy
that entire row to "Worksheet 2"

First off is this possbile, second if it is how?

Thanks,
Alan


There is no worksheet function which will achieve this, you can only
do it with a VBA macro

When you say anytime cell B1 = 2, is this a cell which is changed from
time to time?

If so you could use the worksheet change event of VBA with cell B1 as
the target range. In the Change Event code you would write something
like:

Worksheets("Worksheet 1").range("B1").entirerow.copy destination:=
Worksheets("Worksheet 2).range("your required range")

Untestested but that's the general principle.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________