VBA: Lookup A Value and Deduct A Value
Closed
JC
-
Oct 28, 2016 at 09:53 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 1, 2016 at 12:02 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 1, 2016 at 12:02 PM
Related:
- VBA: Lookup A Value and Deduct A Value
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Https //accounts.google.com/sign in/v1/lookup - Gmail Forum
- Number to words in excel without vba - Guide
- How to enable vba in excel - Guide
- Vba case like - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
545
Nov 1, 2016 at 12:02 PM
Nov 1, 2016 at 12:02 PM
Hi JC,
That actually does make sense!
Try the following code:
Best regards,
Trowa
That actually does make sense!
Try the following code:
Sub RunMe() Dim vFind As Range Set vFind = Columns("C:C").Find(Range("M1")) If vFind Is Nothing Then Exit Sub Range("J" & vFind.Row).Value = Range("J" & vFind.Row).Value + Range("N1").Value End Sub
Best regards,
Trowa