Results 1 to 5 of 5

UserForm input data to multiple rows

Threaded View

  1. #1
    Registered User
    Join Date
    11-23-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    21

    UserForm input data to multiple rows

    Attached I have a spreadsheet with a user form to capture orders.

    I have got the form working as far as, each piece of data will go into the right column heading. However because one customer will order multiple items I cannot work out how to get the items to list in one column a row at a time.

    My idea is that each multipage and all the data entered (zero if blank) will be dumped into the spreadsheet in its rightful column in a list as displayed in the form, as each value in the list represents the weight band aligned to it.

    Maybe I cannot do it as it is currently set up, so any other ideas/suggestions welcome.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Save all UserForm data for multiple rows
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2015, 02:22 PM
  2. Email data from Specific Rows in Multiple worksheets from Userform Command Button
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-09-2014, 07:07 PM
  3. [SOLVED] Userform Macro to Use Textbox input to Generate blank rows.
    By jaredmccullough in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 04-02-2014, 01:21 PM
  4. Multiple Users input data using Excel Userform to a Common Access Master Database
    By eummagic in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-08-2014, 01:45 AM
  5. Replies: 4
    Last Post: 11-28-2012, 06:09 PM
  6. Multiple TextBox Input From Runtime Records On Userform
    By bazza88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2010, 04:48 AM
  7. UserForm selected data; to edit multiple worksheets(& specific rows)
    By anonfish in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2010, 11:43 PM

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