Here goes,
I start off with a download, this info is then passed on to 5 WORKBOOKS thru lookup functions where additional information is added. Each workbook has a list of what belongs in the file. This list can change on a monthly basis.
The problem I have is that once my 5 workbooks are completed, I need to be able to take this new info and be able to allocate it out to say 10-12 new workbooks based on their own set of criteria. This may sound a bit convoluted but it has to be this way. Drop down boxes seem like an easier way to go, but would cause procedural issues
Suffice to say I guess me question is this.
What is the best way of searching thru multiple workbooks?
I've been getting the ole hands dirty with all the lookups, matches, indexes, indirects, isan, but I am thinking VB might be the choice?
Thanks in advance for your thoughts.
I start off with a download, this info is then passed on to 5 WORKBOOKS thru lookup functions where additional information is added. Each workbook has a list of what belongs in the file. This list can change on a monthly basis.
The problem I have is that once my 5 workbooks are completed, I need to be able to take this new info and be able to allocate it out to say 10-12 new workbooks based on their own set of criteria. This may sound a bit convoluted but it has to be this way. Drop down boxes seem like an easier way to go, but would cause procedural issues
Suffice to say I guess me question is this.
What is the best way of searching thru multiple workbooks?
I've been getting the ole hands dirty with all the lookups, matches, indexes, indirects, isan, but I am thinking VB might be the choice?
Thanks in advance for your thoughts.