Feb 25 2023 08:14 AM
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?
Many thanks,
KM