G
Guest
I've created a spreadsheet with a dozen colums and about 150 rows.
in the 1st row cells I have a conditional formula which states Sumif "cell
Range", "Salesman Name", "Copycell Range".
I'm trying to copy and paste the whole column in the hopes I retain the same
cell ranges and formula, but evertime I paste from column A to Column B the
whole range shifts the column range.
My question is this;
Is there a way to keep the conditions in the formula from changing?
Please help.
in the 1st row cells I have a conditional formula which states Sumif "cell
Range", "Salesman Name", "Copycell Range".
I'm trying to copy and paste the whole column in the hopes I retain the same
cell ranges and formula, but evertime I paste from column A to Column B the
whole range shifts the column range.
My question is this;
Is there a way to keep the conditions in the formula from changing?
Please help.