Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter
in this photo we have three rows but there are blanks between them in this photo there are no blanks because i autofiltered the blanks between them. i want to autofilter the first photo and copy a b c while autofiltered but excel won't let me do that. the real spread sheet is 8000 rows long with huge gaps between the filled cells so i really can't do that unless i use the autofilter |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter
Select all your data + column headings before applying the autofilter. By
default Excel tries to figure out the data range to include for the autofilter. It stops when it encounters an empty row. By selecting all the data first you are telling Excel what range to include in the autofilter. To copy autofiltered data you must select only the visible cells. After selecting the block of filtered cells, press F5 Special Visible cells only OK. Then copy. Hope this helps, Hutch "kylefoley2000" wrote: in this photo we have three rows but there are blanks between them in this photo there are no blanks because i autofiltered the blanks between them. i want to autofilter the first photo and copy a b c while autofiltered but excel won't let me do that. the real spread sheet is 8000 rows long with huge gaps between the filled cells so i really can't do that unless i use the autofilter |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter
Hutch, i want to do the reverse of what you recommended. in sheet 2 i have data that was the autofiltered version of the data in sheet 1. i made some changes on the data because with the blanks removed it was easier. now i want to take that data and copy it back into sheet 1 but sheet 1 must be auto filter format for me to do that. let me draw some more pictures. in step one i have sheet 1 (in the real spreadsheet there are about 8000 rows with gaps of about 10 cells between them) step two, i filter out the blanks step three i paste the results on a new sheet and add columns aj and ak together, the result being in al step four is the step i cannot do, i'm trying to paste the results in column al back onto sheet one so that they are the sum of the two cells to their left "Tom Hutchins" wrote: Select all your data + column headings before applying the autofilter. By default Excel tries to figure out the data range to include for the autofilter. It stops when it encounters an empty row. By selecting all the data first you are telling Excel what range to include in the autofilter. To copy autofiltered data you must select only the visible cells. After selecting the block of filtered cells, press F5 Special Visible cells only OK. Then copy. Hope this helps, Hutch "kylefoley2000" wrote: in this photo we have three rows but there are blanks between them in this photo there are no blanks because i autofiltered the blanks between them. i want to autofilter the first photo and copy a b c while autofiltered but excel won't let me do that. the real spread sheet is 8000 rows long with huge gaps between the filled cells so i really can't do that unless i use the autofilter |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter
http://i87.photobucket.com/albums/k1...icture5-10.png
"kylefoley2000" wrote: Hutch, i want to do the reverse of what you recommended. in sheet 2 i have data that was the autofiltered version of the data in sheet 1. i made some changes on the data because with the blanks removed it was easier. now i want to take that data and copy it back into sheet 1 but sheet 1 must be auto filter format for me to do that. let me draw some more pictures. in step one i have sheet 1 (in the real spreadsheet there are about 8000 rows with gaps of about 10 cells between them) step two, i filter out the blanks step three i paste the results on a new sheet and add columns aj and ak together, the result being in al step four is the step i cannot do, i'm trying to paste the results in column al back onto sheet one so that they are the sum of the two cells to their left "Tom Hutchins" wrote: Select all your data + column headings before applying the autofilter. By default Excel tries to figure out the data range to include for the autofilter. It stops when it encounters an empty row. By selecting all the data first you are telling Excel what range to include in the autofilter. To copy autofiltered data you must select only the visible cells. After selecting the block of filtered cells, press F5 Special Visible cells only OK. Then copy. Hope this helps, Hutch "kylefoley2000" wrote: in this photo we have three rows but there are blanks between them in this photo there are no blanks because i autofiltered the blanks between them. i want to autofilter the first photo and copy a b c while autofiltered but excel won't let me do that. the real spread sheet is 8000 rows long with huge gaps between the filled cells so i really can't do that unless i use the autofilter |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter
here, i see that this forum won't let me post pictures, i have the pictures uploaded at mrexcel http://www.mrexcel.com/forum/showthr...40#post2284740 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |