How to subtract a value from several cells and display in individual active cells
Hello everyone,
I am really illiterate when it comes to VBA codes in Excel. I have values in cells A2 to A9, cells B2 to B9, cells C2 to C9 and so on upto K2 to K9. I also have a value in cell A1.
I want to subtract A1 from each of the above values (i.e. A2:A9, B2:B9.....K2:K9) and would like to have them displayed in individual cells.
Please help.
J
Hi
Why do you need VBA, won't a formula do?
Individual cells where?
If you put =A2-$A$1 in cell L2 and drag across and down you will get what you have asked for.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
TMShucks, Thanks very much. I tried what you suggested and it works. I am good.
Thanks, have a great day.
J
You're welcome.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks