sheet name

I am trying to move data in "Sheet 1" into newly created tabs. These tabs are created and named based on a list of values. These can change once opening the workbook. For example, we might create tabs A, B, C, D, E and the next day these tabs could be F, G, H, I, J. Now, I want to move data in...

Hi guys This might be an impossible question, but anything is worth a go. I would like for one cell, say B1, to show the sheet name of a formula reference that, say A1, is linked to. Probably best if I show this in an example. If cell A1 formula: ='Sheet2'!C3 then B1 would say 'Sheet2' If...

Hi guys, Would like to search value using vlookup and indirect function through by sheet name and table name? Plus, in every sheet has different table names in different arrays. Can you help me? Thanks guys.

Hi all, I am stuck on one point: I want to retreive names of all the excel sheets but without macro. In fact to get the list of sheets available with its names on a specific other sheet. Do you have solution ? I search with sheet() or Sheets() but can't use with indirect(). Thanks!!!

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 have code that used to work beautifully until two days ago. It works on a workbook with multiple tabs - splits it into multiple workbooks from tab to tab with underscore _ in its name. E.g. I have a tab AT1_(AT stands for Atlantic) and three tabs after it - MD059 and PA199, then tab AT2_...

Hi, I searched about how to make drop down list from sheets name and i found couple answers by VBA and Formula GET.WORKBOOK and all works fine but when the guy in video used GET.WORKBOOK he said it's a macro formula and didn't work in cell only used in "Name Manager" also you cant make a drop...

I am trying to write a function that takes a cell's value, for example A1 = Sheet1, which is the codename of Sheet1, and return the worksheet name (which appears on the tab). So in Microsoft Excel Objects you have Sheet1 (HelloWorld) In cell A1 is the value Sheet1 In cell A2 I to write a...

Hello, I have changed the "Tab Name" of my worksheet to "Instructions" but in the VB editor the worksheet is referred to as "Sheet3 (Instructions)". I cannot find out how to change the name in the VB editor from "Sheet3" to "Instructions". I'm surprised how frustrated this has made me. Must I...

Awesome thanks man that helped me I have modified it a bit, I got still a little problem. You have declared sheet as Sheet1, the problem is it have to loop through all sheets, I dont make it work with my loop and then combine your code, Here is my code: Sub Langauge_Combination() For...

I have a list of sheet names and a drop down list of those sheet names in a cell. I then want a macro that will take whatever sheet name is selected from the drop down list and select that sheet and create a new copy of it in the current workbook. Probably super simple but I can't seem to...

I have a main worksheet (Test) that I copy each day and I would l would like it to automatically be renamed Test 1, Test 2 and so on when I make a copy. I am really new to VBA and could use some help. Thanks in advance.

Hi guys, So here is my problem. Im looking to make a summary sheet from my workbook highlighting key values from all the different sheets. What i want to do is use a formula to quickly get data from a different sheet that has the same name as the cell in my summary sheet. To explain properly...

How can I replace the sheet name with a passed through named variable? MasterWB.Names("HC_Results").RefersToR1C1 = _ "=OFFSET(Results!R1C1,0,0,COUNTA(Results!C1),COUNTA(Results:Results!R1))" Does't work when I just do this: MasterWB.Names("HC_" & wsR & "").RefersToR1C1 = _...

Dear All, I am using the VLOOKUP formula but want to make it more flexible for the user. I have in cell A2 =VLOOKUP(B2,Jan!A:A,1,FALSE) I am testing to see if the value in B2 appears in column A of another worksheet. The file has a sheet for each month of the year (Jan, Feb, Mar, etc.)...

This is a problem that plagues all my macros, so I'm hoping there's an easy solution. Sheets.Add ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "Sheet1!R1C1:R98C12", Version:=xlPivotTableVersion14).CreatePivotTable _ TableDestination:="Sheet4!R3C1"...

Hi there, I'm having problems with a formula I've found which finds and prints a specific Sheet name from the filename data. It works whenever the file is saved as a spreadsheet (.xlsx or .xls) but not as an Excel template (.xltx). (It displays a #VALUE! error.) I can pull in all the data I...

I have a workbook with multiple sheets. Each sheet has a title (just words in a cell). Is there VBA formula that will have the sheet take the name of the title and also chnage when the title name changes? Thanks

hi allyour help is needed again :)I have excel file which makes a report with vba,after report is done I copy reported data to another excell file sheet, if date of operations in report is march 15 I put it in sheet called 0315, if June 5 - in 0605 and so and so.'my question is if it's possible...

Hi, If I have multiple workbooks open and I want to copy data from only workbook based on the sheet name to another workbook again based on the sheet name, is that possible? The workbook names are variable. For example, if I had 5 workbooks open with file names A,B,C,D,E. In workbook B, there...