Hi everyone!
I am very new to Excel VBA and I have been struggling with a task which seems easy but I can't make it work. I have one worksheet (Main) into which I need to copy data from another worksheet (RDMS). The RDMS worksheet has around 6000 rows and columns from A:BV. In column A, it has a unique number for each entry.
Now I need to write a code that looks at the unique number in column A in the RDMS worksheet and if the number is not yet in the Main worksheet, it will paste specific columns from this row into Main worksheet (for example row B, C, AA and BV). If the unique number is already present in the Main sheet from before (because this will be a live document being updated) it will simply skip it.
Would anyone be able to give me a hand with this code?
Auxcron
Bookmarks