worksheet name

  1. S

    Naming Worksheet with Two Range Values

    Hi all, time to ask for help. What's the error please: Sub m_NamePastAdmin() ' Application.DisplayAlerts = False Application.DisplayStatusBar = False Application.ScreenUpdating = False ' ws_3Admin1.Activate ' Dim LastCol As Integer Dim LastRow...
  2. Small Paul

    VBA to Copy/Paste Range in Sheet Named By Cell Value

    Hi I have a worksheet named "Required Data". In column A is a variable range of numbers (1,2,3,etc) and for each number there is a corresponding worksheet (named 1,2,3 etc). I need to copy the data in columns D:M and paste it in the 1st empty row of the corresponding worksheet e.g if A2 is 1...
  3. Small Paul

    VBA WS Name from Cell, Loop Copy/Paste

    Hi I have a worksheet, “Required Data”, which has data in columns A:M. In column A I have a list of numbers which are derived from criteria in the worksheeet. Starting at cell A2 (A1 is a header) this presently runs 1, 2, 2, 2, 2, 3, 4, 4, 5 etc to 76. Each of these values have a...
  4. M

    copy values to another sheet based on cell value

    hello im trying to copy values in some cells to another worksheet whose cell name is based on the value in e1. Example value in e1=10mm so when my macro works the items i want to copy will be placed in worksheet named "10mm" i have a working macro where the worksheet "demand log" is...
  5. S

    Copy Closed Workbook Sheet1 Not Retaining Worksheets("name")

    I'm working on creating a template workbook to create a worksheet with the current date and then bring in a previous day's report for comparison. Prior to the code below running, the workbook is renamed and sheet1 is renamed "User Accounts 10-31-18." The closed workbook is a previous report so...
  6. Small Paul

    Worksheet Download Random Name - Wildcard?

    Hi All Sorry, I have to ask for a bit of help here. I have a daily report downloaded which gives a worksheet name of 'report123456' but the numbers are randomly generated. In order for my subsequent macro to work, I think I need to either: a) change the worksheet name to 'Data' b) have a way...
  7. D

    Adding worksheet name to powerpoint slide title

    Hello Experts, I have the following code which loops through an Excel Workbook and copies all the charts from each worksheet and then pastes into a new power point slide, max of 4 charts per slide. The modification I would like to make is to add a title to each ppt slide and paste the...
  8. M

    How to reference a different worksheet's title in a formula

    Is it possible to reference the name of another worksheet in a formula? For example, if I have a set of data with fields for January, February, etc., and have tabs that are named January, February, etc., and I want to lookup data in those tables based on the month specified in the field, is...
  9. J

    VBA to replace part of formula in multiple cells across a row, using sheetname(s)

    I am using Windows 10, Microsoft 2016 I have an Excel file with multiple worksheets. Each worksheet has a LName as a name. (200 sheets) I also have a 'Data' tab. On my 'Data' tab I need 200 rows of data each row using the name of a worksheet in several formulas across the row. Example of...
  10. R

    Pass worksheets Name to API one by one

    Hi Guys, I want to run a piece of code for all the worksheets in the workbook. this code is an API which calls functions. Code I am using is below. Dim rngData As Range Dim EPMObject As New FPMXLClient.EPMAddInAutomation Dim WS As Worksheet Dim Name As String For Each WS In...
  11. S

    Rename Worksheet to Cell Value

    Bad day. Using the information here: http://www.mrexcel.com/forum/excel-questions/849243-visual-basic-applications-make-sheet-name-%3D-cell-value.html I had a macro doing what I wanted. Now it's not and for the life of me I can't see what I did that made it stop working. Not that I know much...
  12. M

    Copy row to sheets if cell in col A=sheetname

    Hi- Been all over the web today and in this forum, and so close, but no cigar. I need to copy a row from "Master" sheet to other named sheets in one workbook, based upon CellValue Col A = sheet name. Continue down col A, copying the row to the appropriate sheet (jumping to End.xlUp.offset1 of...
  13. L

    Name a range based on worksheet/tab name

    Hi I have recorded a macro to see the code to do this though am stuck. I am trying to create a named range in a worksheet, for a data range that changes monthly. I want the name of the named range to be based on the name of the worksheet the data resides in. For example, if the worksheet...
  14. A

    VBA - copy worksheet to another workbook if the sheet name matches partially

    I have a source file (open workbook, not saved to a location) which can have 6 to xx number of sheets. The source file sheet names usually follow the logic of: Overview, Components, System-1, Hints-1, System-2, Hints-2, System-3, Hints-3,... Add-on products, Hints-12, Services etc... I need to...
  15. S

    Applying function to multiple worksheets based on array of names

    I'm trying to create a function that can be applied to multiple worksheets based on the worksheet name. I know what function I want to apply, but I can't seem to figure out how to organize the process Layout: You have 3 shapes in each worksheet (M1,M2,M3). M1 links to Sheet A1B1, M2 links to...
  16. S

    Extracting name of sheet having maximum value in a particular cell

    Hi, I am using the following formula to get maximum value from a particular cell across 97 different sheets with name variation. This works fine. How can I get the sheet name from which the maximum value is coming? Best, Sushant =MAX(MAX('LK1 - 4.1 Stäbe - Schnittgrößen:LK9 - 4.1 Stäbe -...
  17. V

    vlookup - can a formula be used to generate the table_array parameter?

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

    How can I access the WorkSheet name within the worksheet to trigger action ?

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

    Change TAB Name

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

    VBA: Using Macro to set sheet name from cell, but this won't work if cell is formula, can you help me?

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

Some videos you may like

This Week's Hot Topics

Top