As I am new member I cannot upload attachments so let me describe my simple problem.
I have two columns in sheet “sheet” named column “A” and column “B”. Both columns vary in the number of cells each and every time the user fills the columns.
I created column “C”, and I need to copy column “A” at the beginning of column “C” into the sheet “C2”. (this part I was able to do so)
Now I need to copy data from column “B” (and as I do not know how extensive - long the data from column “A” gonna be) and paste the data into the column “C”, right below the last cell, which was filled last (end of data from column “A”)
As data are placed properly in column “C”, now I need to remove duplicated and the process is done.
Last but not least, at the very end of the process, I want to maintain my excel worksheet open.