User Profile
Harun24HR
Silver Contributor
Joined Nov 07, 2020
User Widgets
Recent Discussions
Re: Need 1 worksheet to add totals from multiple worksheets in the same file.
* asterisk means all sheets except current sheet. Even if you enter the formula to middle sheet, then it will automatically update sheet references like. Suppose you have 5 sheets in a workbook. You entered =SUM('*'!A1:A10) to Sheet3. Then formula will automatically updated to =SUM(Sheet1:Sheet2!A1:A10,Sheet4:Sheet5!A1:A10)Re: Cell drop list of workbook sheets
Use the following formula to a name manager then use that name to data validation list. =TOCOL(TEXTAFTER(GET.WORKBOOK(1)&T(NOW()),"]")) See the below article for more details. https://techcommunity.microsoft.com/discussions/excelgeneral/rename-cell-to-various-different-sheet-titles/4430814/replies/4431560
