If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
autofilter
in this photo we have three rows but there are blanks between them http://i87.photobucket.com/albums/k1...icture3-13.png in this photo there are no blanks because i autofiltered the blanks between them. http://i87.photobucket.com/albums/k1...Picture4-8.png 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
|
|||
|
|||
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 http://i87.photobucket.com/albums/k1...icture3-13.png in this photo there are no blanks because i autofiltered the blanks between them. http://i87.photobucket.com/albums/k1...Picture4-8.png 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
|
|||
|
|||
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) http://i87.photobucket.com/albums/k1...icture5-10.png step two, i filter out the blanks http://i87.photobucket.com/albums/k1...Picture6-9.png step three i paste the results on a new sheet and add columns aj and ak together, the result being in al http://i87.photobucket.com/albums/k1...Picture7-6.png 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 http://i87.photobucket.com/albums/k1...Picture8-6.png "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 http://i87.photobucket.com/albums/k1...icture3-13.png in this photo there are no blanks because i autofiltered the blanks between them. http://i87.photobucket.com/albums/k1...Picture4-8.png 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
|
|||
|
|||
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) http://i87.photobucket.com/albums/k1...icture5-10.png step two, i filter out the blanks http://i87.photobucket.com/albums/k1...Picture6-9.png step three i paste the results on a new sheet and add columns aj and ak together, the result being in al http://i87.photobucket.com/albums/k1...Picture7-6.png 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 http://i87.photobucket.com/albums/k1...Picture8-6.png "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 http://i87.photobucket.com/albums/k1...icture3-13.png in this photo there are no blanks because i autofiltered the blanks between them. http://i87.photobucket.com/albums/k1...Picture4-8.png 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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|