I have more than 50 sheets of different vendors with dates that is due. I
want to have a dedicated sheet to show which vendor is due.

Sounds like it is time to start learnign Access. In the meantime, look at
this:
http://www.rondebruin.nl/copy2.htm

The code there will allow you to merge data from all 50 sheets into one
Summary Sheet, which Ron named 'RDBMergeSheet'. Then, you can do things like
filter, sort, and/or build a Pivot Table, which will help you organize you
data from those 50 Sheets. One caution about Pivot Tables, you must have a
header and all data under the header must be of the same type, or you'll get
screwed up big time.

this is a good example:
http://peltiertech.com/WordPress/reg...-pivot-tables/

Good luck,
Ryan---



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"tleehh" wrote:

I have more than 50 sheets of different vendors with dates that is due. I
want to have a dedicated sheet to show which vendor is due.