Find a Product

[narendra1302]

Dear All,

I am having 4 excel files (Database). Which is of Product Damage database. Now There is a field (Column) in which Number (may be alphanumeric) of the Product is written. And data in that files are of around 65 columns. All the four files are at differnt locations. Also file header is not matching.

Now my question is that Can we have a code which will find the number of the product when we will enter - Which shows the history of that product number.

e.g.
1. I have one.xls, two.xls, three.xls & four.xls - Four excel files at different locations.
2. Now one part "45893" is there. We want to find when it was come & the history of that product number. There are Hyperlinks also in columns.
3. It will also show - From which of the four files it is.


Thanks
Narendra

 

[narendra1302]

Dear All,

Now all these sheets are in one file. So no different files & different locations. All in one files with 4 different sheets.

So how to find it particular product number's details.

Thanks
Narendra

 

[narendra1302]

Hi,
Any updated ?