I have a workbook with 6 tabs/worksheets. Each of the first four is a different product or quarter. Tab 5 is a consolidated data report that links data from individual tabs 1-4 in rows and columns for comparison purposes. Consider Tabs/Worksheets 1-4 to be quarters (ie. 1Q, 2Q, 3Q, 4Q). What I want is for the Column Headers in Tab 5 (the consolidated data report) to be pulled from the NAME of the Tab/Worksheet it is pulling the data from. Not an individual cell, but the name of the worksheet itself so that others can change their worksheet labels and those changes are reflected in the consolidated report.
I have a workbook with quite a few worksheets, along with a summary page. The summary page has a list of names of all the worksheets in the workbook. I am still learning to use Macro. So far, I have created buttons to hide the individual worksheets (each component is on a worksheet by itself). But I can't figure out how to unhide a specific worksheet from a group of worksheets without creating just as many macros calling specific worksheet names. I don't really want to create 100s of little macros. I am sure there is a better way out there.
Here is a concept of the workbook:
On the summary page, the user supposed to click on a label ("T1000" for example), and this will unhide a worksheet with the same name (T1000). There are hundreds of these worksheets, how does it find
This is my idea of how the function supposed to work.
First determine the label text as a string. Then locate the worksheet with the name equals to the string then set visibility = true.
I have a database sheet with a ticket list which has various columns like business area, ticket number, location, status etc. I am creating a new sheet where i want to highlight only the tickets that are in pending status and I dont want all the columns from the main sheet but just a few. How can I link it so its automatic.
I was trying to develop an excel based calendar schdule for the material dispatches being done from our warehouse. have been able to cook up something using the vba, ingeniously from resources over net and some help from here, but it has not given the desired results. actually the code is not doing anything.
I'm looking to link/embed a summary sheet from one work book to be displayed in another. When i update this summary sheet i wish for it to update the linked work book.
I'm using MS Excel 2003 Pro. I need to link data from one source worksheet to a target worksheet in the same workbook when only one variable changes in the source worksheet e.g.:
A. From source worksheet:
When the data under the "Expected Date" column is set (it normally is blank)
B. Populate target worksheet with:
1. Name 2.aaaa 3.bbbb 4.cccc 5.dddd 6. expected date (the actual date that is set from the source worksheet)
I'm not sure if this is possible. But here it goes. Here is how my spreadsheet stands. I have a sheet called "Dates." When I input a date into a cell it creates a copy of a template and titles it with the date (eg 2009.02.15). What I then need is for some of the cells of this newly created sheet to be linked to cells in other sheets in the workbook. These other sheets serve as databases so to speak and will collect, tabulate and analyze the data from the various sheets created for each day in the Date column. I hope that is clear.
I thought that by creating this Dates sheet I would be able to link the cells in the database sheets to the new sheets that will be created. When I tried this, however, it did not work. The sheets I want to link will have the name of the text that will be entered into the Dates cells. For example. If I put 2009.02.15 in A2 I will want the corresponding cell in my database sheet to have the formula =2009.02.15!C12. Is it possible to make this link before there is text entered in A2 and before the new sheets even are created. I have not been able to do so yet.
I was tryin to think of another way and I came up with this. Here is the code I use to create the new sheets.
Private Sub Worksheet_Change(ByVal Target As Range) Dim wsNew As Worksheet If Target.Cells.Count > 1 Then Exit Sub On Error Resume Next If Not Intersect(Target, Range("A1:A10")) Is Nothing Then Sheets("experiment template").Select Sheets("experiment template").Copy After:=Sheets(Sheets.Count) ActiveWorkbook.Sheets("experiment template (2)").Tab.ColorIndex = 5 Sheets("experiment template (2)").Select Sheets("experiment template (2)").Name = Target.Text End If End Sub
I was thinking it would be easy for this code to link the cells from the new sheet to the existing database. However, I then ran into a problem down the road. For each new sheet created (each new date entered) I want it to enter the values into the subsequent row in the database. Not keep on overwriting the same row. It seems as though there should be code for this but I am not sure how to do it.
I have two userforms with a label which displays CompetitorID. I want to transfer content (displayvalue) from UF1.label to UF2.Label. I know labels don't have a value property but want to simply know if it can be done as presently I'm getting run time error 380, can't set property value.
VB : HeadEntryForm.lbCompID = Me.lbCompID ' trf selected competitor ID to ID field on HeadEntryForm
I have a spreadsheet with a customers information and various parts we make for them. I need to be able to take this information and incorporate it into a label format. I need something quick and easy as there can be 150 parts per customer
A simple one for you, but again my Google skills seem lacking. This must be common practice but until one knows the key combination...
I have created a summary sheet with lots of formulas which analyse other sheets in a workbook. I want to copy this summary sheet to a seperate workbook to use as a template.
Of course, the copying process always links the new (template) sheet to the original workbook it was copied from. How does one copy without forging this link? All I want are the formulas copied across totally unchanged; I really *don't* want to manually edit 50 or so formulas!
I have a userform in Excel and I would like to have a label calculate from the sum of 3 different labels. I have tried a few ways of which none worked.
This is what I currently have. This returns $0.00 in the label value but does not calculate...
Code: Public Sub TotalCACost() If TextBox12.Value > "" Then Label685.Caption = ""
[Code]....
The reason that I have it as a public sub is that I am calling it to Private Sub extBox12_Change() as well as a couple of other textboxes so that when ever TextBox12 or the other textBoxes gets changed, the value will recalculate. The "other textBoxes" change the values of label443, 444, 445, 385, 386, 387 etc..
I created a userform where if a value from cell x is true then the label caption changes to value in cell z. While everything works fine, the label caption does not seem to appear in my userform until i click on the label. Is there anyway that it can appear automatically once the userform opens?
Also example of my code is:
Private Sub EventDateResult_Click () If Range("A5") = "1" Then Me.EventDateResult.Caption = Range("N4") End If End Sub
I'm working for a local authority who have been given a mass of survey data. In this particular task, residents of each small district within our area have been asked their levels of satisfaction with a service, and how important they think that service is. I want to plot these two values against each other using a scatterplot, and label each service.
Excel does not automatically allow this so I used a very good sheet from the forums here: Attach labels with names to the points in a scatter plot. It's the top file, and works well. However, I can't seem to customise it for my own data.
Problems include:
- Excel often freezing when I try to run it - Not all the data being picked up for the chart - Incorrect labels being picked up..........
I have in a cell something like: =B5. Once the value in B5 changes, the value in that cell changes as well. Is it possible to do the same using a label. In other word link a label to a specific cell and have it change along with the other cell.
I am trying to do is have a VBA automatically fill a blank cell with text of a different color.
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("B8") = """" Then Range("B8") = "Name" End If End Sub
Is what I've been trying to get to work. If the value in B8 is suddenly deleted, I want that cell to show "First Name", in a lighter grey. I know I can get the color of the text by using the conditional formatting, but how do I get that cell to auto-fill when deleted?
I want a floating userform (showmodel = false) to display the results of a cell.
On excell spreadsheet I can assign a cell value to an object/shape, as the cell value changes so does the display on the object automatically.
I want the same results on a userform.
I tried the texbox & using the the controlsource from the properties window, this was only good for one result. for the next result the textbox won't change its value.
As i want this for display purpose only can i use the label for the above problem
I have an excel application that I'm developing that is going to be used by two different departments. On one side everything will pretty much be userforms. The sheets they the data I need to pull in for them is on sheets that I have such that their visibilty is equal too xlveryhidden. I'm trying to change the captions on labels using the data on the veryhidden sheets. Something like this.
'frmCurrentProposal is a userform 'lbGroupName and lbGroupNum are both labels that should vary
How do I name my data series in a chart so that the name consist of both a cellreference and my own text? Example: "Name" & Sheet1!A1. If the value in A1 is 2 then the series name shold be Name2
When I am in my workbook and I click on a cell in a worksheet I would like to be able to have the row highlight when I click a cell, instead of trying to manually find it which at times I get lost with all the data on these sheets. Now my workbook is completed and all my formulas are done. Just trying to fine tune my databases with being able to do the "click this cell and the row highlights where I need to be" If this is possible I would like to do this for all 3 databases.
this have bothered me for a long time. I'm not a very good excel user, so it's probably a piece of cake for some here ^^; This table;
Student Test1 Test2 Test3 a 13 b 16 c 19 d 9 e 15
etc...
Later in the document I want to show WHO scored highest on each test in another table;
Best Student Points Test1 19 Test2 Test3
The points are easy to figure out, even for me, just use the "MAX" function. But how do I make excel tell me "c" under "best student"? Ofcourse I want it to be a function so that it'll change when I set 20 on student a.
