VLOOKUP might help you.

Also, putting the info in Access is a possibility. You coudl then run
queries on it from Excel using Microsoft query.

"jeansguy" wrote:

I have an excel workbook which contains a number of sheets (it is an asset
list). I need to be able to produce something (VBA?) that enables the 7
sheets to be searched so that items that were purchased and discarded on a
specific date ranges can be found in the worksheets and then pasted into a
new worksheet in order to produce a "report". Ideally I also need to be able
to filter the report by location of the assets. I can do basic stuff in
excel like forumlas to add up a range of cells and take averages etc but this
is as far as my exsperience extends. I would therefore like to know if
anybody advise me the best way to go about this? Given my knowlege is this
going to be achivable without taking too long i.e. iv only got about 7 days
over the period of 2 to 3 weeks to do this. As an alternative I was thinking
of importing the spread sheet into access, as I felt that I might be able to
achive this better in there, however the end user of this would prefer if the
asset list remained as a spread sheet. Any comments would be apprciated.