Copy Data in Filtered Rows Not Working Properly

[ahmad08]

Hi

Thanks to all, who help in this form to get people out from difficult type of situations faced in excel. I am a kind of beginner in excel.

In below sheet, I filter Column C (Mix Type) . For each value in Column C, there are different standard values which are mentioned in column H, J, M and P. I paste these standard values by using filters. But when I recheck after removing filter. All of the values in column H,J,M and P are wrong.

Below is link of file.

SFG RESULTS (CONDITIONAL FORMATING NOT WORKING).xlsx - Google Drive

 

[healey21]

Hi

Thanks to all, who help in this form to get people out from difficult type of situations faced in excel. I am a kind of beginner in excel.

In below sheet, I filter Column C (Mix Type) . For each value in Column C, there are different standard values which are mentioned in column H, J, M and P. I paste these standard values by using filters. But when I recheck after removing filter. All of the values in column H,J,M and P are wrong.

Below is link of file.

SFG RESULTS (CONDITIONAL FORMATING NOT WORKING).xlsx - Google Drive

Welcome to the forum, Once you filter, use the paste special feature and Select Visible cells only then copy and paste to where you need the data, this will resolve your issue.

 

[ahmad08]

Dear Healey21

Thanks a lot for your help.

It was my very first post here and I am glad to say that it really helped.

Regards,

 

[healey21]

Ahmad08 thank you for the reply and happy to help, pleased to read it worked.