tab name in formula

  1. A

    Automatic Cell name change - Tab name

    Hi guys, I've seen people post how to change a Tab name based on a cell's value/name using a macro, but what I'm looking for is the exact opposite. I need to have a cell's name/value change based on a tab's name. Would appreciate the help. Thank you
  2. A

    Auto Looking up a tab on sheet indexing a certain cell

    Hi, I have a formula where i want to look up a cell which is date populated and then look up the corresponding tab with that date on it. We have tabs of data for every day. I just need to know what formula do i use to look up the tab? So in the below the XXXX part needs to actually be...
  3. R

    Tab hidden/unhidden formula

    Say I have tabs in excel named 1,2,3,...,10. Is there a formula to determine which of these tabs are unhidden or hidden. Example. Tabs 1 and 2 are open. Tabs 3 to 10 are hidden. Tab Formula result 1 Yes 2 Yes 3 No 4 No 5 No 6 No 7 No 8...
  4. Z

    Help with VBA to delete columns in new tabs

    Hello, I'm trying to make a macro that simply creates new tabs and assigns names to each by referencing a list. After doing so, I need it to delete Columns A:F per each new tab. The macro works fine if I take out Columns("A:F").Delete but obviously I need that in there. Any ideas what to...
  5. J

    How do I use a tab name and cell reference in a formula?

    I have a spreadsheet that pulls in values from another file. My question involves using a Tab name in a formula. I use my Total Order spreadsheet to total up my food ordering sheet based on what menu days are coming up. (We have 32 menu days, then start over again with Day 1. We only need to...
  6. G

    Dynamic Tab Reference in Formula

    I have a sumproduct formula below on a summary sheet in a workbook which works fine. I have multiple tabs in the workbook. Is there a way i can reference each tab based on a cell and copy this formula over based on the tab name? =SUMPRODUCT((Burt!B4:G4='Overall...
  7. T

    Adding TAB names into formulas

    Hello! I have a workbook, with lots of sheets. I am working on a summary sheet now and need a formula to look up data from the various tabs. Current Formula is =IF(COUNTIF(TABNAMEONE!$A$7:$A$47,Overview!L6)>0,1,0) I would need in the next column the formula to read...
  8. D

    Insert the worksheet / tab name to where a formula in a cell refers- formula possible?

    Hi Forum members, Thanks for all the useful information I've used over the years. I'd like to know if there's a way to insert into a sheet the name of the worksheet that a cell formula refers to, and not the name of the worksheet the cell sits in. I've looked at many postings on inserting...
  9. C

    Referencing A Sheet Name in a Formula

    Hi, In column A I have a list of all the tab names (numbered 1-90). In column B I want to get the value of a constant cell from each worksheet (cell $I$47 in each tab). Is there a way I can use the tab name in column A as part of a formula to return the result, so that I can enter it once in...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top