View Single Post
  #1  
Old September 23rd, 2008, 09:29 PM posted to microsoft.public.excel.worksheet.functions
MJKelly
external usenet poster
 
Posts: 10
Default copying absolute formulas


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