Copy/Paste while filtered

[Nare91]

Good day,

Please help with the following question: I have a huge DB, some sells are green. I filtered the cells to only show green cells. Now what I want to do is to copy those cells and paste as value (since there is a function in the cells and I want it to be fixed as constant number, not a function). When I try to do that it says we can't paste because the copy area and the paste area aren't the same size. Please help me with this

Thank you
Nare

[Sam Capricci]

just put your cursor on one cell then use the paste special values, it should work then.

[Nare91]

Thank you for your response, but it still didn't work Do you want me to send you a sample of my DB? It will help u see better.

[Sam Capricci]

don't send it to me, if you want it looked at post a sample or if the sheet isn't too big and doesn't contain any confidential information you can post it here for anyone to diagnose the problem.
It works for me, I have a sheet that has different rows color coded, I filter on only those color coded cells, go elsewhere and click on only one cell then either paste or paste special and it populates that and the next group of cells with the data. So I'm not sure why it isn't working for you.
Use the "go advanced" button below to upload a sample sheet.

[Nare91]

I attached a File. What I want to do is filter green cells, copy and paste as special value so it would be 2 and 8

[Sam Capricci]

I had no problem doing what I suggested you do, see your attached sheet back...
I filtered on the color then copied the cells and pasted them elsewhere.