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

Copper Contributor

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 resultPicture 1: The destination cells with the desired result

 

Picture 2: Cannot apply paste with visible cellsPicture 2: Cannot apply paste with visible cells

 

Many thanks,

KM

 

 

0 Replies