| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
copy rows meeting criteria to another worksheet
Hi,
I want to copy rows from 1 worksheet to another but only if they value in column A= 'Yes' So for example In worksheet1 I have 10 rows. 6 of those have 'Yes' in column A and 4 have 'No' in column A. In worksheet2 I would like to see only those 6 rows from worksheet1 which had 'Yes' in column A. I would like to do this using worksheet functions if possible, not macros. also filtering is not good enough, I want to actually eliminate all those rows that are 'No' thanks for any help Cheers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automate worksheet copy | Excel Discussion (Misc queries) | |||
| reminder notifications in a column | Excel Discussion (Misc queries) | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| copy link from next worksheet | Excel Worksheet Functions | |||
| How do I copy a cell (content AND format) from one worksheet to a. | Excel Worksheet Functions | |||
Threaded Mode
