need to build an Excel VBA database

[Mick]

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

 

[Dave Patrick]

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

 

[Shaka215]

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

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

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

 

[Mick]

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

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

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