+ Reply to Thread
Results 1 to 5 of 5

Using a Form to enter data into multiple worksheets

  1. #1
    Registered User
    Join Date
    03-04-2009
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2007
    Posts
    7

    Using a Form to enter data into multiple worksheets

    I need to create a Form that will enter data into a worksheet. The Workbook has a worksheet for every month. The form would need a way to select a worksheet. The user would then select a day of the month from another list box and this would let the form know which row to add the data to. There would be several text boxes that the user would enter data into and those text boxes would be directed at specfic columns. Any help would be greatly appreciated.

    Thanks

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Using a Form to enter data into multiple worksheets

    Welcome to the forum!

    When you say form, I think you mean userform.

    For detailed help, you need to provide a sample xls or code or explain your needs in more detail.

  3. #3
    Registered User
    Join Date
    03-04-2009
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Using a Form to enter data into multiple worksheets

    The attached Sample file only has 4 sheets. The one I'm working on has 1 sheet for every month.
    I need to create a userform that will have text boxes where the user can enter sales numbers for the the following columns.
    Food, Liquor, Beer, Wine, Tax, Comp, Disc, Discov, Visa, MC, Total Cash.

    Column A holds the date for that particular month. The form needs to have a way for the user to select a month and a day so it will know where to enter the information in the workbook. The month selection would choose the appropriate sheet and the date selection would chose the row.
    Attached Files Attached Files

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Using a Form to enter data into multiple worksheets

    It would be much simpler to use one sheet for all the data. Have a date column and then use a PivotTable or autofilter to view monthly data. With a PivotTable you can group data by months or quarters

    Your sheet needs to be in the correct format - no empty rows between the header & data, no empty colmns in the data. You can then create your own userform or even use the inbuilt data form from the Data menu. See an example form here

    http://www.excel-it.com/vba_examples.htm
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Registered User
    Join Date
    05-24-2013
    Location
    INDIA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Using a Form to enter data into multiple worksheets

    I need to create a Form that will enter data into a worksheet. The Workbook has a worksheet for every month. The form would need a way to select a worksheet. The user would then select a day of the month from another list box and this would let the form know which row to add the data to. There would be several text boxes that the user would enter data into and those text boxes would be directed at specfic columns. Any help would be greatly appreciated.

+ 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