Share via

Using Excel data entry forms

Anonymous
2011-09-20T17:33:26+00:00

Is there a way, using the Excel data entry form box, to specify which worksheet you want the entry to go into?

Example, in an inventory spreadsheet I have a sheet for "Tools" and a sheet for "Safety Equipment", both sheets have the same header information. I would like to find a way to use the data entry form to enter data from an invoice and specify which sheet I want the information on.

Any suggestions? Using Excel 2007, on XP @work, but Vista @home.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

5 answers

Sort by: Most helpful
  1. Anonymous
    2011-12-09T15:11:15+00:00

    Hello, Nightowl

    Please remind me where to find the Excel Data entry form box...  It is a very badly documented gadget and I can't for the life of me remember where they have hidden it!  I am also on Excel 2007 on XP

    It would be quite simple to build a data entry box with sheet selection, but I guess you are hoping not to do this.

    Regards

    geoff

    0 comments No comments
  2. Anonymous
    2011-09-24T07:50:53+00:00

    This is very interesting.... I am currently using an invoice data entry form with up to 7 items per invoice.  And I post all items to one sheet because I want to keep the invoice in tact.  I then loop through the invoice sheet to split the items out to the different category sheets.

    what you want to do may come in handy and I ran a quick test.

    invoice input form

    ITEM DESC.          CATEGORY

    hammer               1

    hard hat              2

    etc                     etc

    with a post button            only to demo the indexing option

    Dim x As Integer

    x = category.Value

    Worksheets(x).Select

    Range("a1").Value = item.Value

    By using the category as sheet index you can post directly to the sheet you want.  this goes to sheet1 and sheet 2

    This is bare bones example that I used to test it,  but should point you in the right direction.

    I will be watching for other responses.   There is probably a better way    John

    0 comments No comments
  3. Anonymous
    2011-09-23T18:57:43+00:00

    For further help on this issue you may also post your query in the link given below:

    http://social.technet.microsoft.com/Forums/en/excel/threads

    0 comments No comments
  4. Anonymous
    2011-09-21T16:06:38+00:00

    No, the invoice would be where the data was coming from.

    0 comments No comments
  5. Anonymous
    2011-09-21T06:54:17+00:00

    Is ‘Invoice’ a separate sheet or a separate excel file?

    When you enter the data in the data entry form the title of the data entry form contains the name of the worksheet on which the data will be entered.

    0 comments No comments