sheet name

Hello - I am using activex checkboxes to hide/unhide cells as well as sheets. I originally wrote the code to update the sheet name based on cell value, but then the check box code would fail. Now I am trying to write the code to continue working no matter what the sheet name is changed to...

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...

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...

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...

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...

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...

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...

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...

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...

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"...

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...

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)...

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...

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...

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...

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...

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...

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...

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...

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...