+ Reply to Thread
Results 1 to 6 of 6

some autocomplete order form question

  1. #1
    Registered User
    Join Date
    08-14-2021
    Location
    grand ronde, oregon
    MS-Off Ver
    home and student 2016
    Posts
    4

    some autocomplete order form question

    Customer Order Worksheet:
    Customer selects their choices of exterior color, interior color, and trim package for product in cells (B3,C3,D3) of their order form. Cell (E3) formula compiles three selections into one number. Customer writes phone and address in cells (E4) and (E5).

    Can use MATCH to find customer selections matching options listed in Order Processing Worksheet below (C17:BN17), but then need to somehow? add that customer's order (one to customer) to the tabulation of orders for products with that set of options in appropriate cell below (C18:BN18).

    Then need help to place customer's address from order worksheet into processing worksheet in next available cell below where new order was tabulated.

    Any help, discussion, suggestions appreciated.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: some autocomplete order form question

    So, you will enter data into the top table for customer 1, then want that info to show in a row in the 2nd table, correct?

    Then customer 2 will enter their info in the top table, replacing customer 1's info, and you then want customer 2's info to show in the 2nd table?
    etc

    Is that correct? If so, you cannot do that with formulas, you will need VBA for that.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-14-2021
    Location
    grand ronde, oregon
    MS-Off Ver
    home and student 2016
    Posts
    4

    Re: some autocomplete order form question

    Yes! Yes! Yes! TY Ford for the great advice!

    I'm newest of newbies and rankest of beginners. Now need to learn VBA... Suggestions of how/where to start? Is there a VBA forum maybe, like this one for Excel? But first...

    Customer Worksheet & Seller Worksheet

    Uhmm, thinking about online. Thinking how order forms might work for products with customer-selected options: Make & post customer worksheet. Customer uses worksheet to place order that gets compiled onto seller worksheet. Customer 1, customer 2, 3, ... each have fresh online order form. No waiting for other customer's orders to be processed, nor seeing what others are ordering. Each customer worksheet order form created when webpage is opened.

    Customer selects options, posts mailing address (phone, email, etc.) and clicks "submit order" button last.

    "Submit Order" Button

    Guessing embedded VBA works like macro to auto-execute Excel functions when customer clicks submit order button. Then what is needed are proper Excel functions most suited to be executed by the VBA(?)

    Needed Excel functions (I'm thinking) when Submit Order button clicked:

    Find and select:
    Tried using "MATCH" function in customer's worksheet. It finds where cell is in seller's worksheet, with same number as the options selection number in customer's worksheet. But MATCH doesn't select anything. Is/are there Excel function(s) that, from customer's worksheet will select proper cell in seller's worksheet?

    Pressing "submit order" button on customer's worksheet:
    1) selects correct cell in seller's worksheet using proper embedded Excel function(s), (???)
    2) embeds "return" or down arrow keystroke to select cell below which contains number of orders,
    3) adds "+1" to end of equation in that cell,
    4) copies mailing address from customer worksheet,
    5) pastes mailing address into selected next available empty cell below that cumulative number of orders cell on seller worksheet using proper embedded Excel function(s), (???)

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: some autocomplete order form question

    I see you created a new thread with what appears to be the same question you are asking here.

    If that is the case, please dont start a new thread, just continue here.

    If that is not the case, please explain how they are different.

    I am going to close your other thread as a duplicate - if necessary, please explain why that needs to be it's own thread and I will re-open it

  5. #5
    Registered User
    Join Date
    08-14-2021
    Location
    grand ronde, oregon
    MS-Off Ver
    home and student 2016
    Posts
    4

    Re: some autocomplete order form question

    Uhmm, Sorry if I did what you said! I was having some difficulty with trying to navigate the site or something? Maybe I posted something but it said I had run out of time and I had to reregister and I thought the first one had disappeared or something? It wasn't intentional. And TY for finding and deleting it! I am not the sharpest knife in the drawer, so when things don't work like I think they should I respond first before checking out all the options. I know better, it's a fault of mine. I'll try to do better. Again, TY for cleaning up my mess.

    On the Excel stuff, and the VBA (guessing that's visual basic app?) I'm looking and seeing stuff here, but may well be way too advanced for me... I'll keep trying to swing away at it...
    Last edited by 008klm; 08-17-2021 at 12:35 AM.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: some autocomplete order form question

    No problem with the duplicate thread, it happens sometimes. Next time you log in, make sure you check the "keep me logged in" or "remember me" or whatever it is just under the sign in box...that should stop you from timing out

    VBA is Visual Basic for Applications (close though), and in this context, is the programming language of excel. VBA has a pretty steep learning curve so it may be better/simpler if we just do the coding for you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trying to autocomplete text cells in a form
    By teiru in forum Excel General
    Replies: 3
    Last Post: 10-06-2017, 01:16 AM
  2. [SOLVED] Tab order & form population question -workbook included-
    By diskin8 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-24-2017, 08:56 AM
  3. [SOLVED] Order Form to Summarise Order on another sheet with a Submit Order Button
    By KazzICC in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-01-2014, 03:25 AM
  4. [SOLVED] Autocomplete Form
    By jpoppet in forum Excel General
    Replies: 1
    Last Post: 04-18-2013, 08:42 AM
  5. Excel 2007 : Autocomplete question
    By Meshack in forum Excel General
    Replies: 4
    Last Post: 01-23-2012, 01:47 PM
  6. Autocomplete question
    By filo666 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2005, 01:05 AM
  7. [SOLVED] Autocomplete question
    By marika1981 in forum Excel General
    Replies: 3
    Last Post: 03-06-2005, 08:06 PM

Tags for this Thread

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