I have a spreadsheet with formulas referring to another worksheet. I need to
copy the columns however, each time I do, the formulas advance to another
cell. Which is an incorrect reference, skewing my results.
I have a spreadsheet with formulas referring to another worksheet. I need to
copy the columns however, each time I do, the formulas advance to another
cell. Which is an incorrect reference, skewing my results.
You need to modify the formulas to use absolute references. Edit each of the
cell addresses in the formula and put $ (dollar signs) in front of the column
letters.
"sgluntz" wrote:
> I have a spreadsheet with formulas referring to another worksheet. I need to
> copy the columns however, each time I do, the formulas advance to another
> cell. Which is an incorrect reference, skewing my results.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks