Prev: Value list
Next: if is error then "No Data", if not then average range
From: Dianeg on 4 Feb 2010 13:47
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
From: Eduardo on 4 Feb 2010 14:13
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
From: Dianeg on 4 Feb 2010 17:49
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
From: Fred Smith on 4 Feb 2010 22:40
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" <Dianeg(a)discussions.microsoft.com> wrote in message
news:75BD98BF-B5D9-4A38-A046-54126A18830B(a)microsoft.com...
> 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

From: Ashish Mathur on 5 Feb 2010 19:06
No you cannot

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Dianeg" <Dianeg(a)discussions.microsoft.com> wrote in message
news:DFA43F8E-D89E-4CBB-9B0C-D4F2EA44AF6A(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Value list
Next: if is error then "No Data", if not then average range