cut and paste to different worksheet

hi
Max
Thnx for your suggestion. I tried your solution. I think you gave me correct
solution but I didn't tell you that in my worksheet 1, I have VB script and
conditional formatting which evaluates if I put some variables in cells.

First of all, information in columns from A to E gets filled automatically,
If I run query developed in MS ACCESS. I have recorded macro for that and
allocated a button to it.
Say I have data from A4 to E4
A104 to E104 (filled in automatically after
running macro)

In column B heading is "Customer Name" and (B4 to B104) change colour
depending on the customer name.
In column D heading is "Due Date" which has 3 condition in it based on "if
function" and changes colour if evaluates true.
column F is what I am trying to utilize as Key column for my trick.
column G has VB script and cnditional formatting related to it. Column H
gets filled up automatically depending on the result of the column G.
column I and J have again VB script and conditional formatting related to
them. column K gets filled automatically depending on result of column I &
J.
column L & M have VB script and conditional formatting related to them.
column N gets filled automatically depending on result of column L & M.
column Q conditons is based on the result of column G & column(I or J) &
column (L OR M).
So your solution is not working as it should have. What I was thinking to
write VB script something like that

If( Target . Column = 6) then (here A=1, B=2, C=3, ...., F=6, ....., Z=26)
if Target. Value = "C" then
Select entire Row( I don't know how to select that entire row using VB
commands)
select cut ( I think like Selection.Cut)
make sheet 3 active ( don't know)
select next available blank row(don't know)
select paste (selection.paste)
save sheet3 (don't Know)
make sheet 1 active ( don't know)
save sheet 1 as well (don't know)

If you can help me I will be very thankful.
Thanking you in anticipation!!!

You're welcome. But I'm not able to help you with the vba Qs. Do hang around
awhile for possible insights from others to these. Or, consider putting in a
fresh post in .programming.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----