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

  • Thread starter Thread starter faze
  • Start date Start date
F

faze

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and paste to other worksheets 2
Copy row to worksheet IF 1
Lookup and copy cells if match found 2
VBA - Copying a Certain Colored Row to Paste in Another Worksheet 1
loop to copy paste 3
Search , then copy and paste from multiple worksheets. VBA help 1
MS Excel VBA Copy and Paste from external workbook data to central worksheet 1
Create if partial match then copy and paste data from one cell to another 1

Back
Top