How to copy and paste a selected group of visible cells with relative reference formula?

Hello,

I want to copy a selected group of visible cells when "Group" or "Filter" function applied with relative reference subtotal in each cell to adjacent column with the same desired group of cell to be pasted. The destination cells will have the same formula with relative reference.

For below example, I tried to paste visible cells with formula in Column B to C, there was a error.

Can anyone know how to do it?

Picture 1: The destination cells with the desired result