Jody Reid
asked on
I need to subtract .50 from every number in column c every 2 weeks
I need to subtract .50 from every number in column c every 2 weeks. Column c is different every 2 weeks in how many numbers are in that column. I also need to keep these as whole numbers as I need to another program to pull these numbers from this sheet. I am uploading an example of my file.
Test1.xlsx
Test1.xlsx
There is no attachment.
you will need to decide how you want that data...
subtracting the .5 is easy, but here are some question:
do you just want to change column c ? or do you want a history built so that you see what result was obtained at what date?
how do you want the rounding to be? if I subtract .5 from 9.2, the result is 8.7 - does that turn into 8 (which would result in a formula =INT(C2) or do you want to apply normal rounding, result 9 , formula=round(c2,0) ?
how do you want to trigger the subtraction? automatically? manually? macro driven?
subtracting the .5 is easy, but here are some question:
do you just want to change column c ? or do you want a history built so that you see what result was obtained at what date?
how do you want the rounding to be? if I subtract .5 from 9.2, the result is 8.7 - does that turn into 8 (which would result in a formula =INT(C2) or do you want to apply normal rounding, result 9 , formula=round(c2,0) ?
how do you want to trigger the subtraction? automatically? manually? macro driven?
ASKER
I would like to just change column C, don't need a history as I will have it already. I need the numbers to be 8.7. I would like to have it triggered manually with a button if possible. Thank you.
ASKER
sorry I did not upload file. It is there now.
Thank you
Thank you
As per your sample file, column C is empty.
Do you mean subtract 0.50 from column B?
Do you mean subtract 0.50 from column B?
Maybe I am missing something but simplest way I can see is:
1) Enter 0.5 into a spare cell
2) Copy that cell to the clipboard, Ctrl + C
3) Select the cells in column B
4) Select Edit > Paste Special
5) In Paste Special window, in middle section select Subtract, click OK
All values in column B will be reduced by 0.5
Job Done, matter of seconds and maintains Undo history if required which using VBA would not.
1) Enter 0.5 into a spare cell
2) Copy that cell to the clipboard, Ctrl + C
3) Select the cells in column B
4) Select Edit > Paste Special
5) In Paste Special window, in middle section select Subtract, click OK
All values in column B will be reduced by 0.5
Job Done, matter of seconds and maintains Undo history if required which using VBA would not.
ASKER
yes column B. Thank you.
Please find the attached and see if something like this would work for you.
Click the button to subtract 0.50 from column B values. Each time you click the button, 0.50 would be subtracted from column B values and the caption of the button will be updated to let you know when did you update the column B.
SubtractFromEachCell.xlsm
Click the button to subtract 0.50 from column B values. Each time you click the button, 0.50 would be subtracted from column B values and the caption of the button will be updated to let you know when did you update the column B.
SubtractFromEachCell.xlsm
ASKER
Yes that is great. How do i get that to work with my excel file.
Thank you.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
You're welcome!
Just saying....
A bit like a sledgehammer to crack a nut when a simple copy and paste will do the trick. But heh, each to their own.
A bit like a sledgehammer to crack a nut when a simple copy and paste will do the trick. But heh, each to their own.