sheet name

  1. P

    Insert cell value as sheet name in VLOOKUP formula

    Heeeelllo, I am not sure how this works, I've invested a lot of time into this, please help. Thanks so much. So... I have this formula, which works perfectly fine, but I want to make it more automatic right? =IFNA(VLOOKUP(B5,IMPORTRANGE("mydocURL", "517!A:F"),6,FALSE), "0") I have several...
  2. E

    How to use Sheet name instead of Tab name?

    Hi folks! How do I replace the tab's name ('Electrical') with the actual Sheet name (Sheet 11)? Whenever I try it doesn't work, here is the good working code below, just need to use the sheet name (Sheet11) instead of the tab name ('Electrical'): Private Sub Worksheet_Change(ByVal Target As...
  3. L

    Set range according to active sheet name VBA

    Hello there! I ran into some issues using VBA with my limited knowledge. I am trying to combine a code to delete pictures in a range, which works as it should: Dim pic As Object For Each pic In ActiveSheet.Pictures If Not Application.Intersect(pic.TopLeftCell, Range("A8:T35")) Is Nothing...
  4. WildBurrow

    Paste Entire Row if Cell Value Matches Sheet Name - Resize(?) and Offset on Destination Sheet

    I'm having extreme difficulty figuring out how to resize (I think that is the term I'm looking for) and offset pasted information. I'm using column ("A") from the source sheet ("Summary") to match tab names in the workbook. I found code (see below) that will copy and paste accordingly...
  5. WildBurrow

    VBA to trim cell values for sheet name

    I'm stepping off the porch to play with the big dogs; I'm posting my first question and providing a sample of my code. I am using input message boxes to obtain info that will 1) populate cells on the worksheet, and 2) be used in the naming structure for the worksheet. The issue is that...
  6. sleek12

    Lookup (unique and duplicated values) from Multiple worksheets and return sheet name

    small errata, 21/8 70,000=70,000 variance, Crossposted from:- Chandoo.org However its not been answered to. AB1Sheet nameDetails2DTBhas three columns Date, particulars, Amount3BARCLAYS1has three columns Date, particulars, Amount4BARCLAYS2has three columns Date, particulars, Amount5BARCLAYS3has...
  7. S

    Name a Range and Use Range Value to ReName Worksheet

    Two problems. 1) I can't reference the cells like I'd prefer. 2) I can't get the worksheet renamed. I import a text file with the file create date preceded with a space as the last value. So the last entry in column A is the date the text file. I'm trying to concatenate the text "User Accounts"...
  8. G

    Using VBA to Make Sheet Name equal to Cell Data

    Good morning Everyone, I am trying to make my tab/sheet names equal to the cell values. I am using the formula provided by this page: https://excel.tips.net/T002145_Dynamic_Worksheet_Tab_Names.html This formula was created to pull values from a single cell. I need to pull values from two...
  9. T

    VBA to Make SHeet Name Equal Cell in Sheet

    Hi everyone, I used the second VBA code option on the following site to make sheet/tab names equal a cell value within their respective sheets: https://excel.tips.net/T002145_Dynamic_Worksheet_Tab_Names.html The problem is, the names do not update automatically (as is claimed on the paged)...
  10. tlc53

    Refer to sheet by name stored in cell - Amend code

    Hi, I have the below coding which works fine but instead of referring to the sheet named "Cordis", I would like it to get the sheet name from cell A12 (which has "Cordis" typed in it). Private Sub CommandButton1_Click() Application.ScreenUpdating = False Sheets("Monthly Data").Select CleanUp...
  11. tlc53

    VBA Code - Refer to cell for sheet name

    Hi, Is there a way to amend the below code so that instead of referring to the sheet name (AAI01) it picks it up from the current sheet, cell A1. So cell A1 contains "AAI01". Thank you. Private Sub CheckBox1_Click() If CheckBox1 Then Call SavePdf1("AAI01") CheckBox1.Value = True...
  12. G

    INDEX/MATCH with dynamic sheet name

    Hello, I am trying to set up a formula that will execute an INDEX/MATCH in one of a variety of sheets, depending on cell being matched. I believe the INDIRECT function is part of the solution but I haven't had any luck with it. I am happy to use a number of distinct steps as working formulae...
  13. S

    consolidate if sheet name contains...

    Hello, Please can someone help a new boy? I have a workbook with 4 sheets & 2 different title structures. This workbook is delivered as a .CSV file every month and has a different number of rows every time. I need to consolidate the 2 sheets that start with the word "single" and then the...
  14. B

    How do I refer to a sheet name in this formula?

    I have a formula: =SUMIF(DINOSAUR!$C$12:$C$37,K$3,DINOSAUR!$A$12:$A$37) where DINOSAUR is the name of another sheet in my workbook (it's also the name of a clinical trial) But the name also appears in cell F4 as shown here. Now I need to replicate this formula down the sheet for many other...
  15. V

    'Name' of object '_VBComponent' failed

    Trying to use sheet code names instead of sheet names, in case users change the sheet name, and the below returns the error "'Name' of object '_VBComponent' failed". Test2.Delete Worksheets.Add ws_name = ActiveSheet.Name...
  16. S

    Change Sheet Name

    Trying to figure out why this isn't working. When I change B2 to any number, it works fine and the sheet name is change to the corresponding number. But if I clear out the contents to B2 to blank, the sheet name stays the same as the previous number that was in B2. I would like it to change to...
  17. DDRA Steampunk

    Custom Function Causes Excel to + 1 every time it saves and won't auto calculate anymore

    What am I doing wrong? I'm using a custom function Function NxtShtNm() As String Application.Volatile NxtShtNm = ActiveWorkbook.Sheets(ActiveSheet.Index + 1).Name End Function That makes it so I can create the formula in Cell P1 to return the name of the event on the next page...
  18. R

    Moving Rows of Data based on value in a column matching name of sheet

    I am trying to move data in "Sheet 1" into newly created tabs. These tabs are created and named based on a list of values. These can change once opening the workbook. For example, we might create tabs A, B, C, D, E and the next day these tabs could be F, G, H, I, J. Now, I want to move data in...
  19. B

    Display another cell formula sheet name

    Hi guys This might be an impossible question, but anything is worth a go. I would like for one cell, say B1, to show the sheet name of a formula reference that, say A1, is linked to. Probably best if I show this in an example. If cell A1 formula: ='Sheet2'!C3 then B1 would say 'Sheet2' If...
  20. L

    Formula to search by sheet name and by table name using vlookup and indirect function?

    Hi guys, Would like to search value using vlookup and indirect function through by sheet name and table name? Plus, in every sheet has different table names in different arrays. Can you help me? Thanks guys.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top