| 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 |
| 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) | |||
Threaded Mode
