Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
following code works fine. Want if column (B) has (X) then target -10 else no
(X) target not sure how to phrase this Thanks Public Sub CopyDonors(ByVal Target As Range) Dim wksSummary As Worksheet Dim rngPaste As Range Set wksSummary = Sheets("Donors") Set rngPaste = wksSummary.Cells(65536, "A").End(xlUp).Offset(0, 0) Application.EnableEvents = False Set rngPaste = rngPaste.Offset(1, 0) Range(Target.Offset(0, -7), Target.Offset(0, 0)).Copy _ Destination:=rngPaste rngPaste.Offset(0, 7) = Target - 10 Application.EnableEvents = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If Condition | Excel Discussion (Misc queries) | |||
lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
Condition 1 overules condition 2? | Excel Worksheet Functions | |||
I need 4 condition for condition formatting | Excel Programming |