Macro for compare and copying using loop function

[sarajun_88]

There are 2 sheets - sheet 1 and sheet 2

sheet 1 has data in the group name as headers. I want the macro to compare each header in sheet 1 with the column D of sheet 2. if the column heading matches the data with that of column D then its corresponding data in the column B of sheet 2 should be copied to column A of sheet 1.

That is if A present in column D of sheet 2 then all the data that has the group name as A should be copied to column A of sheet 1. The macro has to loop in till it finds the group name A and copy them to column A.

[nilem]

try it

Please Login or Register  to view this content.

[sarajun_88]

Thank you Nilem!! it works. But is it possible to pull the data as per the column headings in the sheet 1 from sheet 2 and paste them on sheet 1 below the respective headings?

i feel that will make my work more easy.

your macro works very well its just i want a little modification to make my job easier.

Thanks a lot

[nilem]

Hi sarajun_88,
perhaps you mean about it

Please Login or Register  to view this content.