sheet name in macro

I pull reports of various employees that list the number of meetings and the types of meetings they had during a pay period. When I pull the report, excel gives every employee their own worksheet. For example: Sheet1 - John Doe, 3 evaluation meetings, 1 commercial meeting Sheet2 - Jane Smith...

Private Sub CommandButton1_Click() Dim ws As Worksheet Dim ws2 As Worksheet Dim lastrow As Long Dim lastrow2 As Long Dim rownum As Long Dim ws2name As String Set ws = Sheets("RAW DATA") lastrow = ws.Cells(ws.Rows.Count, "E").End(xlUp).Row For rownum = 2 To lastrow Select Case...

Hey Excel Gods need your help for a small problem. VBA noob here. i have a workbook with Sheet 1: - random date entry(which will manualy updated) in Column B4:B100 i have 2 macro lets cal it "1" & "2". Macro 1 create a new sheet with the sheet name same as date entry of B4 in Sheet 1 and...

Hello, I have a workbook full of order sheets, I am attempting to figure out a code that will automatically generate the name of sheet based on one cells' value (ex. W9). However; if they cell should be empty, I would like it to keep the name as Sheet1 or Sheet2, etc. Attempted to find sources...

Hi, I need to merge to Macros to work with each other. The first Macro grabs names in a cell range then makes new tab names with the names in those cells - Sub Invoices_Add_Named_Tabs() Dim MyCell As Range, MyRange As Range Set MyRange = Sheets("Address").Range("A2") Set...

I'm trying to create a very user friendly form for a team of mental health workers, who are not tech savvy. Essentially, it's a progress note that is filled out after each session. I'd like for the template to carry over to the next sheet and be named the date of session that the therapist...

Hi everyone, First ever post! I am modelling several companies in one workbook. Each company has an input sheet, calc sheet and results sheet. I would like the model to be dynamic, so in an 'Assumptions' sheet I can have a table with the company names in it. These names should be an input, so...

Hello, So, I've highlighted my worksheet "Sheet2 (Instructions)" in the VB editor I pressed F4 to bring up the properties toolbar and I was able to changed the VB name of my worksheet to "Instructions". Therefore, in the VB editor, the worksheet is now called "Instructions (Instructions)". I...

Hi Everyone, I've been reviewing various posts from this forum to piece together a solution, but was unsuccessful. I have a workbook with a bunch of sheets and I am interested in the sheets that begin with the letter "P". Each of these sheets is named "P###" with #s ranging from 0-9 and not...

I wish to reference a sheet in my VBA code. What is the way to refer to a sheet by the name of the "tab name" instead of just the "Sheet 1", "Sheet 2", etc?

<TABLE style="WIDTH: 317pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=423><COLGROUP><COL style="WIDTH: 317pt; mso-width-source: userset; mso-width-alt: 15469" width=423><TBODY><TR style="HEIGHT: 217.5pt" height=290><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT...