Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Macro How can i Change Autofiltered data one by one | Excel Discussion (Misc queries) | |||
Retrieve / Return LAST Row of Autofiltered data | Excel Worksheet Functions | |||
How can I update a graph with autofiltered data? | Excel Worksheet Functions | |||
adding IF statement to subtotal for autofiltered data | Excel Worksheet Functions | |||
can I export just the autofiltered data into own sheet? | Excel Discussion (Misc queries) |