HI,
I have sheet 1 with column A consisting of list of names, column B has qty & column C has amount.
Now in sheet 2, column C has list of name , & values for column D & E has to be taken through lookup from sheet 1.
Now values are taken vllookup formula Has to be removed from columns D & E
Please advice how can I achieve this through macro.
Bookmarks