I have a large database that contains information layed out as follows:
(column G)
CallDirect_CDR-790seu_approval.doc
CallDirect_CDR-790seu_approval.pdf
CallDirect_CDR-790seu_approval_A.doc
Motorola_V975.doc
Motorola_V9x.html
Motorola_V9x.pdf
etc... (it has 4000 lines)
I need a program or function to search through each entity and pick up the brand (the words before the underscore.
so for example if we take the RED example, it should pick up just the following:
CallDirect
Then I need it to find the model, in the same example it should find the following:
CDR-790seu
So now it has gained 2 vales; the name: CallDirect and the model:CDR-790seu .
The next stage is for it to look through a different workbook (this workbook only contains 1 sheet) - (I can arrange this sheet to be put in the same workbook as the the first database) and firstly search the name, then product... the 2.d database it needs to look through wout look like this:
(all *'s indicate a new column)
A1 * A2 * A3 * A4 * A5
114 * closed * Call Direct * router * CDR-790
153 * closed * Calyptech * FWT * iFWT
35 * closed * Calyptech * FWT * iFWT
It would find the red row and take just what value is in A1, in this case 114.
This 114 value would now be placed back in the original sheet next to the line it was searching from to now make:
CallDirect_CDR-790seu_approval.doc * 114
If anyone could help me with this that would be amazing...
thanks guys
benjaminpott
Bookmarks