View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vic Vic is offline
external usenet poster
 
Posts: 117
Default link formulas sheet 1 to same cells for sheet 1,2,3 etc

my workbook consist of 10 one year expense tabs 2009 thru 2019 and a summary
tab.
i want the summary tab to tally the calender year expense as i copy the
summary tab from year to year. Every year tab uses the exact same cell from
year to year. the only difference is the the tab 2009, 2010, 2011, etc