Hi all,
Sorry to be the newbie posting and requesting help immediately but I just started a new role and very occasionally we need to use macros.
I want to do the following:
I have two sheets in an excel file, which are the same format in terms of how they store data. However they are two different sets of data, with one column being constant across the two (which is what I currently use to vlookup against).
I want to copy the the data from one sheet 'old data' into the new sheet, in a column next to the corresponding column in the new sheet, and then compare the two in a further column to the right
Hopefully these images shows what I mean:
Uploaded with ImageShack.us
Uploaded with ImageShack.us
So yeah the process is really about inserting new columns, pulling over the data from the 'old' sheet, then comparing the two.
Seems so difficult!!
Sorry to be the newbie posting and requesting help immediately but I just started a new role and very occasionally we need to use macros.
I want to do the following:
I have two sheets in an excel file, which are the same format in terms of how they store data. However they are two different sets of data, with one column being constant across the two (which is what I currently use to vlookup against).
I want to copy the the data from one sheet 'old data' into the new sheet, in a column next to the corresponding column in the new sheet, and then compare the two in a further column to the right
Hopefully these images shows what I mean:
Uploaded with ImageShack.us
Uploaded with ImageShack.us
So yeah the process is really about inserting new columns, pulling over the data from the 'old' sheet, then comparing the two.
Seems so difficult!!
