sheet name

  1. airforceone

    Rename Sheet Name based on Workbook name

    just a quick question, is there a way to rename sheet name if workbook contains certain string? i.e. MainOfficeReport.xls if it contains the word "office" in the workbook name then change the sheet name to Office BTW, default sheetname for all report have the same name thus the need to change...
  2. C

    Macro to copy cells from multiple excels in a folder that changes name daily

    Happy holidays! And thank you in advance! In summary: I need a macro that would copy all the columns A:C starting from Row 2 if the sheet name is "Apply" or "apply", of all the excels in a specific folder. I need to paste all these values on another Excel. Example: Specific folder(changes...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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"...
  10. 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...
  11. 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)...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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
Back
Top