Software

Ask something
Discussion Locked

Input to Excel File Help Needed

0 helpful
4 replies

by jkdunne

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all,

What i'm looking to do is input information from a form into an excel file.

I need to build a user friendly interface to input the data and then use excel to sort through the data so information could be displayed for a single client for instance.

Is there any way in Excel or otherwise of doing this without having to create a web application?

Any help appreciated.

4 replies

by koerper

You can create forms in Excel, but it sounds to me like that wouldn't be your best bet. MS Access would probably work better...unless this is going to be a large database with a lot of users or unless it will be on the Internet. In that case, I'd go all the way with a SQL database and web app.

by jkdunne

Hey thanks for the reply.

I've decided to use Excel with a VB form to sort this out.

Its just the fastest solution and Excel is about the only application that I know no one here will have trouble using.

Thanks

by lizmcbryan

I'm trying to solve much the same problem, and have limited time to do it - I'm a teacher, so this kind of work it extra-curricular. Is there any way you could be persuaded to share your solution files (or a stripped down version of them)?

by jamesramsay72

It is possible to create an excel application that looks and acts just like an Access database. If you want to see the art of the possible check out this flash presentation - www.theprospectingplugin.com/Presentation.html
Excel is hidden and a form opens automatically that interacts with the Excel workbook. Using Excel formulas you can write to/from cells to mimick the functionality of an Access Database. Look at Excel functions like Offset, Match, Lookup, Vlookup, Index, etc.

This discussion is closed to new replies.