Thanks Dave,

The original data was retrieved from a corrupted Access db.
The handful of users of this admin membership database are more
familiar with Excel and that's where I hoped to rebuild a 20x1000 db.

Thanks,
Mick


Dave Patrick wrote:
Probably much easier to do in Access

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Mick" wrote:
Hi Friend,

Can you help?

I need to build an Excel VBA database (about 30 fields and 2,000 rows)
that can dynamically add membership details and produce a custom
report.

Adding (or deleting) membership details could have a GUI front end.

The membership details could use drop down boxes to populate fields as
well as fields for manual data entry.

A search / report output function could be a data table or chart/graph
or both.

Any help would be greatly appreciated.

Thanks,
Mick