| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cells from one worksheet and paste to incrementing sheets? | Excel Discussion (Misc queries) | |||
| using macro to copy and paste filtered results, what if blank? | Excel Worksheet Functions | |||
| formulae to copy cells from 1 worksheet and paste into another? | New Users to Excel | |||
| Paste results consecutively within column (based off other worksheet) | Excel Worksheet Functions | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Hybrid Mode
