Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Can you edit your data set while it is autofiltered?

I recently had a large dataset in excel that I needed to add select
information to. I used autofilter to locate the rows I needed and then
entered the new information by cutting and pasting from another workbook. I
later found that the columns did not match up anymore - as if the columns had
been sorted separately. I did not sort any of the columns separately so the
only thing I thought it could have been was my use of autofiltering, but I
thought this was not supposed to alter your dataset? Help - I don't want
this to happen again!

Thanks!


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default Can you edit your data set while it is autofiltered?

When you paste into a filtered list, the data is pasted into a
contiguous block of cells, not just the visible cells.

For example, you have rows 10, 20 and 30 visible after a filter.
You copy cells A1:A3 on a different sheet
You return to your filtered list, select the cell in row 10, and paste
Those 3 copied cells would be pasted into rows 10, 11, and 12

Instead of pasting into the filtered rows, perhaps you could type an X
in a new column, to mark the rows that you want to change.
Then, sort the table by the column with the X
When the rows are all together, do the copy and paste, then remove the X
marks.

KLynn727 wrote:
I recently had a large dataset in excel that I needed to add select
information to. I used autofilter to locate the rows I needed and then
entered the new information by cutting and pasting from another workbook. I
later found that the columns did not match up anymore - as if the columns had
been sorted separately. I did not sort any of the columns separately so the
only thing I thought it could have been was my use of autofiltering, but I
thought this was not supposed to alter your dataset? Help - I don't want
this to happen again!

Thanks!




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #3   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Can you edit your data set while it is autofiltered?

If you paste a multiple row selection into an auto filtered selection, it
will paste as though the autofilter was not on, in other words the auto
filter may show rows 2,6 and 10
but if you paste a three row selection into row 2 it will paste into rows
2, 3 and 4.

"KLynn727" wrote:

I recently had a large dataset in excel that I needed to add select
information to. I used autofilter to locate the rows I needed and then
entered the new information by cutting and pasting from another workbook. I
later found that the columns did not match up anymore - as if the columns had
been sorted separately. I did not sort any of the columns separately so the
only thing I thought it could have been was my use of autofiltering, but I
thought this was not supposed to alter your dataset? Help - I don't want
this to happen again!

Thanks!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Macro How can i Change Autofiltered data one by one Vijay Kotian Excel Discussion (Misc queries) 1 September 5th 06 10:46 AM
Retrieve / Return LAST Row of Autofiltered data Sam via OfficeKB.com Excel Worksheet Functions 4 May 26th 06 03:47 PM
How can I update a graph with autofiltered data? Scotty Excel Worksheet Functions 1 May 4th 06 05:32 PM
adding IF statement to subtotal for autofiltered data fbarbie Excel Worksheet Functions 1 December 7th 05 07:54 PM
can I export just the autofiltered data into own sheet? kst82276 Excel Discussion (Misc queries) 1 May 13th 05 03:24 PM


All times are GMT +1. The time now is 06:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"