Dear all,
I have a worksheet "data reqd" which i want to autofilter based on column headings(name,etc) onto another sheet "data sorted" (another workbook/excel file with dropdowns according to their respective headings). I am
here with attaching my sample data.
I need a COPY PASTE macro which can do the following task on running the
macro once. 1. Column H has the header Account Category.
I need to generate results (like EO) filtering on "data reqd",copy the result and paste it in the "data sorted" sheet l(after clicking on a combo-box i named search) in the range .pls hope you understood my problem.