Auto Change Cell Data?

Jun 6, 2012

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

View 2 Replies


Auto Change Row Color After Cell Data Input

Jun 4, 2008

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.

View 2 Replies View Related

Auto Color Change With Data Entry

Dec 6, 2008

Is there a way to make a cell change its fill color automatically whenever data is entered into that cell?

View 2 Replies View Related

Auto Change Data Range When Query Is Updated?

Dec 9, 2013

What 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?

View 6 Replies View Related

How To Auto Run Macro On Cell Change

Jan 4, 2012

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:

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


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.

View 7 Replies View Related

Auto Update Macro After Cell Change

Feb 7, 2014

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...

View 5 Replies View Related

VBA Macro To Auto Change Cell Color On Protected Sheet Based On Input

Apr 13, 2009

I have a macro code for conditional formatting. The first 2 lines of the macro are

Private Sub Worksheet_Change(ByVal Target As Range) ....

View 9 Replies View Related

Auto Calculate Color Function On Cell Color Change

Feb 15, 2010

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 Related

Auto Sum Data In First Blank Cell

Aug 4, 2009

I have this code here that is supposed to Auto-sum 3 columns for me...

View 2 Replies View Related

How To Auto Lock Cell After Data Entry

Jul 31, 2012

I 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 Related

Auto Complete And Auto Delete With Data Validation

Jan 7, 2008

Within 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:



View 5 Replies View Related

Auto Populate A Third Cell - Based On Data From Two Columns

Mar 24, 2013

I have data in three columns

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

4.5 13.50

View 2 Replies View Related

Excel 2010 :: Auto Update Cell Data

Nov 1, 2011

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 Related

Input Data In A Cell And Press Enter - Auto Save?

Dec 28, 2011

I 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 Related

Auto Generate Save As Filename From Multiple Cell Data?

Sep 14, 2012

way 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:


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?

View 5 Replies View Related

Click Any Full Cell / Auto-fill Userform With Row Data

Nov 19, 2012

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.

View 1 Replies View Related

Auto Upper+lower Limits When Data Cell Empty

Jan 1, 2009

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
y1Lower = .Cells(i, j + 9)
y1Upper = .Cells(i, j + 10)

View 9 Replies View Related

Auto Day And Date Change

Mar 3, 2014

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.

View 4 Replies View Related

Auto Fill Downwards Until Row Value Change

Sep 3, 2009

Auto fill downwards until row value change

View 3 Replies View Related

Auto Worksheet Name Change

Oct 5, 2009

I 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.

View 9 Replies View Related

Macro - Auto Populate The Data, Based On The Previous Cell Values

Aug 3, 2009

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 Related

When The Data In A Cell Changes, Automatically Take A Record Of This Change Data

Sep 19, 2009

I 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?

View 7 Replies View Related

Should Change Event Be Used To Auto Populate?

May 22, 2012

I am populating column D with


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?

View 1 Replies View Related

Change Color Of Cell Range When Last Cell Receives Data

Apr 3, 2009

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 Related

Macro That Will Auto Color Multiple Cells Based On Data Displayed In One Cell

Jan 7, 2013

I 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).

View 7 Replies View Related

Auto Change Row/font Colour And Move Row

Oct 26, 2009

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.

View 3 Replies View Related

How To Change Auto Correct Words In Certain Columns

Jul 21, 2013

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

View 4 Replies View Related

Change URL With Cell Data?

Dec 15, 2012

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‎

View 1 Replies View Related

Change One Variable When Dragging Down A Column To Auto-complete?

Feb 25, 2013

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?

View 4 Replies View Related

Auto Inserting MS Office Username On Event Change

Jan 24, 2007

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.

View 9 Replies View Related

Copyrights 2005-15, All rights reserved