Is it possible to copy a drilled cell (same cell in multiple worksheets) and transpose the results onto a single sheet in a column or row?
Is it possible to copy a drilled cell (same cell in multiple worksheets) and transpose the results onto a single sheet in a column or row?
Would either of the options displayed in the attached file be useful? Both require a helper column populated with the sheet names and both use the Indirect function.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks