Naming Sheets From Cell Contents

Oct 18, 2006

I have a workbook with a sheet titled Variables. There are 6 additional sheets in the workbook and each sheets needs to be named with the cell contents of A2:A7 in the Variables sheet. I have attached the workbook and you can look at the names in the sheets tabs to see what I'm trying to do here.

The workbook is too large to attach but can be viewed here:
http://www.shuffleupanddeal.org/name_sheets.xls
or
http://www.shuffleupanddeal.org/name_sheets.zip

View 9 Replies


ADVERTISEMENT

Re-Naming Sheets Per Cell Data & Hiding Sheets

Aug 26, 2009

on sheet1 I have a button I need to do the following when clicked:
(1) name the next 30 sheets based on cell values in sheet1
(2) for those 30 sheets, hide some of them based on a y/n input in sheet 1

To clarify: the worksheets do not need to be created, they already exist. They just need to be renamed and hidden based on that y/n criteria. see attachment with just 1 worksheet for clarification. So - The next 30 sheets are to be named by the following ranges (B7:B16), (B21:B30) and (B35:B44). For every product with a "n" in column C of sheet1, the worksheet for that product needs to be hidden.

View 4 Replies View Related

The Naming Of Sheets

Apr 30, 2009

Can a macro be written that will automatically NAME a sheet with the contents of a particular cell?

View 3 Replies View Related

Double Lookup To Retrieve The Contents Of One Cell And Put Into The Main Sheets Cell?

Apr 18, 2013

I get a report each day with a list of issues. the "group" that works the issue and the "priority". Based on these two factors, i need to do a double lookup (vlookup?) to another tab or file to match the priority and group and see what value should be brought back for each lines results. For example, if group1 had a prority3 issue, the lookup would find the value from the other sheet or file and bring back the value and put it at the end of the row where the formula is.

Attached are examples of the sheets.
sheet1.jpg
sheet2.PNG

View 4 Replies View Related

Checking Two Sheets Cell Contents Against Each Other For Duplications

Mar 23, 2009

I have a master sheet that has 3500ish names on it, and another sheet that I'll need to drop in a list of about 1000 names. What I need on the master is a way to check the dropped in data, find duplicated names, and flag them up.

Now, I believe what I did last time was have a true/false method of telling me if they're on both sheets, then use an IF formula to instead make Trues into "yes" and Falses into "no". However, I can't for the life of me figure out how I had it previously checking both sheets and confirming/denying if they're on both sheets or only appear once.

View 2 Replies View Related

Selecting Sheets Without Naming

Apr 22, 2008

If I opened a new workbook so i had sheet1 sheet2 sheet3... Starting at sheet1, how could i move on to sheet2 using VBA without actually naming it....

Is there a selectsheet.next or something?

View 9 Replies View Related

Rename Tabs (Sheets) Based On Cell Contents

Nov 10, 2009

I have 5 sheets. In the first sheet I have set up 4 cells where I want the contents of them to automatically rename the other 4 corresponing sheets.

Eg.
In Sheet 1, Cell B6, I want the contents (which will be text) to be the name of sheet 2 automatically.

In Sheet 1, Cell B7, I want the contents (which will be text) to be the name of sheet 3 automatically.

View 8 Replies View Related

Naming Chart Sheets Specifically

Jan 3, 2009

I want my charts to be located in a new sheet each. I also need their names to start with "GR-Chart[number here]". So they should be GR-Chart1, GR-Chart2, GR-Chart3,......

ActiveChart.Location Where:=xlLocationAsNewSheet, Name:= "GR-Chart" & [this part I got wrong]

Do I use i? or .Count?

View 9 Replies View Related

Naming Sheets With Time-dependent Prefix

Apr 21, 2009

I have got this macro working OK but now I need to add a 2 letter prefix/suffix depending on what time it was created (am or pm). Detail: If the sheet is created between 0600hrs and 1800hrs then "DS" and likewise between 1800hrs and 0600hrs then "NS". Outcome: The sheet will then have a name like - "22 Mar DS"...code included below

View 4 Replies View Related

Naming The Sheets Based On List On Column A.

May 5, 2006

I have a huge db that has a column "C" with a list of names. I have been creating tabs and naming them according to that list. I wonder if there is anyway I can create and name the tabs automatically. I already searched for threads in the forum, but only found this this backwards "tabs to cells". By the way, the names in column "C" sometimes repeat.

View 2 Replies View Related

Select Mulitple Sheets Without Naming Each Sheet

May 14, 2006

Im sure there is a post somewhere on this forum as I have seen it before but I cant find it anywhere. All I want to do is be able to select Sheets Sun,Mon,Tue,Wed,Thu,Fri,Sat without naming each of the sheets. The post I seen would select all the sheets between the two sheets that were stated in the vba code. something like: Sheets( Array("Sun" To "Sat").select

View 5 Replies View Related

Excel 2013 :: Auto Naming Pivot Sheets

Feb 28, 2014

Is there a macro available which will create a pre-defined name for a pivot sheet, which will contain the word "Pivot" followed by a underscore "_" and the name of the sheet on which the pivot is applied.

Example: I have data on a sheet called "Salary" and put a pivot on "Salary" on a new sheet, the new sheet should be auto named as "Pivot_Salary"

Am using Excel 2013

View 1 Replies View Related

Adding & Naming Sheets "X" No Of Sheets Dynamically

Oct 28, 2009

I have an Index Sheet where I would be typing the name of the Sheet and a Command button to execute the operation of Adding the Sheet with the name mentioned in the Column C..

View 14 Replies View Related

Compare Cell Contents With Given Range Of Contents

Dec 30, 2013

I have attached a workbook stating my problem.

file1.xlsx‎

View 10 Replies View Related

Compile Sheets Contents

Oct 6, 2008

Have tried a few things but can't get it to work properly. I have attached the file I am working with because it is much easier to understand if you just look at it!

Basically, I have a single sheet with three columns:

Name, Post Code, Tenant

There are varying instances of 'Name' and each one has a different 'Tenant'.

What I need to do is merge the contents of the Tenants cells so that for each different 'Name' there is only 1 instance and then for Tenants all the different cells are merged i.e. "Tenant 1, Tenant2, Tenant3...etc"

I hope this makes sense, as I mentioned above it will be a lot clearer if you have a quick look at the attached spreadsheet.

View 14 Replies View Related

Table Of Contents For Hidden Sheets

Jan 3, 2012

I have to review work papers with 50+ sheets. The users often hide the sheets they do not use. As part of my review I have to review all sheets, even the hidden ones.

What I would like to achieve:

To create a list of all hidden sheets with hyperlinks so I can go directly to the hidden sheet. This would be the same as a table of contents but for hidden sheets.

View 4 Replies View Related

Clear Contents Multiple Sheets

Dec 12, 2006

I have the following code for about 20 sheets

Sheets("Multi CT 43").Select
Cells.ClearContents
Range("A1").Select
Sheets("Multi CT 61").Select
Cells.ClearContents
Range("A1").Select
Sheets("Multi CT 80").Select
Cells.ClearContents
Range("A1").Select

i'm sure there is a more simple way of doing this but I can't find a way that works.

View 9 Replies View Related

Incorporate Adjacent Cell In Formula W/o Naming Cell Address?

Oct 2, 2009

I searched and I keep finding something that's not quite what I'm looking to do so I think I'm missing something really simple.

Let's say that I want each cell in col b to be the sum of 5 plus whatever value is in the cell adjacent to it on the left (col).

I know that you can just write a formula in each cell like...

b1 will be =sum(a1+5)
b2 will be =sum(a2+5)

... but is there a shortcut so that you don't have to write out the actual cell address for each one?

Meaning - is there a predefined name or something that represents the cell to the left or right so you can just use that instead, allowing you to just copy paste the same formula all the way down the column? Something like...

b1 will be =sum(left+5)
b2 will be =sum(left+5)

... where "left" represents whatever value is in the cell to the left of that particular cell?

View 9 Replies View Related

Return Contents Of 1 Cell Based On Contents Of Another Cell?

Mar 12, 2014

I thought this was a pretty simple formula but I am having difficulty creating it. I am attaching a little test spreadsheet. Sheet 1 is where the data will be entered. The Reimbursed column has a drop down choice of yes or no. The next 2 columns are the cost of registration and the cost of accommodations. On sheet 2 is where I would like the formulas. So in cell A4 I would like a formula that says if B3 on sheet 1 is Yes populate this cell with the contents of Cell C3 only, B4 of sheet 2 would then be B3 if A3 on sheet 3 is Yes and so on with the Not reinbursed if sheet 1 the Reimbursed column is no.

View 3 Replies View Related

Naming Tab Based On A Cell?

Nov 1, 2012

Is there a way to name a tab based on information in a cell on that tab?

View 2 Replies View Related

Clear Contents Of 2 Ranges On Multiple Sheets

Mar 29, 2012

I need to clear the the text in the same cell ranges on multiple worksheets. on a regular basis.

F7:K13
Q7:Q13

Is there a simple way to do this?

View 7 Replies View Related

Add And Name Sheets Based On Range Contents From Different Sheet

Mar 13, 2013

I've got a spreadsheet with a 'data' sheet and I want to add and name additional sheets based on the contents of a range in the 'data' sheet - it could be 1 extra sheet, it could be 100, the range is open ended.

View 3 Replies View Related

Naming Worksheet After Cell Values

Mar 8, 2009

I was trying to rename the worksheet. using a cell value,A1. For example , if the cell value is Earning, the worksheet will be named as Earning.

However I would like to include the location before the name, Earning.
For example, in the cell value,A2 TK. I would like to rename the worksheet as TK_Earnings.

So the name of the sheet will be CellvalueA1_CellvalueA2.

View 3 Replies View Related

Link Cells In Adjoining Sheets If Contents Match

Apr 21, 2009

I have a list of items in column A of Sheet1 and the same list in column A of Sheet2. Both list will contain the same items, however not necessarily in the same order.

What I want the book to do is; when I click on an item in the list on Sheet1, it takes me to the same item in Sheet2.

Is this possible with VBA?

View 10 Replies View Related

Table Of Contents - Drawing Info From Various Cells On Different Sheets

Jul 29, 2009

I have a "Generate Table of Contents" button that launches a macro. This macro builds the Table of Contents, creates (3) columns (Patient Name, Date of Pickup, and Frequency), finds all of the sheets in the work book (already renamed to a patient's name), sorts them alphabetically, and lists them under the Patient Name column.

This code works great - The next challenge:

On each sheet (which corresponds to a patient in the database), there is a cell that is filled in that states which day the patient picks up their medication. There is another cell that designates how often they come to pick it up.

I am at a loss as to how to direct the macro to: For each sheet, go to the specific cell, and then report it in the table of contents.

It somehow needs to bind the information together... meaning the patient name, date of pickup, and frequency must be displayed correctly each and every time on the same row.

View 4 Replies View Related

Copying Array Contents Into Cells. Gathering Data From Sheets And Compiling Into 1.

Aug 11, 2009

I've been given the task of automating a spreadsheet to assess whether work has been done by each employee. Every employee has their own spreadsheet, where column A is a job code, and column H contains either y or n dentoting whether they have completed the task (y) or not (n).

The main spreadsheet is designed to show any outstadning tasks across everybody so it has a list of everybodies names in column A and then any incomplete tasks will be listed from columns b onwards next to the appropriate person. Here is what I have done at the moment.

View 3 Replies View Related

Copy Cell Contents Between Tabs Provided Cell References Match (VLOOKUP)

Apr 29, 2014

I have 2 inventory reports: what my store has and what my supplier has. I need to copy Tab1:K# to Tab2:T# provided that Tab1:A#'s contents match Tab2:A#'s contents. The A column represents the SKU of the item, but there is a difference in the amount of SKU's in each (my store sells ~6,000 items, supplier has ~10,000 items), so it's not as simple as sort by column A and copy pasting column K to column T.

For instance:
On Tab 1, A2's value is [1], K2's value is [9.38].
On Tab 2, A70's value is [1], K70's value is blank, but I need it to be [9.38], to match Tab 1's respective SKU.

I almost thought I had it figured out with VLOOKUP, but I cant seem to get it right... It doesn't reference the correct number.

Screenshots for reference

First tab, from the wholesaler: [URL]
Second tab, store's stock: [URL]

View 2 Replies View Related

Workaround For Public Variable Bug: Creates Different Cell Colors Based Upon The Cell Contents

Oct 15, 2008

I am in the process of reformatting an excel workbook to act as a review tool for different factors in a process. Part of my redesign includes the use of coding that creates different cell colors based upon the cell contents. The new workbooks will be used to handle existing data for this year. I have developed a process macro to open an existing workbook and copy and transfer the original data worksheet into the newly formatted workbook. The data gets transferred to the new worksheet and the resulting workbook is renamed and saved, Heres'' the rub... the newly saved workbook is missing all of the coding for the worksheets... apparently this is a MS bug.

Has anyone figured a workaround for this. One thought I had is to open both( new and old )workbooks and rather than move/copy , i would transfer the data using cell references.

View 5 Replies View Related

Macro That Will Clear Contents Of Cell Based On Format Of Text In Adjacent Cell

Feb 18, 2009

Been racking brain, searching through the forum here, and my Excel 2003 Bible all day trying to figure out this problem to no avail. I would like to clear the contents of any cell in a given range if the cell immediately to the right of is formatted as bold.

View 2 Replies View Related

Excel 2010 :: Cell Summing Through Referencing Neighbor Cell Contents?

Feb 12, 2014

we have a Excel 2010 worksheet containing multiple tables.

Table1
ColumnA ColumnB
1 Blue 12
2 Orange 14
15
11
3 Red 10

Table2
ColumnA ColumnB
1 Blue 11
2 Black 13
15
11
3 White 10
19
17

On a separate worksheet we want to calculate with the first worksheet's values.

For example: Calc1: Sum ColumnB IN Table1 WHERE ColumnA = Orange

How do we do such a calculation/formula?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved