Hi Reegan

it's always a good idea that if you don't understand the advice you receive
to reply in the same thread and ask for additional help .. .because people
reading the question, if they haven't seen the other replies, are more than
likely to keep telling you the same thing.

I went looking for your other posts to see what advice you did receive and i
can't find them - which means that you've either changed the name you've
posted under, or posted in a different group (or they somehow have just
disappeared) - either way, this will increase the likelihood of me saying
the same as everyone else has said ... so i'm not going to directly answer
your question .... i'm going to explain why you can't get a "simple answer"

.... basically you can not do what you want to do automatically without using
code - so yes it is possible but it is not easy. If you are willing to use
a code solution, you will need to REPLY POST with details of your sheet
names and how you want to identify the rows to copy & paste ... do you want
to enter a keyword at a time and have that information copied, or do you
have a list of keywords and destination sheets already (if you do, let us
know what they are in the reply post).

some partial options for you, if you do not want to go down the vba route,
is to use filtering & then copy & paste the data to where you want it
....Debra Dalgleish has some notes on filtering on her website at
www.contextures.com/tiptech.html
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"reegan96" wrote in message
...
I have left a few posts with respect to this, but have been unable to
receive
any help that I understand....I'm a REAL newbie.

I am trying to set up a worksheet that will automatically transfer
a row of data (formatted for text, date and numberical data) to another
worksheets within the same workbook based on a keyword contained within
that
row. There will be more than 1 row with the same keyword, and I would
like
EACH row containing the keyword to copy into a separate row in the 2nd
worksheet. Is this possible? And does it make sense????

ANY help would be GREATLY appreciated!!!

Thanks SOOOOO MUCH!