0
Undo
Votes
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 example.zip 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
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 example.zip 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
Another Select Specific Cells dialog box pops up to show you number of selected rows, and meanwhile, all rows contain the specified value in selected column have been selected. See screenshot: 3. Press the Ctrl + C keys to copy the selected rows, and then paste them into the destination worksheet you need.
- Page :
- 1
There are no replies made for this post yet.