+ Reply to Thread
Results 1 to 5 of 5

Theory question

  1. #1
    Forum Contributor
    Join Date
    10-28-2003
    Location
    Happyville, USA
    MS-Off Ver
    365
    Posts
    300

    Theory question

    Hi,

    I have a theory question. I'm sure I'll have actual functions questions soon enough.

    I am trying to move a very manual process (data that is being written into ledger books?????!!!!) into excel. I want to create a sheet that will capture this data. I'm looking to create a form that will have various entry fields that will be fed into a main table. I guess I'm basically looking to create a data entry sheet and use excel as the database.

    Any thoughts on where I should be turning my attention to in excel to make this happen? There are probaly various ways of doing what I'm looking to do and I'm sure someone out there knows the best tree for me to be barking up.

    Thank you in advance,

    Eddie.

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi Eddie,

    Go with a test first ...
    Input all the field names in row 1 ...
    A couple of rows of test data, and use Data Form to see if it is Ok for you ...
    If not, you will go to design your own input form ...
    HTH
    Carim


    Top Excel Links

  3. #3
    Forum Contributor
    Join Date
    10-28-2003
    Location
    Happyville, USA
    MS-Off Ver
    365
    Posts
    300
    As always Carim I thank you for your quick reply. After doing some looking I found the below link which had exactly what I was looking for.

    http://www.contextures.com/xlUserForm01.html

    Thanks again,

    Eddie.

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    You are welcome ...

    Thanks for the feedback

  5. #5
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    In fact XL itself provides the built-in Data-Form feature, but I really don't know how much help it is

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1