new basis report bhavna basis report updated cover 2000 prices called basisnw 7 xls erg database looks working correctly course without data little hard confirm always ultimately job verify numbers reported correct lem know problems easy change spreadsheet start new year keep mail message reference 1 add 12 expression printmacro b 35 e change copy offset henrycash 12 againstyear 63 12 1 2 define new cell reference basis page first date printed report page example last year basis report went jan 93 dec 1999 basisnw 6 xls name jan 93 defined basis 64 e refers row jan 1993 basis numbers recorded year basisnw 7 xls defined jan 94 refer basis 76 basis report run jan 1994 dec 2000 3 change expression printmacro b 45 use new cell reference e change copy offset jan 93 12 indexyear report 12 1 4 executed steps 1 3 spreadsheet print numbers shifted one year remains change dates printformat page one year mean change 1998 1999 1999 2000 change 98 99 99 00 etc move numbers formulas discussed bhavna happy best interest continue please work find one shop maintain spreadsheet regards happy new year grant