Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Formulas of Filtered Data
Hi Folks - I create daily recon sheets. Once I am done, I copy the daily
sheet to an accumulated sheet. In the daily sheets, I basically work with rows 1-20. However, I usually filter the daily sheet prior to copying to the accumulated sheet. What I notice is that when I copy the first daily sheet into the accumulated sheet, my formulas are copied properly. But, once I filter and copy the second daily figures below the first day's figures on the accumulated sheet, my formula results are converted to values. I have a workaround, but I'm trying to understand why Excel does this. Or, is there a better way to accomplish my task? Make sense? -- Michael |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Formulas of Filtered Data
Formulas copied from a non-continguous range in a filtered list paste as
values. I don't know why. Instead of filering, sort the filtered items out of your copy range. "Michael" wrote: Hi Folks - I create daily recon sheets. Once I am done, I copy the daily sheet to an accumulated sheet. In the daily sheets, I basically work with rows 1-20. However, I usually filter the daily sheet prior to copying to the accumulated sheet. What I notice is that when I copy the first daily sheet into the accumulated sheet, my formulas are copied properly. But, once I filter and copy the second daily figures below the first day's figures on the accumulated sheet, my formula results are converted to values. I have a workaround, but I'm trying to understand why Excel does this. Or, is there a better way to accomplish my task? Make sense? -- Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Formulas from Filtered Data | Excel Worksheet Functions | |||
Applying formulas to filtered data | Excel Discussion (Misc queries) | |||
Copy filtered data | Excel Discussion (Misc queries) | |||
How to copy just the filtered data? | Excel Discussion (Misc queries) | |||
Copy filtered data | Excel Discussion (Misc queries) |