Thypec
10-24-2012, 01:02 AM
Hi everyone,
I am new in VBA and I am trying to learn it. I woudl like to do some data editing/moving/arrange.
I would like to do this activity:
Sheet1 - output from DB
Sheet2 - data what I woudl like to have
Compare from Sheet2 "A2" and cell "N1" in sheet1 if true then copy from sheet1 cell "BG2" in sheet2 in column "N2", then continue compare "A2" and "O1"...loop to "S1" and copy cell "BG2" under relevant column in sheet2. If is done go to next culomn A "A3" and so on.
I have no idea how to start, therefore thanky you for any help.
I am new in VBA and I am trying to learn it. I woudl like to do some data editing/moving/arrange.
I would like to do this activity:
Sheet1 - output from DB
Sheet2 - data what I woudl like to have
Compare from Sheet2 "A2" and cell "N1" in sheet1 if true then copy from sheet1 cell "BG2" in sheet2 in column "N2", then continue compare "A2" and "O1"...loop to "S1" and copy cell "BG2" under relevant column in sheet2. If is done go to next culomn A "A3" and so on.
I have no idea how to start, therefore thanky you for any help.