Forum Discussion
Welcome to the Excel Community
Good Morning All,
I know this is probably a very simple question - but the gerbils are not running at 100% yet. I have multiple spreadsheets - let's call it 4 separate tabs of company information by type of company, what I am wondering instead of having to jump from one tab to the other tab. Having a Single page with ALL names listed or simply using the FIND option to drive you to that name?? Hope that made sense, as some of these tabs have 20-30 names and a whole host of information, so scrolling up-down is silly.
Yes, that might be handled with a single formula on your Single worksheet. It might be handled like this (depending on your version of Excel, which you should mention when posting):
=SORT( VSTACK( 'Company Type 1'!A2:.A999, 'Company Type 2'!A2:.A999, 'Company Type 3'!A2:.A999, 'Company Type 4'!A2:.A999 ) )
Naturally, you would use your worksheet names, and change the column letter from A to whichever column contains the company names (it can be different for each worksheet). And by using a "higher" letter right after the colons, you can retrieve multiple columns at once. VSTACK info The periods immediately after the colons reduce the ranges to however many rows contain data, as described here; just remove them if your Excel version does not support that.
In the future, please do not add your question/issue/problem to the end of an unrelated post such as this. Instead, click the big blue "Start a Discussion" button near the top of the main page to start your own message thread.