Hi ,
I need an help in creating macro for doing two tasks
1.To copy the data from one sheet to new sheet in same excel based on a particular column.Column C will have multiple values and these values might repeat ,so i need the macro to put filter on that column and copy paste the relevant details to new sheet for all the values in that column.
2.The other macro has to paste the data in a specified order in a different excel sheet.For this the output given by first macro will be used, the new sheets which the first macro created will be pasted in a order in different excel by using second macro.
First Macro Order to copy paste in second Macro
Column B Column C
Column E Column G
Column D Column E
The column B of first macro has to be pasted in column C by using the second Macro in the similar way the other two columns also has to pasted.Once this done it has to leave a line and again it has to paste the same data.
Can you please help in doing this.
I have attached the outputs of the two files to show how it looks.
I hope this helps in creating a macro.
Eagerly waiting for a quick reply.
Bookmarks