| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy is criteria met
I am having trouble finding a function that will copy the data in a given row
to another worksheet if one of the columns contains the word Yes. For example if in the below situation cell G5 has a Y, I want to Create Cover Sheet in Sheet 2 with return the data from row 5. Sheet 1 Box/Packet No Item No Account Name Account Number Content Vault sheet Create Cover Sheet 100 1 Mr A 123 AF 1 N 101 2 Mr B 456 AF 2 N 203 3 Mr C 789 AF 3 N 100 4 Mr D 111 AF 4 Y Sheet2 Box/Packet No 100 Item No 4 Account Name Mr D Account Number 111 Content AF Vault sheet 4 Can someone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - Copy row base on criteria | Excel Discussion (Misc queries) | |||
| Macro copy with criteria | Excel Discussion (Misc queries) | |||
| macro criteria copy | Excel Discussion (Misc queries) | |||
| copy data with criteria | Excel Discussion (Misc queries) | |||
| under certain criteria copy data. | Excel Worksheet Functions | |||
Threaded Mode
