Log in  \/ 
x
or
x
x
Register  \/ 
x

or

unanswered Moving Rows to Another Sheet based upon multiple cell values

More
1 month 3 weeks ago #2172 by Snoop
Hi guys,
Very new to KUTOOLS for Excel but loving it.
Struggling with this problem though:
I wish to take the rows of a spreadsheet where a cell has one of several values (maybe up to 1000 different values) and then move the rows to another spreadsheet. Kutools has a cool feature called "select specific cells..." but you can only specify one cell value.
As a simple example in the attached sheet I want to pick up the

File Attachment:

File Name: example.zip
File Size:9 KB
values of 4 and 5 in column 'c'; and highlight the rows so I can move them to another sheet.
Any ideas?
Thanks in advance,
Russ
Attachments:

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun