+ Reply to Thread
Results 1 to 6 of 6

Need to have a popup form that will auto fill another area when done.

  1. #1
    Registered User
    Join Date
    08-28-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    6

    Need to have a popup form that will auto fill another area when done.

    Hello,

    I have a very complicated task (at least complicated to me) I love figuring out excel issues however I do not know how to tackle this one. please help...

    here is what I am trying to do. I am creating a template for my accounting department to use for our invoices. there is a lot of complicated stuff I will need help with but the first thing is this.

    I will have a spot for item description

    another spot that has a drop-down menu for Quantity (1-100)

    another spot that askes if items are serialized with a drop-down menu (yes-no) yes/no drop down box will be changed to a combo box

    upon completing each field and if s/n =yes, then I need a box to pop up (name of the box is what was put in the Item (brief desc) field, then the amount of cells in the box is the (amount selected in Quantity drop-down menu.)
    this will allow accounting to put the proper amount of serial numbers in the field. after they put the s/n's in the field I would need an ok button that will auto-populate another tab to store s/n's with the same header and amount of cells as the popup box. later this will all auto-populate in an invoice template. but for now, I just need help with this box

    I don't know if this is easier or harder than I think but it sounds super complicated to me and I just can not figure it out.

    thank you in advance for any advice and help!

    On attachment, the area I am working on right now is the Product information section.

    changes already suggested that I plan to make:
    1. no merged cells
    2. yes/no drop down box will be changed to a combo box
    Attached Files Attached Files
    Last edited by Normonious; 06-21-2021 at 02:05 PM.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Need to have a popup form that will auto fill another area when done.

    Ever heard of white space? All I see is a jumble.

    Create a template for my accounting department to use for invoices.

    1. I will have a spot for item description. Use two or more textboxes for this.

    2. And a spot that has a drop-down menu for Quantity (1-100). Pointless use a text box.


    3. A combobox for serialised Yes/N

    On completing each field and if s/n =yes, then I need a box to pop up (name of the box is what was put in the Description field) amount of cells in the box is (amount selected in Quantity drop-down menu.) this will allow accounting to put the proper amount of serial numbers in the field.

    So this sounds like a Listbox.


    4. after Accounting put the s/n's in the field I need an ok button that will auto-populate another tab to store s/n's with the same header and amount of cells as the popup box.



    Ok

    I looked at the attachment. There is no heading that says Description Anywere.
    Last edited by mehmetcik; 06-11-2021 at 12:37 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Need to have a popup form that will auto fill another area when done.

    O.M.G. - please start again - read up on 'why no sane person uses 'merged cells'.'
    Referencing the sheet and its cells is going to be a nightmare.
    If there is only one piece of advice that you follow 'please do not merge cells'


  4. #4
    Registered User
    Join Date
    08-28-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    6

    Re: Need to have a popup form that will auto fill another area when done.

    Quote Originally Posted by torachan View Post
    O.M.G. - please start again - read up on 'why no sane person uses 'merged cells'.'
    Referencing the sheet and its cells is going to be a nightmare.
    If there is only one piece of advice that you follow 'please do not merge cells'
    Thank you for the advice. I will fix this.
    Last edited by Normonious; 06-11-2021 at 01:46 PM.

  5. #5
    Registered User
    Join Date
    08-28-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    6

    Re: Need to have a popup form that will auto fill another area when done.

    Quote Originally Posted by mehmetcik View Post
    Ever heard of white space? All I see is a jumble.

    Create a template for my accounting department to use for invoices.

    1. I will have a spot for item description. Use two or more textboxes for this.

    2. And a spot that has a drop-down menu for Quantity (1-100). Pointless use a text box.


    3. A combobox for serialised Yes/N

    On completing each field and if s/n =yes, then I need a box to pop up (name of the box is what was put in the Description field) amount of cells in the box is (amount selected in Quantity drop-down menu.) this will allow accounting to put the proper amount of serial numbers in the field.

    So this sounds like a Listbox.


    4. after Accounting put the s/n's in the field I need an ok button that will auto-populate another tab to store s/n's with the same header and amount of cells as the popup box.



    Ok

    I looked at the attachment. There is no heading that says Description Anywere.
    okay so several things.

    1. I will space things out for you. Sorry

    2. to your #1. I will, this is just a very quick first rough draft. it will look very different after it is done. this first draft is just to see if everything I need to do can be done.

    3. to your #2: I agree but I have an accountant that likes to put random stuff in random spots and then ***** if it doesn't work so I need to make this as idiot-proof as I can that's why I put the drop-down menu here. it might change later but as I stated in #2 this is just a very rough draft. the entire thing will change later.

    4. to your #3: thank you. a combo box will work better.

    5. to your #4: I apologize. It's not the description field its the Item (brief desc) field.

  6. #6
    Registered User
    Join Date
    08-28-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    6

    Re: Need to have a popup form that will auto fill another area when done.

    so other than fixing what I already had, does anyone have any advice on how I can get this s/n section to work?

+ 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. Form Auto Fill
    By Lukhanyo in forum Excel General
    Replies: 3
    Last Post: 11-02-2020, 08:09 AM
  2. Replies: 3
    Last Post: 01-16-2019, 09:13 PM
  3. Replies: 9
    Last Post: 09-16-2015, 08:45 PM
  4. Auto Fill form data
    By Bufftstar_2001 in forum Excel General
    Replies: 1
    Last Post: 07-07-2015, 01:00 PM
  5. [SOLVED] Auto Fill-out Form
    By [email protected] in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-14-2012, 10:07 AM
  6. Auto Fill Web Form using Excel User Form
    By vandanavai in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2008, 02:26 AM
  7. Auto Fill Form
    By Michael Coffee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2005, 03:49 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