worksheet name

I have a number of worksheets which contain audit score results (they are all the same format), there is one for each individual, therefore I have labelled the worksheets with their names. On a summary worksheet, I want to display the same field in each of the worksheets. E.g. In Jon's sheet...

I have a worksheet with columns for each Dept; containing Dept-local details of 'across the board' details (eg Dept staff names, equipment issued &c) I want to consolidate them all back to a front-page Summary for the Company. Each worksheet will have a Dept Name: & I do not need them to...

I have looke at threads asking the same question to some degree. I have tried some of the recommended marco solutions, but not solve my requirement. I run a raw data report each day and use a Cygwin shell script to group and create up to 20 separate .csv reports. They are all named based upon...

Basically, I am using: Private Sub Worksheet_Change(ByVal Target As Range)ActiveSheet.Name = Range("C2").ValueEnd Sub To name my worksheet where: C2='List of Students'!D5 In this instance the worksheet does not update this name when I update D5 in the other worksheet as C2 is a formula. Does...

Sub CheckAndAddSheetNameAsCurrentDate() Dim SheetName As String SheetName = Format(Date, "dd-mm-yyyy") 'Change the format as per your requirement On Error GoTo AddNew Sheets(SheetName).Activate Exit Sub AddNew: Sheets.Add , Worksheets(Worksheets.Count) ActiveSheet.Name = SheetName End...

Hi all I have the following code but need to tweak it so that on the 2nd time it runs, it no longer creates every single sheet, but only new sheets (not yet on the workbook). Can anyone help? The purpose is to create new sheets based on sheet 'Template'. Also I'm having some trouble on the...

Hello, I have a REIT summary worksheet which contains different account names starting from Cell A4. Within the whole workbook, there are also different tabs, each named by the account name and contained information of that account. I would like to build a macro which find the account name...

Hello, hope everyone is doing OK. I have been using Microsoft office products for years now. I've only recently discovered however, macros and some of the other "behind the scene" tools available. What I could use a hand with is this; with the help of my son, I have recoded a macro that records...

Objective: I would like to ask the user if when the name the worksheet the same as an already existing spreadsheet tabe if they would like to overwrite it or unload the user form. I am not sure of two things: 1. how to find the already existing tab? 2. Once I find out how do I programatically...

I am using Excel 2010. I am trying to pull the string of the SlicerItems that equal True and pass it to a worksheet name. I need some help trouble shooting the code below: Sub SlicerName_Copy() ' ' Objective: To read what is selected by end-user with Slicer and copy the selection '...

Objective: To pass multi-selected items to other macro to perform routine. Known issues: Sometimes I have one item selected sometimes 20, but in all cases I need the name of the item selected to pass to the next routine and execute appropriately. NOTE: each selected item should be treated...

I'm new to this (actually any) forum. So please bear with me... The problem I have is: In a workbook I have a calculation sheet and worksheets that contain the data to calculate named in a "mm-dd-yyyy" format. When I switch to a different day I have a macro that prompts me for the worksheet...

Hi everyone, I need to copy data from one workbook- all of it, containing multiple worksheets. This needs to be pasted onto a new workbook with the same worksheet names as the previous workbook. I need help with copying the names of the worksheets and pasting them onto the new workbook. And...

Hi all, I want to programmatically add a title to a chart. The chart is on a chart sheet (what happens when you hit F11), not on the same sheet where the data source is. The title text is on cell A1 of the worksheet with the datasource. Now if the data source is on the sheet "data" then...

I have been stymied with an INDIRECT function issue and feel like I am very close to resolution, but need assistance from an expert. My workbook has a Summary worksheet that needs to pull from specific cell references in subsequent worksheets. The following formula works if the worksheet name...

I am using the following formula to display the first 7 characters of a worksheet name in a cell. =LEFT(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256),7) It works perfectly. However, when I copy the worksheet, move it it a new workbook and save the workbook with a name that is...

Hello Please assist me with the following problem: I'm creating a wookbook with 12 worksheet with an iconic name as "YYYYMM - Monthly Occupancy", where YYYY = year and MM = month. Lot of formulas are interconnected with the name of the working sheet and the sheet for the previous month...

Hello, I am creating a workbook that will allow multiple users to work at once. When the workbook opens, a template is copied and pasted as a new sheet with their name as the sheet name. The workbook_open macro looks at their windows username in a list and then creates the sheet for their name...

OK, folks... some more VBA help needed please!!! I need to create a macro which will prompt the user to select a PDF file on their HDD, then have the PDF filename used as the worksheet name. The PDFs have the same naming convention: "MachineReport 1234ABC 31102011" where MachineReport is...

Hi. How do you to refer to an specific worksheet depending on a selected value. For example, I have 4 sheets named: "5", "ac", "ad", "6" (instead of "sheet1", "sheet2", "sheet3", "sheet4"), in the vba code, the user may choose from three options: A or B or C, so: if the user selects A, I...