Is there anyway to have tabs within tabs? Right now there are only two layers...workbooks and worksheets within workbooks (tabs). Is there anyway to have more than two layers?
So right now:
1) Workbook
a. Worksheet
b. Worksheet
Can we get to:
1) Workbook
a. Worksheet
i. ?
b. Worksheet
i. ?
ii. ?
I have a summary page that includes the titles for each tab within the excel 2003 workbook. I want to use the names of the tabs in the summary page and create it into a formula to lookup fixed cells within the various tabs. Sorry for not uploading an excel doc but I was at work earlier and the thread did not load for some reason, so I am reposting it.
I'm using Excel '03SP2 on Win 2000sp4. I believe I have a case where old tabs originally written in Excel ' 97 behave differently than new tabs in the same workbook, which is saved in 2003 format.
Specifically, the formula ="PLAN" & budyr-1 where budyr is a named range on a different tab containing 2008 . This formula yields PLAN 2007 on a new tab and #VALUE! on an old tab.
How do I get Excel to update the old tabs so that they behave as Excel 2003 tabs?
Is there a way to group tabs? For instance, I have 3 tabs that go with one section and 3 with another and so forth. Is there a way to group them? Also, can you change their color?
if there is a quick way to add any number of tabs to a spreadsheet.
ie one particular spreadsheet i need to have 32 sheets (tabs) but am getting seriously bored to right click insert worksheet time after time. there must be a quicker way?
I am having some trouble with a handy formula I learned over this forum and its application between two tabs.
Referencing the attached workbook, the formulas in cell C6 & C7 are working for the end range I want, but the first section doesn't want to work. I'm not sure if it has something to do with the quotes (") or not.
I currently have the following code below set up which sends out two seperate emails to the same person out of excel. I'm trying to combine this to only send out one email with both tabs:
I have a workbook where each tab represents a 'base.' You can select which base to view by selecting an option from a drop down box on a menu page.
The data for each base is of a confidential nature so I would like to password protect each tab so that it asks for a password BEFORE the page opens. I don't think Excel has the functionality to do this unless I make the pages 'Very Hidden'?
I have a workbook with several tabs. The top tab is the main spreadsheet were I enter all my gathered data. The other tabs are the same spreadsheet, the same data, but broken out by specific building.
Right now, I enter the data (alpha and numeric) into the main spreadsheet, then manually copy/paste it to the respective sub-level spreadsheet.
I can specify the "IF" part of the line item that would identify which sheet to copy it to, but is it possible to have a "THEN copy and paste [these cells]" to the other spreadsheets?
How can I get my tabs to collaborate. If I make a change to the main tab I would like it to carry out through the rest of the tabs. Like the table format and formulas.
I have created a simple button that I want to take me to a certain number of tabs. I have about 24 tabs. I can't see them all. I create a button that will take me to a specific tab from my main page. This works fine till I rename the tab. I want the code to read a sheet number or something like that instead of the specific name.
Sheets("JobList").Select Range("A8").Select This works till i change the name "JobList"
I have a workbook with roughly 100 tabs and a summary tab for the data within the 100 other tabs. on the summary tab I have column A with the name of each tab, i would like to copy a formula down column B that pulls the data from each tab on cell C5 for example, maybe even look up other info too, but that is another question.
What i need to know is can i write a formula that uses the tab named in column A and pulls the cell C5 from that named tab without having to manually change the name of each tab in the formula?
The basic formula would be ='17003.05'!C5 however since i have 100 tabs, i did not want to have to go in and edit each tab name.
I am unable to view my tabs in excel - the tabs are there, they just can't be clicked on per say. I have double-check the tools option and verified the correct box is check to view tabs, however, I can't view the tabs. I tried to color a tab and it colored it red, but I can't really view the tab. I can see a red line underneath the directional arrows when I am working on that particular worksheet, but again, I can't view/click on the tab.
I have in column M ( starting at M2 and going through to M273 ) a list of names I wish to have new Tabs automatically made for.
There are some cells in this column that are blank and therefore have no name.
I need each new Tab to be a copy of a template sheet called 'DataTemplate'.
I am currently using the following formula, and I have it pasted in the sheet code of the worksheet where the list is found ....
Sub test() Dim r As Range On Error Resume Next For Each r In Range("m2", Range("m" & Rows.Count).End(xlUp)) If r.Value "" Then Application.DisplayAlerts = False Sheets(r.Value).Delete Application.DisplayAlerts = True Sheets.Add.Name = r.Value End If Next r End Sub
However, the new Tabs are not being generated. I've tried saving the file, exiting and coming back in, but still no new Tabs.
I have a PDF document that is one single table but it is long so it takes up 30 pages. When i convert from PDF to Excel (Using a converter) it gives me one tab per page I.E. 30 tabs.
I need to do calculation on the data, and need them on one page. Is there a way to merge tabs, or a macro that will do it for me?
I have a workbook with 100+ tabs(not in alphabetical order), and am constantly scrolling back and forth looking for tabs, is there a quicker way to search tabs? I have also right clicked the arrows to pull up the box with all tabs, but not the best option either.
There seems to be oodles of vlookup VBA queries on here and i've spent a few hours reading, and learning, but this twist seems to be missing. Apologies if Ive missed it.
I have one spreadsheet which will contain a varying number of worksheets on a monthly basis.
Worksheet names will also vary but will always contain abc somewhere in the name.
I have one "destination" worksheet which needs to receive the values from whichever abc worksheet is applicable.
I'd like the vlookup in worksheet SER01 to look up values in its column A, compare them to column K in the abc worksheets and give me the value from column AD in the abc worksheet and deposit it in column H in the SER01 worksheets.
For another challenge - this is an outside chance only but the additional twist is that sometimes my lovely colleagues move the columns - so the columns in the abc worksheets may NOT ALWAYS be K and AD - but will ALWAYS be in the spreadsheet somewhere. As i say this is a now and again and i dont' know if its possible to search all columns in a range of worksheets... is that too much for the PC - will it fall over
I got a excel file with quite some tabs. And i have 2 questions about it.
1 is it possible to "clone" a button with some macro? Lets say i create a button with a macro on tab number 1, is it possible to clone the button onto the 50 other tabs so i dont have to add the button 50 times?
2 i have a value on tab1, how can i make a formula (on tab number 2) that simple says: previoustab A1 + 2. So when in tab1 A1 i have 1, the cell in tab2 would give 3?
I know i can refer to a tab in a formula, but is there a way to just refer to the "previous" tab instead of using the tab name?
I have put together a workbook that utilzes 28 seperate worksheets. Of which I currently get it to show 9 worksheet names. Is there a way to show more tab names, like by having 2 rows of tabs instead of 1 or something like that?