Macro to list all data for two criteria

[rrajansg]

Can anyone help to give macro

Data title

A1 Staff Name
B1 Customer Name
C1 country
D1 type of sales

etc. upto Column L

X ABC India
X PLM USA
Y SY India
Y QE Japan
Y DE India



Report required in another sheet

if I give two criteria "Staff name" & "country" in A1 & B1
I should get all the rows with this Staff name and country

If I query Y and India, result would display all the columns for Y and India
Y SY India
Y DE India

Thanks in advance

 

[lenze]

Hi and welcome to the board!!
Have you looked at either the AutoFilter or Advanced Filter? IS it really necessary to move the data to Column "L" or do you just need to view it. You might also consider a Pivot Table.

lenze

 

[rrajansg]

Thanks

I tried auto filter. It serves the purpose. But I am thinking of something in macro. I have to generate report separately. I will not move any data from the master worksheet. Whatever reports I generate, it is independant of master data.

Rajen