I never used VBA before and was able to learn a little through searching for a solution to my issue. I have a worksheet that the end user load from a site to copy rows from their worksheet and paste to Sheet1 as follows:
1. Column A: product id.
2. Column B: date
3. Column C: replacement product id
4. Column D: description
As the end user paste into this worksheet, I wanted the same to be copied to Sheet2 and on any change made in Sheet1. However, I wanted to add a prefix ~ to columns A and C in Sheet2.
Can you please assist with how the code will look like?
What I found working is the following code but dont know how to control what is being copied to the second work sheet.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim sCell As String
sCell = Target.Address
Sheet2.Range(sCell) = Target.Value
End Sub
Bookmarks