I'm using a worksheet with multiple spreadsheets. Spreadsheets named "Day1" to "Day10" and the eleventh spreadsheet is the summary sheet.
Each spreadsheet has its own date.
Calculations on the spreadsheets end with an colum ("AA10" to "AA100") with closing values.
Depending on the date on the "Summery Sheet", i need a formula to lookup the date on the spreadsheets "Day1" to "Day10" and return the values from this spreadsheet to cell "C10" to"C100".
thanks you!!
Each spreadsheet has its own date.
Calculations on the spreadsheets end with an colum ("AA10" to "AA100") with closing values.
Depending on the date on the "Summery Sheet", i need a formula to lookup the date on the spreadsheets "Day1" to "Day10" and return the values from this spreadsheet to cell "C10" to"C100".
thanks you!!