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 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 do have a file in excel with total 9 tabs. The last tab, has some formulas, which is taking data from tab 3 to 8 and calculates something. Tabs 3 to 8 are identical, (same data inputs from different departments). When I will distribute the file to some colleagues, they will need to add some tabs in between tabs 3 and 8, depending on their needs.
I want that in the formulas in the last tab 9, the data from the tabs entered additionally, is taken into consideration. How I can define the range of tabs, so that tab 9 takes then the data from all the tabs in that range, even if tabs are added in between?
I'm a bit over my head on this one. I want a formula that does the following: Look at the date I put in on the last tab and find the correct date on the other tabs. Using that date as the column I want it to return the correct row for the data.reference.
I am using the HLOOKUP function. I'm not even sure this is the right function. Ont the workbook attached I'm trying to get the data on the Totals tab to come from the Sept Wk 1 through Sept Wk 5 tabs. The formula I tried to use is on the Totals page C7.
I'm trying to come up with a Macro that once it see's the word "Rolls" in column M, I would like for it to go to the row below the word and divide the information on column K by 30 then for it to perform this formula for the next 17 rows and on the last row have the cell in gray color.
Then for it to keep doing this recursively down the column of the sheet and once finished to go to the next tab and do the same algorithm(there's like 40 tabs !!)
I need a formula that will allow me to look up data on different worksheets. I have 5 worksheets (1 summary, and 4 with raw data). The raw data tabs all have the exact same number of rows and columns but the data is from a different region. I want the user to be able to select from a drop-down menu which region they want summary data tab to pull from using a vlookup formula.
For example, I have five tabs in my workbook: Tab1) Summary Tab which needs to pull the data from the other four tabs, Tab2) named "West", Tab3) named "East", Tab4) named "South", Tab5) named "North". Using a drop-down list, I want to be able to select either West, East, South or North and have the vlookup formulas look at the corresponding tab for the data. So, in my example, if I select "North" from the drop-down menu, I want the vlookups to pull data from the "North" tab etc. I do not want to use PIVOT TABLES for this.
I have a workbook with 5 or more tabs. One of the tabs is a CONSOLIDATION of all the tabs put together. I have columns on the consolidation tab with the names of the individual tabs. To the left of these columns is a list of general ledger numbers with their respective names. For example:
East West NE South 6103256 –sales 6540000 -salary 510000-travel
I want a excel to look at the individual tabs, for this specific gl number and name and, if applicable, return a value. What formula would do this?
My columns are not showing up correctly. East,West etc are the columns. 6103256 - are the rows
I am trying to create a formula by comparing data in columns on a separate tab.
Basically, I want to take the value of one cell in the primary tab, find the matching value in a column on another tab, then once it is matched, pull in the data from another cell in the second tab on the same row of the matched data.
I am autocreating tabs running through a loop and I want to input a formula into certain cells with the tab that was created name into the formula becuase I got to refrence it in my formula and the cell so now I need to figure out how to get that name into the formula without it saying E.
I need to create a formula using 2 different tabs within an excel workbook. I need to search column A on the first tab and column A on the second tab and if they match I need to compare column F on the first tab to column F on the second tab. (This column contains my staff names but the problem I am running into is on the first tab their names are listed first name last name and on the second tab they are listed last name, first name). If column A and F match I need to search column H on the first tab to column H on the second tab. If all columns match up to this point I need to take the data in column Q on the second tab and in put it into column K on the first tab. Is this even possible?
I have attached an example workbook where I have three worksheets i.e. Data1, Data2 and Master Data all of which have the same data format in each column
I have data in the Data1, Data2 tabs and was wondering if it is possible to copy the data from both these tabs (using formulas) onto the Master Data bearing in mind the rows of data in the Data1, Data2 can vary on week to week basis.
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 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. ?
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.
