how to hardcode a filtered list?

[bigdan]

I have a list that's filtered. There are formulas in there. For example in col A a lot of the cells are of the type A1 = E1.
I want all these values to become hardcoded, but only among the filtered list. Since its filtered I cant simply select them all (which I believe would simply select the visible cells) and copy Alt-E-S-V. I believe that would paste into the hidden cells as well. So what's the alternative?

Thanks!

 

[SpillerBD]

Hidden cells are copied. Filtered Out Cells are not copied.

 

[bigdan]

OK great. Is there a solution to my problem or is that not possible?

 

[SpillerBD]

If you need all the values, turn off the filters, then copy/paste as Values.
If the filtering is complex, you can perform the operation and then close the file without saving the file or you can send the sheet to a new Workbook as a copy, then copy and paste values for the unfiltered sheet.

 

[bigdan]

If the filtering is complex, you can perform the operation and then close the file without saving the file

What would this accomplish?

I assume by operation you mean pasting the values?