-1
votes
0answers
22 views

2 Excel Tabs: Find matching values in column As and match the B columns based on A. (Only one tab has B filled)

I have two tabs in excel; one working with technologies and one with patents on those technologies. The technology tab has each tech ID in column A, and the patent tab has the same tech ID numbers but ...
2
votes
0answers
27 views

In Excel, Can I have two rows of (worksheet) tabs for my workbook? [duplicate]

I'm using Excel (2013). I have a workbook with numerous different worksheets, and would like to have them take up two rows of worksheet tabs rather than just one. Can I achieve this somehow? I can't ...
0
votes
1answer
66 views

Using the contents of a cell to refer to a worksheet name in a formula

I have the names of dealers along with the associated data located in various tabs in a particular workbook. I wrote a sumif formula for one and included the names of the dealers in the cell to the ...
1
vote
0answers
134 views

How do I create a master list in excel that displays the most recent entry from each tab on a worksheet?

I'm creating a workspace (on excel 2003) with three worksheets: active, inactive, and master-list. Tabs will move between active and inactive, based on whether or not I'm currently focused on them. I ...
3
votes
4answers
13k views

How can I set a keyboard shortcut to switch between Excel tabs?

I find the Ctrl+ PgDn/PgUpnot good enough. When I have a lot of tabs it's very annoying to get to the right tab, or move it and change the order, which is sometimes important. I need Excel to switch ...
0
votes
1answer
527 views

Tabs automatically from list

Excel 2007: I need to make tabs automatically and place the tab name in a cell on each new tab. What I have below, from a command button, will make the new tab. How can it read from a list of names ...
1
vote
3answers
3k views

Move the Worksheet Tabs in Excel 2010 to the top of the Window

It is standard that when you open MS Excel, the tabs for each worksheet appear along the bottom of the window (as "Sheet1", "Sheet2", "Sheet3", etc). I would prefer those tabs to be on top of the ...
0
votes
1answer
85 views

Add another worksheet in an Excel worksheet

Is it possible to include an additional set of worksheets (i.e. "tabs") into an already existing worksheet in Excel?