This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
I'm summarizing a separate workbook which has like 15-20 tabs. So I'd like to use the indirect command to pull one cell (the total) from each tab.
In my Summary workbook, if I was to link directly to the source file, this is what it would look like: =('[F2023NIXTemplate_OCOOHQ Aug F23.xlsx]Proj_Cons'!$BL$80)
The "Proj_Cons" is referring to a tab name. I'd like to be able to replace that with various other tabs. So I figure the first step is to just take that formula and wrap the indirect command around it. And if that works then I'll look into changing the tab names. But even the first step didn't work.
How do I do this?
Subreddit
Post Details
- Posted
- 1 year ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...