Thread: macro adjust
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyLan MyLan is offline
external usenet poster
 
Posts: 3
Default macro adjust

I am running this macro in a spreadsheet which carries the numerical data
entered in sheet A to Sheet B with (PO) before each entry.
CURRENT MACRO RUNNING(WORKS PROPERLY)

Sub Worksheet_Change(ByVal Target As Range)
Dim zPO As String
Dim u as Integer
If Not Interest(Target, Range("A2:A9999)) Is Nothing Then On Error Resume Next
zPO = "PO" & Right(Target.Value, Len(Target.Value) - 3)
On Error GoTo 0
u = Sheets("Purchase Orders").Range("A65536").End(x1up).Row
Sheets("Purchase Orders").Range("A" & u + 1) = zPO
End If
End Sub

How can I edit this Macro to carry the same information to a third
location(column) in the workbook on a third sheet with VB (Vendor bills) as
the zVB vale.