need to build an Excel VBA database
 

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

need to build an Excel VBA database
 

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

need to build an Excel VBA database
 

Mick,

If you want this built I can do it for you...Please message me if you
are interested.
You might be able to get help trough the boards but your asking quite
alot to be done...Hope someone can help you out.

-Todd


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

need to build an Excel VBA database
 

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