tab names

Hey there I am creating a template which has a variables set up page. On that page I want to provide the user the ability to enter values into cells which generate tab names. There is a finite number of tabs - so want to have a direct link between a cell reference and a specific tab name...

Hey guys, I'm fairly new to VBA but progressing daily. I usually can dig up solutions to issues with a quick search on here but I haven't seem to come up with a solution to my current problem. Here's the deal: I currently am building an automated financial model; the model creates a new tab...

We have a workbook that saved as into new workbooks. For each workbook we have to take the existing tab name and replace the number in front with correct number. For instance below I recorded a macro to change "10002" to "100005" on all the tabs. Normally this is easy enough to do by hand but...

Hi, i have the following code that work great for one row of data (copy/paste/transpose) but I am trying to tweak it because I know have multiple rows Of data per employee and don't need to transpose it just paste it. What I need to do is lookup the value in the master for the tab name and...

Hello... Novice and new here... I know how to very basically record a macro, but not where or how to insert fixes or work arounds. Macro 1 creates a new data sheet by copying a template tab named "New Data Sheet" for each client as they come aboard, titled "New Data Sheet (2)". Macro 2 runs...

I have a macro that compares two sheets (in a workbook that might contain 10 sheets). Currently, the user enters the names of the two sheets in two input boxes. Is there a way that the user need only to click on a sheet tab and the sheet names are used in the macro? (this would eliminate any...

I found a code to make the tab name equal a cell in the worksheet: Private Sub Worksheet_Change(ByVal Target As Range) Const WS_RANGE As String =...

I am using .::Excel 2010::. How can I use the below information (specifically where "True" exists) to rename my worksheet within my workbook?: With ActiveWorkbook.SlicerCaches("Slicer_COID_NAME") .SlicerItems("Thompson").Selected = True .SlicerItems("Leonard").Selected =...

I have a program that downloads files in .xlsx that come from multiple vehicles. I save the files off manually with a file name that I want to use as my tab name for the purpose of combining the sheets into a workbook for further processing. I use a macro to configure teh sheets already but have...

Hi All - I am creating a macro that loops through a file and reformats each worksheet then cuts and pastes the reformatted data into a Master sheet in another file. Since each file being reformatted has mulitple worksheets with differing tab names and file names I would like to insert the file...

Hi All, Is it possible to reference a workbook name like a formula? For example...Say I have a tab named 'MAY 12' and I am referencing that tab in a YTD tab that I have previously made and I have a column that is pulling all those numbers, but in the sumifs formula I have instead of...

Hi all - below is a loop that cycles through 10 "check" columns in a spreadsheet named "Template", selects the "check" item in the filter for each column, and pastes the results to a new spreadsheet for all 10 checks (10 new worksheets). What's driving me crazy is trying to figure out a way to...