Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build a query from a web-based database or a PDF file. | Excel Discussion (Misc queries) | |||
I want to build a database | New Users to Excel | |||
Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row | Excel Programming | |||
How do I build a database of names and addresses? | Excel Discussion (Misc queries) | |||
How to build build a macro that automatically imports | Excel Programming |