how to copy a whole line according to one cell in the line to a di

[kbee]

into a different work sheet? I am trying to figure this out for a long time
and will really need help on this one. what would be the syntax?
much oblige
bee

 

[Rick Rothstein \(MVP - VB\)]

You should not use the subject line to ask any part of your question. Why?
Because in some cases, the subject line gets truncated, like yours did. All
I see for your subject is "how to copy a whole line according to one cell in
the line to a di"... I don't know what word "di" is the start of nor do I
have any idea what words after it got cut off; hence, the remainder of your
question down in the body of the message makes no sense. In the future, you
should put a **short** description into the subject line to give us an idea
what your question deals with and then ask the question in the body of the
message.

Rick

 

[kbee]

Sorry Rick, here it is again:
how to copy a row on all of its cells according to one cell in the row
into a different work sheet? I am trying to figure this out for a long time ,
do i use sort by in the function +additional , I don't know how to??
and I really need help on this one. what would be the syntax?
much oblige