Gate the data from master file

[ganeshh]

Hello

I have data of more than thousand people. Column names are Sr. No., Emp Id, Address, Address 2.......
I want to data for 10 people in another sheet by using Emp Id which is uniqe Value
but column No is not fix for Emp Id.

Anyone can help me..?

 

[Sektor]

You mean that it can be B, C or D column?

 

[ganeshh]

yes it may be in any column

 

[Sektor]

If in can be in any column, where data is located? Sheets of the same workbook or external workbooks?

 

[ganeshh]

the data will be in same workbook sheet name is "Raw Data" and I am trying to get the require data in another sheet "Required Data". Both sheets will be in the same workbook.

 

[Sektor]

Why does column "No" float around sheet?

 

[ganeshh]

the data will be in same workbook sheet name is "Raw Data" and I am trying to get the require data in another sheet "Required Data". Both sheets will be in the same workbook.

earlier I was using Vlookup to Get the data. but now days i require the data 10-12 time in a day. it is time consuming.. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[ganeshh]

Why does column "No" float around sheet?

that is system generated data for the different purposes so it is not fixed..

 

[ganeshh]

and the columns will be different according to the purpose..

 

[ganeshh]

anyone can help me on this..?