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