Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste after filtering
Hi. i'm trying to find a solution for this problem. after filtering on a certain column, I'm trying to copy and paste the subset of values from column a into column b. when I unfilter I see that all the values from a are in b, not just for the filtered records. Some of my co-workers have seen this, some have not. Can you help? Thanks. -- wab_77 ------------------------------------------------------------------------ wab_77's Profile: http://www.excelforum.com/member.php...o&userid=33875 View this thread: http://www.excelforum.com/showthread...hreadid=561443 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste after filtering
The advanced filter lets you carry out the filter and copy to another area of
the spreadsheet at the same time. It is a little more complicated as you have to set the criteria up separately. HIf you need help with this post back HTH - SHeila www.c-i-m-s.com MS Office training - London "wab_77" wrote: Hi. i'm trying to find a solution for this problem. after filtering on a certain column, I'm trying to copy and paste the subset of values from column a into column b. when I unfilter I see that all the values from a are in b, not just for the filtered records. Some of my co-workers have seen this, some have not. Can you help? Thanks. -- wab_77 ------------------------------------------------------------------------ wab_77's Profile: http://www.excelforum.com/member.php...o&userid=33875 View this thread: http://www.excelforum.com/showthread...hreadid=561443 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste after filtering
If you're really copying from column A to column B of a filtered range (and your
range to copy or paste is discontiguous), maybe you can do this instead. Do your filter select the range in column b that should get the new values (include any hidden rows). Then edit|Goto|Special visible cells only type an equal sign and point at that cell in column A of the same row hit ctrl-enter This will fill the visible cells with a formula that retrieves the values from column A. ======= Another option. Sort your data before you filter. Group all the the rows together that need to be visible when you filter. Since the range is contiguous, it should work ok. wab_77 wrote: Hi. i'm trying to find a solution for this problem. after filtering on a certain column, I'm trying to copy and paste the subset of values from column a into column b. when I unfilter I see that all the values from a are in b, not just for the filtered records. Some of my co-workers have seen this, some have not. Can you help? Thanks. -- wab_77 ------------------------------------------------------------------------ wab_77's Profile: http://www.excelforum.com/member.php...o&userid=33875 View this thread: http://www.excelforum.com/showthread...hreadid=561443 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
copy & paste formula between spreadsheets - not working | Excel Worksheet Functions | |||
Copy / Paste Warning | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) |