+ Reply to Thread
Results 1 to 2 of 2

Database form

  1. #1
    Paul
    Guest

    Database form

    Newbie question:

    I am looking for the best way to fill in a form (in sheet 1) after the
    database has been done (in sheet 2). Don't want to use the Form feature of
    Excel as I want to print and distribute the reports.

    My question is how I can fill in the cell of the form that i want from the
    database?

    Form:

    ID: 2

    Status: Done
    City: LA
    Paid: NO


    Database:

    ID Status City Paid
    1 Done Kansas Yes
    2 Done LA No
    3 Working on Denver Yes


    Thanks for your help.

    Paul




  2. #2
    Jim Rech
    Guest

    Re: Database form

    I'd suggest an approach like this:

    Sub SetData()
    Dim Idx As Integer
    Dim DataRow As Range
    Idx = Range("Idx").Value
    Set DataRow = Range("Database").Rows(Idx)
    Range("IDCell").Value = DataRow.Cells(1).Value
    Range("CityCell").Value = DataRow.Cells(2).Value
    Range("PaidCell").Value = DataRow.Cells(3).Value
    End Sub

    --
    Jim
    "Paul" <[email protected]> wrote in message
    news:[email protected]...
    | Newbie question:
    |
    | I am looking for the best way to fill in a form (in sheet 1) after the
    | database has been done (in sheet 2). Don't want to use the Form feature
    of
    | Excel as I want to print and distribute the reports.
    |
    | My question is how I can fill in the cell of the form that i want from the
    | database?
    |
    | Form:
    |
    | ID: 2
    |
    | Status: Done
    | City: LA
    | Paid: NO
    |
    |
    | Database:
    |
    | ID Status City Paid
    | 1 Done Kansas Yes
    | 2 Done LA No
    | 3 Working on Denver Yes
    |
    |
    | Thanks for your help.
    |
    | Paul
    |
    |
    |



+ 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