| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter and copy
I am filtering my data using column b and then copying everything in that row
5 times. E.g., if the filter in column B contains 05/01/07 the I would highlight and copy the whole row where column b=05/01/07 and paste it 5 times. is there an easy way to do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
filter and copy
Im not sure exactly what your trying to do but it sounds like you might be
able to use advanced filter and filter the result to another location. Mike "JOM" wrote: I am filtering my data using column b and then copying everything in that row 5 times. E.g., if the filter in column B contains 05/01/07 the I would highlight and copy the whole row where column b=05/01/07 and paste it 5 times. is there an easy way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
| Copy Filter Results only | Excel Discussion (Misc queries) | |||
| Need macro to filter, create tab on filter and copy/paste | Excel Programming | |||
| Need macro to filter, create tab on filter and copy/paste | Excel Programming | |||
| Filter and copy | Excel Programming | |||
Linear Mode
