Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: I NEED A HERO!!

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am creating a database of companies and products purchased and I am trying to figure out how to use one worksheet in a workbook as a GUI form to capture data that is stored in database format in another worksheet in the same workbook.

    I know the excel template wizard does this already but the data is captured in a separate workbook. Is there a way to modify this?

    Thanks for any assistance.

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What exactly are you asking for here?

    What are you looking for this pseudo GUI to do?

    You're saying that the data is in the same workbook one minute and the next you're saying that the data is in a separate workbook. Which is it?

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Mark,

    Thanks for the post and forgive my novice terminology.

    Allow me to clarify.

    I am wanting to use worksheet #1 for data entry. The worksheet is setup as a template with check boxes, pulldown menu's etc.

    After inputing the data in the template I would like click a button or run a macro to send it to another worksheet in the same workbook but in database format(column headings)

    So, it would work just like the template wizard but it wouldn't put the data into a separate workbook.

    I hope that is more clear.

    Thanks again.


  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That would not be difficult to do...
    But to get a helpful code example here, you will need to list your controls and exactly where on the other sheet the data from each needs to be sent...

    I don't mean to be vague, but these are details which would be needed to really help you out...

    Thanks,
    Tom

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The layout of the template worksheet is in a list so the cells for data entry would be something like

    NAME:C5
    ADDRESS: C6
    CITY: C7
    STATE: C8
    ZIPp C9
    ETC...

    The worksheet holding the data will be in datbase format so the corresponding cells would be in rows like:

    NAME:A2
    ADDRESS: B2
    CITY: C2
    STATE: D2
    ZIPp E2

    Once again the template wizard with database tracking has the exact functionality I am looking for except I don't want to send the data to a worksheet in a separate workbook.

    Thanks for any help!

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    With my limited knowledge, here is what I could help you do...
    Place a button on the data entry sheet called "Add Record"...
    Would check to make sure all the data has been entered, send to the next available row on your database sheet, and then sort the database.
    Have you included a primary key on your data entry sheet? A unique identifier for each record?
    Phone numbers are usually ok.
    Last names are generally not a good idea because of duplicates.
    Will you be querying this database?
    Tom

    Tom

  7. #7
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Tom,

    What you propose sounds great. I do not have a unique identifier like you said the phone number would work.

    I would like to query the database. I figured auto-filters would work well or another spreadsheet that uses vblookup.

    Thanks,

    Kevin

  8. #8
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    All I need is a sample sheet for the data entry or at least the columns and data types in each...Dates, Text, Numbers, ect...
    Or just send me sample...
    Also, which cells in a record are mandatory for entry or not(For Validation)
    By which column do you want to sort your database?
    TsTom@Hotmail.com
    Thanks,
    Tom

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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