| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculations in filtered columns
Is there any way to perform an advanced filter on columns with calculations
in them and copy the data with calculations to another location.? It copies the extracted data as values only. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculations in filtered columns
With the filtered data selected press CTL+G, special, visible cells only,
CTRL + C, go to where you want to copy the information, paste special, values "Dianeg" wrote: Is there any way to perform an advanced filter on columns with calculations in them and copy the data with calculations to another location.? It copies the extracted data as values only. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculations in filtered columns
Thanks for the response but I don't think I explained myself properly. I
want the calculations to copy over not the values. Any ideas? "Eduardo" wrote: With the filtered data selected press CTL+G, special, visible cells only, CTRL + C, go to where you want to copy the information, paste special, values "Dianeg" wrote: Is there any way to perform an advanced filter on columns with calculations in them and copy the data with calculations to another location.? It copies the extracted data as values only. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculations in filtered columns
If you mean you want the formulas copied, then use Paste
Special...Formulas. If not, then tell us what you mean by 'calculations' Regards, Fred "Dianeg" wrote in message ... Thanks for the response but I don't think I explained myself properly. I want the calculations to copy over not the values. Any ideas? "Eduardo" wrote: With the filtered data selected press CTL+G, special, visible cells only, CTRL + C, go to where you want to copy the information, paste special, values "Dianeg" wrote: Is there any way to perform an advanced filter on columns with calculations in them and copy the data with calculations to another location.? It copies the extracted data as values only. Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculations in filtered columns
No you cannot
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Dianeg" wrote in message ... Is there any way to perform an advanced filter on columns with calculations in them and copy the data with calculations to another location.? It copies the extracted data as values only. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtered columns slower than others | Excel Discussion (Misc queries) | |||
| using auto filter, how to tell what columns are filtered? | Excel Discussion (Misc queries) | |||
| Filtered Columns! | Excel Discussion (Misc queries) | |||
| How do i perform calculations on filtered data | Excel Discussion (Misc queries) | |||
| How to hide columns that are not filtered? | Excel Worksheet Functions | |||
Linear Mode
