View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LEA LEA is offline
external usenet poster
 
Posts: 9
Default Copy and paste absolute reference

I have cells with absolute reference formulas within a table, referring to
cells in that table, how do I copy the table further down the worksheet, or
to a new worksheet with the absolute references referring to the new table
and not referring to the cells at the top of the worksheet