I created a small block of cells on my worksheet where i have in separate cells, the day of the week, the days date and the month. I want to design a special memory calendar for my mom in early stages alzheimers.
There are cells with specific info which i do not want to re type for the whole month/year.
I want to be able to copy all the info into another block of cells and have the day of the week and date change also the month.
I am trying to find the frequency of lottery numbers that occur within 10-day periods (see row 7). Instead of having to manually write each formula for each column, is there a way I can automate it, so that each column will "advance" 10 days?
Excel 2010
A
B
C
D
E
F
G
H
I
J
K
1
ct
0
1
2
3
4
5
6
7
8
9
[Code] .........
Array FormulasCell
Formula
B8:B17
{=FREQUENCY(B3:HNR3,ball)}
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself
Worksheet Defined NamesName
Refers To
'am (2)'!ball
='am (2)'!$A$8:$A$17
I'm looking for vba code to use that will incrementally rotate an image based on values entered within a cell of an Excel spreadsheet.
I have two graphics, one is the face of a dial and the other is the pointer very much like a speedometer. I can achieve the desired outcome using two excel charts, one overlaid on top of the other, but, this doesn't give me the visual effect I'm looking for.
I'm using the face of the semicircle dial as the background image and I have a separate image for the pointer. When a value between 1 and 100 is entered in cell O3 i would like the pointer to rotate to that position on the dial. The pointer is to have a fixed position and arc left to right where the value of 1 is left-most and horizontally aligned, and for the value 100 the pointer would point in the opposite direction.
What I’m trying to do is based on a character level in cell “G1” I’m looking for “Z1” to show the experience need for the next level. For example:
Level=Experience
1=0
2=1000
3=3000
4=6000
5=10000
6=15000
7=21000
8=28000
9=36000
10=45000
11=etc…
Experience is calculated by 1000 x Previous Level + Previous Experience.
In this above, to reach fifth level experience is calculated as (4*1000+6000).
I know this can be done with a formula, but can a macro or VBA compute this also? For example:
If G1 indicates that a character is at level 5, I want Z1 to show the experience need for level 6. This means I need code to calculate experience from level 1 to level 6 like this:
IF(LEVEL>1,((1*1000+0)+(2*1000+CURRENT EXPERIENCE)+(3*1000+ CURRENT EXPERIENCE)+(4*1000+CURRENT EXPERIENCE)+(5*1000+CURRENT EXPERIENCE)),0) RESULT=15000 for LEVEL=6
That’s the formula equivalent of what I’m looking for code to do. Can this be done?
I have a test due in the morning, and I really need this question answered ASAP, if anyone could. I need to create an IF formula for this situation: the standard Mhz is 500. Give 55.00 for that standard. But for every increase of of Mhz, give 25.00 per 100 increase.
View 2 Replies View RelatedI have a worksheet where over time I add columns that need to be added in a "Total" cell.
=M3+W3+AG3+AQ3+BA3+BK3+BU3+CE3+CO3+CY3
Above example, the cell being added is 10 columns after the previous one.
Question:
What formula can I use to automatically pull the value from every 10th cell starting with M3?
Preferably every 10th cell till a value I determine... i.e every 10th cell but only for the first 15 occurrences.
(Is this anything to do with the Series command?)
I have what is probably a simple request to all the VBA experts out there, and simply want to take a template sheet in a workbook and copy it across to 100 sheets numbered/named 101 -200, and add the name of each sheet as a text reference, e.g. sheet name 101 will have a cell within the worksheet that refers to sheet 101.
I have attached a simplified spreadsheet which indicates what i'm trying to achieve.
I would like to fill in a a form on page /sheet one and have the same info on every sheet that follows is it possible?
View 3 Replies View RelatedI have attached a spreadsheet and I am trying to capture the info in lines 2,7,12,17 and return the info into column d,e,f,g
The info in these columns at present has been manually entered but I am sure it could be automated.
OOL Roster Final 18-31Aug14.xlsx
if it is possible to increase one cell by 1 when the date was changed in another cell. I installed the code that was given to me and it worked perfectly, thanks agin JB and royuk, UNTIL the cell that was to increase by 1 was locked and the sheet protected.
The date cell is not locked.
I need to increase the cell value on a spreadshhet that contains over 50,000 cells. I know how to do this on a cell by cell basis. I need to know if there is some way of doing this to multiple cells. Here is my example;
$603
$712
$649
I need to increase each cell value and roundup to the next number. I have been doing the following formula: =ROUNDUP(603/.97,0) to increase the cell value to $622.
If a cell is not blank, then increase that amount by a percentage identified in another cell and display the value only without any formalas in a new cell. To this end I wrote this IF statement:
=IF(I2>0,CP9=(CA9*I2/100)+CA9,CP9="")
Observation: I see a FALSE in CS9 where this IF statement exists, however, CP9 does not display the required value.
Is it possible to have a cell increased by 1 and another decreasing by 1 in a simple cell formula.
E.g.: I have an inventory stock sheet that is very simple. I have a maximum stock column C, a stock on hand (available) column A and a stock sold column B.
Every time I sell an item and punch it into column B it should automatically decrease the amount in column A by the number that I punch into B.
I am not concerned about the maximum stock column but would like an easy formula just to work out the amount that I have available so I know when to order more stock.
So when I punch in a 5 on B2 it should decrease the value of A2 to 1. And when I purchase stock again and I punch in say a 5 on A2 it should decrease B2 to a 1.
****A* B *C
1 *2 *4 *6
2 *4 *2 *6
3 *8 *6 *14
4 *0 *6 *6
How can I get one cell to increase by 1 after I change the date in another cell. The spreadsheet is used to keep track of Oxygen Bottles at the local Fire Dept. and I want the " Times Filled" cell to increase by 1 after the " Date Filled" cell is changed. I'm not sure if they key the date in or if they use a calender add-in pop up.
View 5 Replies View RelatedI'm trying to sum a range in Column AB that increases by 1 cell every day.
Specifically, Jan 1 will be AB1, Jan 2 will be SUM(AB1+AB2), Jan 3 will be SUM(AB1:AB3)...and so on...Dec 31 will be SUM(AB1:AB367).
If it helps, the dates of the year run from A2:A367.
I need a formula that can work out a percentage increase or decrease from cell J2 to L2.
J2 is the current data with L2 being the previous data - so the formula would compare J2 with L2 and tell me if there is an increase or decrease shown as a percentage.
The figures fluctuate from month to month so they could be either an increase or decrease. There are over 300 entries so I can't go through each one adjusting the formula accordingly - this is why I need the formula to do the working out if it is up or down.
I have a simple spreadsheet. A value is inserted in cell B4.
I want to increase that value or decrease it by adding a button in the next cells, C4 or D4, to increase and decrease that value instead of manually typing in the new value.
I'm a novice at macros and spreadsheets and a Visual Basic Virgin!!.
I'm trying to work out how to increase a cell (B17) value from 1 through 5 then jump back to 1 and count to 5 again etc etc.
The value should be incremented every time cell B33 ="Yes" however there needs to be a 2nd event which resets the B33 trigger to operate again.
This is when cell B34 shows "New Race"
I have to reference to another sheet a fixed increase of moving 6 rows across. What would be the formula for it?
For example.
First formula would be =Sheet1!A1
What would be the formula for the subsequent cells. (eg. =Sheet1!A1+6) obviously doesn't work.
Is there a function in VBA that lets me increment or decrement the number of decimals of a particular cell? let's say i got a cell value of 7.123456 but excel only displays 7 on the cell. What if i want excel to display only 7.123? How can I specify the number of decimals i want on a particular cell (in this case 3)
View 2 Replies View RelatedI need to match data in cell A to cell B and then if they equal I need to copy the adjacent cell C to cell X . How do I set up a macro to do this automatically? I have over 5000 cells to compare and match up.. I have Office 2003.
View 7 Replies View RelatedI'm trying to track how complete a project is by checking if cells contain data, and if they do the percent in cell 'Y4' would increase.
I have 6 cells which represent milestones and if they contain data then they would add a certain percent to cell 'Y4'.
Cells B13 & R13 would have a weight of 15% each
Cells J13, J21 & J30 Would have a weight of 20%
Cell L34 would have a weight of 10%
Is there any way that if these cells contained any data that I could add that percent to the total in 'Y4'?
I have a macro that increase a cell number and one that decreases a cell number, heres my code:
Code:
Sub Macro1()
Dim t
t = Split(Worksheets("Sheet1").Range("d5").Text, "/")
t(0) = Format(t(0) + 1, "0")
Worksheets("Sheet1").Range("d5") = Join(t, "/")
[Code] .......
So they do exactly what i want them to do but i want to put a limitation on them, so say the number in the cell is 0 then i dont want it to be able to subtract from it anymore, and say the number is 20 i dont want it to be able to add any more, i tried to put if statments into the code but no luck.
i'm looking for a loop macro to perform the following task:
Sheet 2 is my look up table, and sheet 1 as a number of references such as:
='Sheet 2'!B1
='Sheet 2'!E1
='Sheet 2'!G1 etc
I need a macro that increases the row references "1" to "2", saves the sheet then increases "2" to "3" and so on until the bottom of the reference table is reached
I don't know if I am asking for something impossible,but is it possible to create a MACRO to automatically add or subtract 10 to whatever number is in the cell? for example:
A1= 20
I would like to have a macro that lets you either add 10 to it to become 30 or subtract 10 to it to become 10.
I have 22-08-08 in Cell A2 I would like it to change to 22-09-08 on 23-08-08 ideally using edate (but not neccessarily).
Perhaps I can add a formula with conditional formatting eg formula is = "On Today()+1 Add 1 month to cell A2"
I have a 49 numbers in cell A1:AW1 they are not in acceding order. I want to separate all groups’ start from lowest number to highest giving them deferent color. As shown in example table below in cell (A2 start with nº 6 and increase up to nº 47 till cell F2 =yellow color) then Cell (G3 decrease nº 3 and increase up to nº 49 till cell L49=Green Color) and continue same process for rest ....
View 9 Replies View RelatedI have a range (M6:BM6) which consists of week end dates = every Friday (M6 =
5/8/09; BM=5/7/10). I would like to have the range adjusted based on when a
cell (B3) is updated. For example, currently B3=5/5/09 and M6=5/8/09 (week
end date of B3). If B3 was updated to 5/12, I would like to have the range
automatically updated to M6=5/15/09, N6=5/22/09....BM=5/14/10. I could do
this with excel formulas in the sheet but would like to macro code adjust the
values in the range rather than formulas.
These ranges are used in other macros and works better with values rather than formulas.
I have multiple worksheets (too many, actually!) and each worksheet is a record. I need to enter a Record Number into B5 of each sheet. The Record Number doesn't start at 1. I'd like to enter a number into the first sheet and the rest of the sheets to increase by 1. However, I only need to do this to some sheets.
View 9 Replies View RelatedI am looking for a way to avoid the circular reference issue. I would like to monitor a cell that is being incremented and decremented so that I can automatically retain the highest and the lowest values that were entered into that specific cell over time. Since the data is only entered into that specific cell and not retained in for example a column, the MAX/MIN option is not usable in this case.
More simply stated, is there a way to put a formula in a specific cell ( A1 ) that will equal the target cell ( B1 ) only when that target cell ( B1 ) is greater than A1?