Cell Values Change Randomly
Aug 14, 2014
I created a multipage spreadsheet to track stocks. Two pages import quotes from Microsoft automatically about every 10 minutes. The main page organizes these stock quotes next to the symbols. Stock price, $ change, then % price change.
For example, for symbol INTC,
PRICE cell is =Quotes!D120.
$ change is =Quotes!J120
% change is =Quotes!I120
Now all of a sudden, during a random refresh, EXCEL IS CHANGING THE VALUES from D120 to AB120. J120 to AG120. I120 to AH120. That was after fixing it earlier today. Earlier today it randomly changed those values to something else. Like A, T, and V substitutes for the proper fields. This is happening to about 10 stocks in a row, but I think I saw it on a couple others earlier. It is as if someone is changing these fields (but they aren't!) The fields on the pages being pulled from are staying the same.
Using Office (Excel) XP on a Windows 7 PRO 64-bit OS.
View 1 Replies
ADVERTISEMENT
Jun 29, 2014
I am trying to make a macro that when clicked, will randomly choose one of 7 values and type that into cell C4. Values can be Dodgeball, Football, Soccer, Tetherball, Soccer, Baseball, Basketball. Is this doable?
View 9 Replies
View Related
Oct 14, 2008
I need a cell to display the (text) content of 1 of 25 cells. example: I have text content in all cells ranging A1:A25. I want cell B1 to display the content of 1 of these at random. is there a function for this or do I need to use a macro?
View 4 Replies
View Related
Feb 15, 2013
The macro below will randomly pick a cell (with names)and fill with color. What I want to add is after it pick a cell a msgbox with a name of that person with YES/NO, if YES fill color. I need it not duplicate once it has already selected that cell(person).
Code:
Function RandCell(Rg As Range) As Range
Set RandCell = Rg.Cells(Int(Rnd * Rg.Cells.Count) + 1)
End Function
[Code]....
View 9 Replies
View Related
Oct 31, 2013
I am trying to randomly select 10 data from a table by using index formula. But there are some blank cell in the table so It kept returning 0 in the cell.
problem.xlsx
View 2 Replies
View Related
Jan 19, 2014
I am trying to highlight a cell based on two randomly generated number, one is the column and the other is the row. Based on those values I want to change the color of a cell in a range of data. The formula I am using does not work like I intended. It only changes the cell once I enter a value in the cell not until. =OFFSET(A1,B27,B26). B26 and B27 are the cells housing the random numbers and A1 is the base reference.
View 1 Replies
View Related
Jun 6, 2014
Cells B3 and B6 both have lists created through data validation.
If the value in B3 changes (by user selecting from the list), I'd like B6 to automatically change to "Select a take to retrieve" (which is the first choice in the B6 list.)
Likewise, if the value in B6 changes (by user selecting from the list), I'd like B3 to automatically change to "Select a version to take" (which is the first choice in the B3 list.)
View 1 Replies
View Related
Nov 10, 2012
I need to write a condition in such a way that cell IF A1= "DBR","BPR","SLR","SKR" then change cell B1 to SPECIFIC COLOUR Each condition different colour. A1 values ("DBR","BPR","SLR","SKR") is a list of selectable values. if the condition is falls then B1 should be normal (white color cell) with 0 in it.
View 1 Replies
View Related
Sep 9, 2009
In column A I have a unique number.
In Columns B,C,D,E F and G I have various data
What I would like is to select a Number from Column A and the Row that contains that number Columns B,C,D,E F and G I want to change these Cell Value to 0
For example
Unique number in Column A is 1052
This appears in Cell A452
The cells Values of B452,C452.D452,E452 Etc to G452 change to 0
View 9 Replies
View Related
Nov 12, 2009
Change Cell if One of Multiple Values (VBA)
I believe my code if pretty self explanatory:
View 6 Replies
View Related
Oct 6, 2009
I have 2 lists.
I want to rank scores/ratings in list 2 and rank against all those cells that have the same value.
I will upload an example.
In the example you will see column A and column B.
I need a Rank for all those cells in B for 17:45, 18:15, 18:45 etc.
View 9 Replies
View Related
Aug 30, 2006
I have a column of values that I want to convert.
The are all generally along the same lines as the below example:
Values is 500000 I want to change it to 5000.00
does anyone have any idea how I can put in a decimal point to two digits before the end of the value.
View 6 Replies
View Related
Jun 12, 2013
I would like to have the cell color changed according to what value is chosen from a drop down menu. I guess you need to make some kind of rule with conditional formatting ...
View 14 Replies
View Related
May 8, 2007
myColumnOne = Range("NPN").Column 'this is column B, NPN is a Named Range of B1
myColumnTwo = Range("NPCH").Column 'this is column E, NPCH is a Named Range of E1
using these variables I want to say
When data is entered into any cell in myColumnOne
first check to see if this same data already exists in myColumnOne
if it does then check to see if in the row where the data already exists, if the corresponding cell in myColumnTwo ISBLANK then MsgBox
if the corresponding cell in myColumnTwo is not blank, allow the data to be entered.
Example:
Col B….Col E
ABC…..xxx
XZY….........
View 11 Replies
View Related
Jan 8, 2009
Good afternoon Gentlemen, I have a column of data, with a varying number of percentage values that add up to 100%, separated by "NA", i.e.
33%
33%
33%
NA
25%
25%
25%
25%
NA
100%
NA
20%
20%
20%
20%
20%
NA
Now... when I change one of the values I would like the others to even up, i.e. in the last example if I change a 20% to 50% I would like the others to change to 10%... any ideas?
View 11 Replies
View Related
May 19, 2009
I need some code to use text boxes to change the data in certain cells. Basically I want 3 text boxes to appear one after another. The first box should add text to cell T1, then 2nd to cell T2 and the 3rd will add text to cell T3. All these values should be added at numbers.
View 2 Replies
View Related
Jun 19, 2009
I know this can be done, as I have seen it before, but can't seem to figure out how to replicate it.
I have a speadsheet in which I have a drop-down box for a certain column's values. How do I automatically have each independent row's background color change dependant upon the value selected in that row's drop-down cell box (and update color automatically if a different drop-down selection is made later)?
For example:
Row 1: Cell C Drop-Down Value = "Yes"...change row color to GREEN
Row 2: Cell C Drop-Down Value = "No"...change row color to RED
Row 3: Cell C Drop-Down Value = "Maybe"...change row color to YELLOW
View 9 Replies
View Related
Jul 6, 2009
I receive real time data ( Last Trade Price ) of soybean commodity futures through DDE in to excel ( cell A1 ). During market hours A1 will keep updating every milliseconds or seconds.
My cell B1 ( =A1 ) will have same value as A1 and will update at the same time.
What I'm looking for - A macro code so Whenever value in B1 is between 9.5000 and 9.5050, I want run a subroutine ( similar to calling a macro ). Since B1 would change dynamically so everytime B1 comes between range 9.5000 and 9.5050 a subroutine is fired.
I'm planning to CALL following subroutine -
Sub BuyBeanst()
Range("N9").Activate
ActiveCell.Value = "Y"
Range("T10").Activate
ActiveCell.Value = "Y"
Range("T11").Activate
ActiveCell.Value = "Y"
End Sub
View 9 Replies
View Related
Jul 18, 2006
My question is i want a cell to have the colours:
Green=if within the max min range [as specified by user]
Amber=if the current value is less than the allowable slack level[again specified]
red=if the current value is less than or more than the min or max respectively.
View 4 Replies
View Related
May 5, 2014
I would like to have a cell (A2) with "H" in it. then have another cell with something like =A2&"2" which would equal H2 and actually reference cell H2?
View 1 Replies
View Related
Jun 3, 2008
I am trying to do is to write a code that will change the values of cells B17:B25 to "false" when the user selects "true" from the drop-down box in cell B16.
Here 's my
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "B16" Then
If Target.Value = "TRUE" Then
Range("B17:B25").FormulaR1C1 = "FALSE"
End If
End If
End Sub
This is not working! Nothing happens when I select "TRUE" in cell B16!
View 9 Replies
View Related
Nov 22, 2007
I want to change the colour of a cell depending on its value, when compared to another row of data identiified by a value in another cell. To try an clarify:
b3 = 1 b5=4 Because b3 = 1 then compare cell b5 with the row g1 as b3=g1 then depending on its postion set a colour
g1= 1 g2:g5 = 2,3,4,5,6
h2= 2 h2:h5 = 7,8,9,10
View 2 Replies
View Related
Oct 2, 2011
How to change the background cell color based on value ranges(s)
I tried conditional formatting but it works between two values only, in my assignment I want to show:
River levels in relation to flood class
>=2m =2.6 =3m major flood (background turns red)
I hope it is possible in Office 2007
View 9 Replies
View Related
Jan 29, 2010
I want to drag a formula however i want one of the values of the formula to change and the other not to change. for example:
c1=a1+b1
c2=a1+b2
c3= a1+b3
: : :
how can i make it do this when i drag? a1 is not just a constant and it depends on other parameters.
View 3 Replies
View Related
Aug 13, 2012
I'm coding a userform where there are some comboxes which are popolated by values coming from Sheet2. Up to now I work it out (maybe its not elegant but it works).
Now I would like that when the user selects one combobox the values of the other comboboxes are set accordingly to the grid in Sheet2.
Please download the XLS file at: [URL]....
View 2 Replies
View Related
Feb 23, 2012
I have made a calendar in excel, and need to make the following work.
I have six boxes (each for one day of the week, excl. Sunday) and a separate box containing names. I need to come up with a way that excel will automatically add those names to any five of the six boxes at random (always leaving exactly one box free for each name), and always choose which box at random.
View 1 Replies
View Related
Dec 10, 2013
In sheet1 columnA I have some data from that i want to copy randomly 50 rows to sheet2.
View 14 Replies
View Related
Sep 18, 2008
Basically I have 2 columns:
column 1 is numbers 1,2,3
column 2 is letters a,b,c etc
I'd like a macro that randomly matches column 1 and 2
e.g
1 c
2 p
3 n
but i'd like it so that the number 5 always returns z
View 3 Replies
View Related
Apr 11, 2008
I have a workbook with sheet 1 called Support which is basically an input form. The second sheet is called Database.
I want to enter data into the form and via a macro copy the data to the database. I have followed a text book to the letter on how this is to be completed to the letter.
My problem is that when the data is written to the database some of the fields are blank. Using F8 I can step through the VB script which appears to select fields at random.
View 10 Replies
View Related
Feb 9, 2007
Is there a function in Excel that would randomly select one of the 4 specified numbers?
View 13 Replies
View Related
