Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.
I am very sorry about your Excel issues. Can you send me a sample or dummy Excel file that you are working on so that I can directly check the structure of your data and provide you a solution? You can attach it here using the paper clip icon, or you can upload it to http://filesXpress.com and then give me the short download link.
Please let me know so that I can help you further.
Thank you for writing back with that sample file. Please give me a moment to check it.
Thank you for patiently waiting. This problem is caused by the fact that the "filtered" cells in column A are actually merged cells. You can copy merged cell but NOT when they are filtered.
In this case, you need to split those cells if you want to avoid this error.
I suggest that you split these cells and you can just use fill color to group them.
Do you want me to do my suggested method in the sample file you sent me?
Splitting the cells is actually un-merging the merged cells in column A. These merged cells are causing this problem because you cannot copy merged cells when you filter them -- unfortunately that is how Excel behaves so you need to split the merged cells in order to use filters and copy the hidden cells.
Please give me a moment to do the suggested steps in the sample file you gave me.