I want to fill data in one cell in one sheet across multiple sheets; ie I have different totals, in different sheets, but with the same row & Col. no. (eg A10). I want to create a list, in a separate sheet, of all these totals, by auto filling across the worksheets. It would take too long to select each cell that has the total in it individually. eg: I have 4 Sheets: 1, 2, 3 and 4. Total is in cell "A10" in sheets 1, 2 and 3. I want to create a list in sheet 4 of the totals in sheets 1, 2 and 3, without selecting each total individually. (Similar to summing across sheets:"=sum(1:1!A10)" gives the sum of the totals in cell (A10 in sheets 1, 2 and 3).
Bookmarks