Hello all... First time posting.
I need help with vba code that I am currently working on. I need to be able to take data from a range in a worksheet and copy the data to a new worksheet. I have been able to successfully create this code. However, I also need to be able to validate whether the data already exists in the workbook being copied to. If the data exists, it should overwrite the existing data. If the data does not exist, then it should paste the data in the next available row. I have the copy and paste functionality working. I just need help with the overwriting validation. Any help would be greatly appreciate. See my code below:
Bookmarks