Data Searching & Linking between two excel files.

I have two excel files.

One file is having all the data…columns like sr.no., product name etc.

What I want is that…

If in other excel file, I enter the Sr.No. corresponding data from row of other excel file should be copied.

A sort of data searching.

Please help me about this as soon as possible. Thanking you in advance.

Excel Version Used: 2007, 2010.

OS: Win 7

 


Edit your submission

Leave a Reply

Your email address will not be published. Required fields are marked *