copy and paste cells to a different worksheet according to IF results
 

Hello!

I have several worksheets that have tons of information regarding
soldiers. I have several columns on those worksheets that have an "X"
in them if that particular soldier is assigned to a certain detail. I
am wondering if there is a way to search those column for an X, if X is
found then to take a certain cells from that row (i.g. Name, Rank, SSN)
and copy them onto a different worksheet. I have attached a file to
show what I'm talking about. Any help and information on the subject
would be greatly appreciated! Thank you in advance.

Dimitri Todika
SGT, USA


+-------------------------------------------------------------------+
|Filename: example for forum.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4286 |
+-------------------------------------------------------------------+

--
faze
------------------------------------------------------------------------
faze's Profile: http://www.excelforum.com/member.php...o&userid=31040
View this thread: http://www.excelforum.com/showthread...hreadid=507124

copy and paste cells to a different worksheet according to IF results
 

Have you tried autofilter?

Switch autofilter on for the table. Filter on the relevant column and then
cut and paste special, values into another sheet.

Hope this helps

Chris


"faze" wrote in message
...

Hello!

I have several worksheets that have tons of information regarding
soldiers. I have several columns on those worksheets that have an "X"
in them if that particular soldier is assigned to a certain detail. I
am wondering if there is a way to search those column for an X, if X is
found then to take a certain cells from that row (i.g. Name, Rank, SSN)
and copy them onto a different worksheet. I have attached a file to
show what I'm talking about. Any help and information on the subject
would be greatly appreciated! Thank you in advance.

Dimitri Todika
SGT, USA


+-------------------------------------------------------------------+
|Filename: example for forum.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4286 |
+-------------------------------------------------------------------+

--
faze
------------------------------------------------------------------------
faze's Profile:
http://www.excelforum.com/member.php...o&userid=31040
View this thread: http://www.excelforum.com/showthread...hreadid=507124