Hi,

I have a large number of formulas in a table. All seven days of the
week are represented. Monday has the correct formulas (and includes
absolute references (row only). If I copy the formulas to Tuesday the
wrong columns are now refereced. Instead of going thorough hundreds
of formulas, is there a way I can exactly copy the formula so all
references remain in tact?

Thanks,
Matt

MJKelly wrote:
Hi,

I have a large number of formulas in a table. All seven days of the
week are represented. Monday has the correct formulas (and includes
absolute references (row only). If I copy the formulas to Tuesday the
wrong columns are now refereced. Instead of going thorough hundreds
of formulas, is there a way I can exactly copy the formula so all
references remain in tact?

Thanks,
Matt

Look at the help file under Absolute Reference. If that doesn't help you, post
an example of one of your formulas, where it is located on your worksheet, where
you want the copy located, and what you want the copy to look like.