BarryAllen
New Member
- Joined
- May 30, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi All,
New to VBA but very much interested in learning. I'm trying to copy values from Sheet2(Schedule) range B12:B37 to Sheet1(Data) Column "H". I'm wanting it to paste at the end of the column after last value. Then look at all values in column range and remove duplicates, Hoping this can be done automatically so I'm not having to "run" a macro each time.
New to VBA but very much interested in learning. I'm trying to copy values from Sheet2(Schedule) range B12:B37 to Sheet1(Data) Column "H". I'm wanting it to paste at the end of the column after last value. Then look at all values in column range and remove duplicates, Hoping this can be done automatically so I'm not having to "run" a macro each time.