I need to know how to do the following;
When someone clicks on a specific cell, I want a different cell to then fill with data from another worksheet, can this be done?
For example, I have cells on a speadsheet box 1, box 2 and box 3. What I want, is when someone clicks on say box 2 to selects that option, then I want box 4 to auto-fill with the price I have from another spreadsheet
Not sure if this is possible or if I would need to run a VB macro. image multiple columns with text headers.
'A'=Project Number 'B'= Date 'C'=Description etc etc etc 'S'=Cancelled (i actually use up to 'Z' on the columns for various other data)
I have added a Conditional Format on the cells in column 'S' that if the cell data = Y then colour the cell RED. This at first glance will show that the project has been cancelled. What I would like it to do is to colour the complete row (shaded grey for example) this would then show up more easily with the amount of data that is on my sheet.
Is there a way to make a cell change its fill color automatically whenever data is entered into that cell?
View 2 Replies View RelatedWhat I have is a database of measurements taken, where X-axis is distance across a surface and Y-axis is measuring deformation to that surface. Each measurement is actually a group of data points from one sweep across the surface on a certain day, resulting in a line plot for that group. What I'm trying to do is create a "checksheet" so that you can overlay plots from multiple dates on the same grid to compare how the surface has changed with each measurement. I've got the checksheet part working properly, and I can toggle things on/off as I like as long as my data doesn't change.
The rub is that this data is gathered via query, and each measurement doesn't have the same # of data points. If I update the query to look at a different date range, the plots are now off because the old data range doesn't match the new data.
Is there any way of changing the data range when a query gets updated, or a way to tie it to a function?
I'm trying to automatically change the names of the sheets in my workbook based on the contents of cell A1 in each sheet.
I found some code on some website and inserted it into the ThisWorksheet module:
Code:
Private Sub Workbook_Open()
Dim wSheet As Worksheet
On Error Resume Next
For Each wSheet In Me.Worksheets
if wSheet.Name = "SomeName" then
If wSheet.Range("A1") = "" Then
wSheet.Name = "Sheet" & wSheet.Index
[code].....
This code appears to work properly, but only when the workbook is closed and then reopened. Is there a way to make this code run anytime cell A1 in any of the sheets changes? I've found several sample codes that purport to make a macro run automatically on a cell change, but I can't figure out how to incorporate the code above with the Worksheet_Change code to make them work together.
Trying to get this macro to auto-run after the referenced cell is changed:
Sub Headerdata()
ActiveSheet.PageSetup.RightHeader = Range ("d1").Value & Range ("e1").Value
End Sub
I got it to work in one book but it won't work in any other book...
I have a macro code for conditional formatting. The first 2 lines of the macro are
Private Sub Worksheet_Change(ByVal Target As Range) ....
I would like to be able to change the color of a cell in V4:AB31 and have the formula in AM10:AM13 automatically calculate the new result. As it is now the user has to press Ctrl ALT f9 for the formula to recalculate.
View 7 Replies View RelatedI have this code here that is supposed to Auto-sum 3 columns for me...
View 2 Replies View RelatedI am attaching the example where I need to lock H2 to H1000, note that sheet is locked "anixter12 and I have also given range to user for modification I simply want to lock cells in H once date is entered.
View 3 Replies View RelatedWithin a data validation selection, are you able to do both Auto Complete and Auto Delete? I have this posted at another forum [url]but have not been able to find a solution (a copy of the file, test. zip is there as well). I am not sure it is possible, or, at least I have been unable to get it working. I can do each, but not both.
I have also been utilizing:
[url]
[url]
I have data in three columns
A B C
4.5 9.50 4.657
4.5 11.60 4.789
4.5 12.50 4.654
4.5 13.50 3.930
4.5 15.20 3.826
I need to be able to auto-populate the cell in column G based on values in columns A & B. If I type 4.5 in E2, and 13.50 in F2, G2 should auto-populate with the value from column C
E F G
4.5 13.50
I would like make a cell in a report auto update with the most recent data entered in another cell from an input table either in the form of a formula or code to ensure that the most recent data is recorded and reported.
View 3 Replies View RelatedI have a excel sheet in it. Is it possible? That when in any cell I input data in a cell and press "enter" then it save automatically.
View 8 Replies View Relatedway for my engineers to save a field ticket with a certain name based on data from a couple of cells in the worksheet. Re: Auto generate "Save As" filename from text and tried to use some code posted in the thread, but I an still not having any luck.
What I want to do is create an active X button when clicked on, would save the workbook to a certain folder. I want the name to look like this:
SO1!M3_SO1!M6_SO1!H2.xls
This is what I have so far:
Private Sub SaveMe()
ThisWorkbook.SaveAs Filename:="C:usersdefaultdesktop" & Range("SO1!M3").Value & Format(Range("SO1!M3").Value, "text") & ".xls"
End Sub
Would I click "general" or "workbook" in VBA when I enter this code?
I have a userform [AddEditMove] with a bunch of textboxes (something like 30) that create entries in a spreadsheet ["Move Records"] along one row. In addition to creating those basic entries, the textboxes also fill in other spreadsheets after manipulating the entered data in various ways.
Therefore, if an entry needs to be changed, it needs to be changed from the userform rather than just on the main sheet, or those other actions won't be taken. At least, that's how I see it now. I'm interested in knowing how other people have handled similar set ups.
Right now, what I think I'd like is for the user to be able to double click any entry on the main sheet and have that action call up the userform and autofill the data from the sheet so the user can change what they need to change and then update it. It would also require a tweak in the userform code -- "if called from cell click, then fill info in selected row, rather than next empty line" -- if that's possible.
I have a table that I use to generate about 20 graphs. The lower and upper limits can be manually altered in the table. If the user leave those 2 cells empty, I want the upper and lower limits be determined by default by Excel. So that the limits don't have to be entered for every graph in order for the graphs to be generated without any debugging error.
With ActiveChart.Axes(xlValue)
.MinimumScale = y1Lower
.MaximumScale = y1Upper
.MinorUnitIsAuto = True
.MajorUnitIsAuto = True
.Crosses = xlAutomatic
.ReversePlotOrder = False
.ScaleType = xlLinear
.DisplayUnit = xlNone
End With
where
y1Lower = .Cells(i, j + 9)
y1Upper = .Cells(i, j + 10)
I would like to be able to input the Day and date in coloumn A and have the rest change accordingly
I wish to have it displayed as follows Monday 03/03/2014 followed by coloumn 2....Tuesday 04/03/2014.
There are 4 cells for each day set that have been "Merged and Centred". (B2,C2,D2,E2) display "Monday 03/03/2014" , F2 is a split , (G2,H2,I2,J2) display "Tuesday 04/03/2014" and so on.
I can make the dates change according to the first input but since i must also display the day as well.
Auto fill downwards until row value change
View 3 Replies View RelatedI want to try and rename a worksheet tab according to the value in a cell.
I have a worksheet with a column of cells each having list boxes, i want the following to change. If i select a value from the list box in worksheet 2 cell A2 it should change the worksheet 3 tab name to equeal the list box value.
And so on, If i select a value from the list box in worksheet 2 cell A3 it should change the worksheet 4 tab name to equeal the list box value.
the post 5 for the actual issue. This being my first post could not update it correctly. I have put my views int he 5th post which will be more clear.
View 9 Replies View RelatedI am not sure how to go about creating a spreadsheet that does this:
I have a number much like a stock market index which is in cell A1 for instance, and this data changes every second,
And I wish to create my spreadsheet to automatically make a record of this change value and populate it at the last available blank row, so ultimately, I have a full history of how this number changes during the course of time.
5450 in cell A1
a second later, it changes to 5430
and so I want to populate 5430 to A2
and then another second, it changes from 5430 to 5470 and so i want to populate 5470 to A3 and so forth....
does anyone know how to do it?
I am populating column D with
=IF($C2="","",VLOOKUP($C2,Name_ID,2,FALSE))
Based on selection in column C populated using a drop down list from a range titled PracticeID. Other named ranges, all on sheet titled Validation, are PracticeName and Name_ID (a 2 column range made up of PracticeName and PracticeID). This works great the first time a selection is made in column C. But, of course, if the user needs to change the selection in column C, the value in column D does not change. Would the cell change event be the appropriate place to place this action?
I need my worksheet to automatically fill in a range of cells (from Range B*:G*) with my yellow color once the last cell in the range (G*) receives data, and automatically switch back to no color if the data in Cell G* is erased. However, if somebody merges a range, it should appear as it would by default - as if no macro exists, if that makes sense. I've attached a sample worksheet.
View 2 Replies View RelatedI am trying to find a way to write a Macro that will auto color multiple cells based on what data is displayed in one cell. The cell I want to reference is a vlookup cell.
Basically this is a part label. And depending what part is selected from the list my vlookup will display its position on a vehicle(i.e.. FR, FL, RR, RL, Etc..). So if vlookup comes back with FR I want the various cells on the label to be orange, etc..
ALSO: if there is a way to embed it so it does this automatically (rather than run the macro each time).
Attached example sheet. Basic table of data, with column F being a validation list, is it possible that when choosing COMPLETE from the list, the row and font change colour, and then move to the top of the list?
I'm not the only simpleton using the sheet so I need it to be as simple as possible. I know it doesnt seem like a big thing but the sheet we are working from is huge and I dont want people cutting and pasting away, I just dont trust them with my spreadsheets.
For example, on column X, if I type 20, bob or bobafett it type 2.0 instead but on column I if I type bob, it will type 3.0
they would all be edited manually
or even better, no matter where I type it on excel, it would go in the right column, like bob X, then it would change to 2.0 and go directly in the X column
1. I would like to get the zipwho information for a specific zip code in cell H to be inserted into this [URL] .... The sample zip code is 33134 gathered from cell H. and would like to generate a link in BA
2. I would like an addressed gathered from Cell AW, to be plugged into google maps, with the words Realtor nearby: "2991 Simpson Dr, Bartow, 33830" (like this [URL] .....) the sample address is gathered from cell AW and I would like generate a link in cell BA.
There is a sample spreadsheet attached : 121212_ELANCE_USDA_FINAL.xlsm
How do you drag down a column to auto complete the values but do it so it only changes one variable.For example, I am dragging down =IF(ROW()<=$B$5,MOD(E2*B1,B2),"") down my column.
However, I only want the "E2" value to change, and I want B1 and B2 to stay that way. Whenever I drag down, it keeps changing all three values. Is there a way to make it just so that the E2 value is the only one that changes?
I have a shared spreadsheet that uses a column with a validation list. I want to be able to take the MS Office Username contained in Tools > Options to be put into a cell A1 when changing the value of A2.