Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel copying all cells instead of just the ones returned from a filter 2

Status
Not open for further replies.

cjbrown815

IS-IT--Management
Mar 2, 2006
525
US
Excel 2010,
I have a long list of tests, I'm doing a text filter (contains) on a portion of the test name, then I cut the rows that are returned and paste them in another worksheet. All of a sudden, excel is cutting all rows including the ones that are hidden. What changed? How can I get excel to only cut the rows that are returned by the filter again? thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931
 
Hi,

All of a sudden

Does this mean:
1) I was copying at my desk and I finished cutting the Nth set of rows, pasted them into my target sheet, went right back to my source sheet to filter and cut and then...

or

2) Yesterday it worked but today it doesn't work.

Out of curiosity, is your SOURCE table a Structured Table or a QueryTable? If so, there are TWO ways of selecting rows: the ENTIRE row and just the row in your TABLE. The latter method will NOT give you the results you want.

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
You know, when I've run into something like this, what I had to do was:
1. Filter the data
2. COPY the rows to the new location
3. Then either go back and delete the rows you're showing, then remove filter... or else change filter and copy out the opposite filtered rowset.. but hopefully the former of these 2 options works. I sadly forget which route I took at the moment.

When I've done this in the past, I noticed that if I did a cut/paste, I'd end up often with the entire rowset, not just the filtered rows. But if I used copy, at least lately, it's been giving me only the filtered rows.



"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
 
Thanks for the reply Skip,
All this morning,
I dumped the data from crystal reports into the excel workbook, then I started doing the text filter, cut, paste. My boss sat down and "showed me" a way of using the trim function to pull the first few letters from a column into another column, the deleted what he had done. When I went back to my routine, excel is now copying everything! So I don't know what changed so I can change it back!
I believe its a structured table, but not sure how to tell.

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931
 
If it's a ST or a QT when you Select in the table, a context sensitive Tab appears in the Ribbon.

You must Select the ENTIRE ROW, not just the rows in the table.

BTW, I avoid CUTTING data. IMNSHO its data mutilation.

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
As an FYI, the cut feature cuts everything, the copy feature only copies the rows that are returned by the filter. Who knew. thanks all for the help as always. Great little community here


-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top