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