|
|
Data changes in advanced filter
I have just done an advanced filter and copied the results to another sheet,
the data has been copied over with just values, is there any way of copying
the data as is, ie with all the underlying formulae?
Thanks in advance
|
|
0
|
|
|
|
Reply
|
 Utf
|
2/3/2010 3:08:01 PM |
|
Try: Paste Special...>Formulas
Regards,
Fred
"David Sher" <DavidSher@discussions.microsoft.com> wrote in message
news:457F364B-EA58-47AF-8E2E-0914BD0E1296@microsoft.com...
>I have just done an advanced filter and copied the results to another
>sheet,
> the data has been copied over with just values, is there any way of
> copying
> the data as is, ie with all the underlying formulae?
>
> Thanks in advance
|
|
|
0
|
|
|
|
Reply
|
Fred
|
2/3/2010 3:25:41 PM
|
|
Have the Advanced Filter filter the data only, then select the filtered data,
copy, paste special - all.
Logically, one would think that doing a regular paste and paste special -
all, would do the same thing, but in this case, they do not.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"David Sher" wrote:
> I have just done an advanced filter and copied the results to another sheet,
> the data has been copied over with just values, is there any way of copying
> the data as is, ie with all the underlying formulae?
>
> Thanks in advance
|
|
|
0
|
|
|
|
Reply
|
Utf
|
2/3/2010 3:50:01 PM
|
|
|
2 Replies
465 Views
(page loaded in 0.001 seconds)
Similiar Articles: Data changes in advanced filter - microsoft.public.excel.worksheet ...I have just done an advanced filter and copied the results to another sheet, the data has been copied over with just values, is there any way of cop... Advanced filter VS formula in cell - microsoft.public.excel ...Data changes in advanced filter - microsoft.public.excel.worksheet ... Advanced filter VS formula in cell - microsoft.public.excel ... only change i make is make range Y17 ... Advanced Filtering top values - microsoft.public.excel.programming ...Data changes in advanced filter - microsoft.public.excel.worksheet ... I have just done an advanced filter and copied the ... data has been copied over with just values ... Locating Source Data in Master Spreadsheet - microsoft.public ...Data changes in advanced filter - microsoft.public.excel.worksheet ..... public.excelcheck to see if there's any data If .AutoFilter ... an Advanced Filter to send data ... changes to master copy of worksheet automatically updates a copy ...Data changes in advanced filter - microsoft.public.excel.worksheet ..... do Advanced Filter >Copy to another location ... autofilter master copy data to worksheet ... Adv. Filter - Want to copy to inactive sheet - microsoft.public ...Excel Advanced Filter Introduction An Excel Advanced Filter can extract data to a different sheet, filter ... columns that you want ... Data tab, click Advanced. Any way to apply a filter automatically after changing a cell ...Data changes in advanced filter - microsoft.public.excel.worksheet ... Any way to apply a filter automatically after changing a cell ... Any way to apply a filter ... Advanced filter macro? trouble - microsoft.public.excel ...Data changes in advanced filter - microsoft.public.excel.worksheet ... Advanced filter macro? trouble - microsoft.public.excel ... apply filter macro - microsoft.public ... ADVANCE FILTER SORT - microsoft.public.accessHow to Use Advanced Filter/Sort in Access 2007 | eHow.com The Advanced Filter/Sort function in Access 2007 allows you to sort data in a user-defined order rather than the ... AdvancedFilter syntax - microsoft.public.excel.programming ...... count unique values with auto-filter on - microsoft.public.excel ... Advanced Filtering top ... Advanced filter > Select your source range>Data>Advanced Filter>Unique ... Data changes in advanced filter - microsoft.public.excel.worksheet ...I have just done an advanced filter and copied the results to another sheet, the data has been copied over with just values, is there any way of cop... Advanced filter refresh after data changeI have an advanced filter in Excel 2002 (on Windows XP). I want to automatically ... Take a look at the Worksheet_Change event. ... Ok, after a few hours of messing ... Filter by using advanced criteria - Excel - Office.comTo move the Advanced Filter dialog box out of the way temporarily while you select the criteria range, click Collapse Dialog. To change how the data is filtered, change the ... How to Use an advanced filter to extract table data in Excel ...EnLIGHTening Home Hack! How to Change Hard-to-Reach Light Bulbs Without a ... learn how to extract every 30th record using a logical formula and the Advanced Filter data ... Excel Advanced Filter -- Complex CriteriaExcel Advanced Filter examples - filter for top records, matching data, records with blanks, and more 7/25/2012 8:32:34 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
39 followers. 