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 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 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 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 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'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?
how to change the cell colour due to a sum increase or decrease? For example: if the amount is greater than 200, change cell colour to green. If under 200 change cell colour to yellow.
View 2 Replies View RelatedOur business has a spreadsheet set up for invoicing. A Macro has been created to increase the invoice number, save to the desktop as a PDF with a file name taken from the cells
This is working on my colleagues mac but when we've loaded onto my computer it errors, when I debug I am getting the following error:
Sub Macro3()
'
' Macro3 Macro
'
'
Range("g10").Select
[g10] = [g10] + 1
[Code] .......
I am struggling to create a formula to make a cell increase in value as another decrease. For example
Starting information
Cell 1 is 8
Cell 2 is 10
Cell 3 is 10
For each 1 that Cell 1 decreases, I need cell 2 to increase by the value of cell 3 plus 10% of cell 3.
For example Cell 1 has decreased by 1, therefore Cell 2 equals the value of (Cell 3 plus 10% of Cell 3)
Cell 1 is 7
Cell 2 is 11
Cell 3 is 10
For example Cell 1 has decreased by 2, therefore Cell 2 equals the value of (Cell 3 plus 20% of Cell 3)
Cell 1 is 6
Cell 2 is 12
Cell 3 is 10
For example Cell 1 has decreased by 3, therefore Cell 2 equals the value of (Cell 3 plus 30% of Cell 3)
Cell 1 is 5
Cell 2 is 13
Cell 3 is 10
trying to get number value to increase by 1 in the cell previous descending down a column.
View 9 Replies View RelatedPrivate Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Address(False, False) = "C2" Then Range("F2").Value = Range("F2").Value + 1
End Sub
I am using the follow macros code when I right click my spreadsheet and enter it in the window there. My intention is to increase the value in F2 every time the value in C2 changes to a specific text value. For instance, if C2 has the value "Alex" I want F2 to increase by 1 every time C2 changes to say "Joe" and only Joe. If it changes from Joe back to Alex that does not need to be counted, only changing it to Joe needs to increase the value in F2 by one each time.I also need to do this for all values in the spreadsheet from C2-C59 and increasing the corresponding cell in F2-F59.
Having an issue with copying down.
Workbook 1 has data vertical
Workbook 2 has data horizontal
I need the formula in Workbook 1 to pull from the respective date in workbook 2, or just a simple formula increasing the column by 1 for each row.My issue is that when i copy down, the column never increases, it stays on the same one.Example is attached.
I have attached a spreadsheet, in which I have highlighted the following cells (I2, J2, G31 and I31)
View 7 Replies View RelatedI have a sheet comprising of 4 columns, laid out like the below ;
A4 = Equipment
C4 = Cost
E4 = Revenue
G4 = Gross Profit
I require to enter a percentage into the gross profit column, and for this to interact with the cost column, then for the revenue column to return the total of the cost including the profit.