I have a sheet name summary in the workbook where i maintain the
summarised data of all the sheets in each row .
example students noofdownloads noofprints
week1 123 234
week2 345 254
when a new sheet is added to the workbook , the summary sheet should have another row
week3 345 354 (i mean total the things in week3 which is same formula used for othe rrow. this should happen without human intervention . How to do this .
summarised data of all the sheets in each row .
example students noofdownloads noofprints
week1 123 234
week2 345 254
when a new sheet is added to the workbook , the summary sheet should have another row
week3 345 354 (i mean total the things in week3 which is same formula used for othe rrow. this should happen without human intervention . How to do this .