Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data changes in advanced filter
Try: Paste Special...Formulas
Regards, Fred "David Sher" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data changes in advanced filter
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced filter data match | Excel Discussion (Misc queries) | |||
missing data w/ advanced filter | Excel Worksheet Functions | |||
Advanced Filter/Extracting Data | Excel Discussion (Misc queries) | |||
why can't i use the advanced filter on my data | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |