Requesting help with template for multiple employee expenses

[ma10024]

Hello


I have a download of several hundred transactions between 20 employees and have it in named range 'trans' in the 'info' tab. This raw data is in csv format


On a new 'my' tab, I want employees to enter their name and employee ID, and after a lookup, retrieve only their transactions from the 'trans' tab and pasted onto 'my' tab


For example, if Mike has 20 transactions and Tim has 10, after the name/id validation, I only want Mike to see his transactions (not Tim's). Obviously, this world a protected workbook


All help would be appreciated. Thanks

 

[Hui]

Ma10024


Firstly, Welcome to the Chandoo.org Forums


You may want to look at the technique described by Luke at:

http://chandoo.org/wp/2011/11/18/formula-forensics-003/


Hint: You may need to break the CSV file into fields to access the Name Data

 

[nazmul_muneer]

Dear ma10024,

You can also do the job simply by preparing a pivot table.


Regards,


Muneer

 

[ma10024]

Thank you, I think this works. Will keep you posted