tab name

Hi there, I'm looking for a formula to link back a tab from separate file (file stays the same) but the tab name will be the changing parameter set on what is in cell A1. So for instance: In a file "Z" cell A1=YOY (that's my tab name) Therefore, I would like to link what's in a cell D1 of...

Hello, I have a macro that creates a new sheet from a template and renames these tabs based on a list. The template is called "Template" and the list is in column A of a tab named "List". See code below. Sub Copy_Sheets() Dim i As Integer Dim wks As Worksheet Dim Last_Row As Long Set wks =...

hy all, i'm got VBA code for taking a sheetname into cell, but problem is it's not run automaticaly, so everytime i change the sheetname the i must recalculated to make the sheetname on cell change. this is the code : Public Function sheetname(ByVal target As Range) sheetname =...

Hello everyone, I am a first time poster here, but a long time user of Excel. I have not needed to dabble in macros or VBA until recently, so I'm fairly new with them. Using: Excel 2010 Prominent Cell: H4 = Pay Period Ending Date, drop down list of dates through the PPE 12/6/2013 Current...

I am trying to create an employee performance evaluation workbook in Excel. Here's what I have in mind: Each employee has an Excel workbook (e.g. Employee.xls); Each workbook has different tabs for different managers to access (e.g. Manager 1 and Manager 2); All managers enter scores for...

How do I reference a worksheet name within the worksheet itself? The header/footer section will do it with the reference [TAB]. I can find nothing on this site or in Excel Help. Here is what I am looking for: Tab name is Sheet1 I would like a command that will simply put the name of the tab in...

Ok so I have come to brick wall and don't know where to go from here. This is the first tab I'm working from:<TABLE style="WIDTH: 493pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=657 border=0 x:str><COLGROUP><COL style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt...

How do I reference the name of the worksheet in a cell within the worksheet itself? Example: "Worksheet (2)" is the name fo the worksheet. How do I get Worksheet (2)" to appear in a cell which references the tab name? So when they change the tab name it changes the cell result. Thanks.

Hello All!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Awesome forum!<o:p></o:p> <o:p></o:p> I am trying to create a tool to help with some calculations we do all the time. Every time we design a new product, we need to do several...

Hi, In column A I have a list of all the tab names (numbered 1-90). In column B I want to get the value of a constant cell from each worksheet (cell $I$47 in each tab). Is there a way I can use the tab name in column A as part of a formula to return the result, so that I can enter it once in...

Hi, I am using a heap of INDIRECT statements on a Reconciliation tab of my workbook, this makes the updating of these formula very easy by just changing the cell data to a different tab name to alter my lookups. The problem I am trying to adress is ...... is there a way to check that the data...

The code below works for renaming all work sheets in the workbook, however I would like the ability to rename sheets 1 thru 10 and keep the current names in worksheets 11-20. Can anyone help with this. Sub RenameTabs() 'If cell A1 has no content, then that tab is not renamed. For i = 2...

I have a workbook with a hundred sheets. I want each sheet in the workbook to be named by reference to the value of cell A1 in each sheet. How can I do this. What script/code do I need and where do I paste it? Thanks