order form

  1. B

    Creating a form

    I have a worksheet that has a field allowing for a user to enter a part #. However, I would like for a description of the item to appear in the adjacent cell once the user enters a code. Example of my master list: Part # Description 1 hammer 2 screwdriver 3...
  2. G

    Order form Equation

    Hi First post here so please forgive any errors. I am using Excel 2016 and am creating an order form. I want an Equation that will add up figures in a column if the adjacent two columns meet set criteria. <tbody> 1 A B C 2 Item Size Quantity 3 rugby shirt S 1 4 rugby shirt...
  3. E

    Help with drop down list for an order sheet

    Hi all, Im using excel 2010 with windows 7. I need help with a sheet that I made that is going to be used as an ordering tool for customers. It's very basic; all the possible items that can be ordered are in a searchable drop down list that I made using the combo box and a macro that I found...
  4. P

    V basic sorry - order form that extracts/copies data to simple table on different worksheet

    This is terribly basic so apologies in advance but I've spent three hours researching on the web and my lack of the correct terminology is proving a real hindrance to working out a solution. I'm trying to help modernise a lovely old family microbusiness that currently uses a triplicate hand...
  5. Y

    Order Form with Dependent Data Help Needed!

    Firstly, thank you for the existence of this forum! I am only posting after having exhausted myself in reading about dependent values for drop-down lists, VLOOKUP, HLOOKUP, INDIRECT, etc., and something simply must not be 'gelling' because I cannot seem to get my order form to work right...
  6. A

    Macro to save worksheet as separate file?

    Hey all, What I'm hoping to create is an easier way of our wine bar to check its current inventory against what they should have and ultimately provide a very basic printout which can be e-mailed to our central office and then be printed off over here. The file, due to several macros already...
  7. C

    VBA help for a custom order entry form?

    I am looking for help to create VBA script for an order entry form: We organize a dinner event at our kid’s school. People will place their reservations upfront, so we can better estimate the volume and the type of menu’s that will have to be prepared. Our guests will also asked to pay the...
  8. T

    Order form

    Dear All, This is my first post, and I have read as many existing threads as I can find that might help, but not being particularly Excel savvy, I need some help, please??? I have an Excel workbook (Excel:Mac 2008) with 10 tabs, but only two are important at this stage. The first one is a...

Some videos you may like

This Week's Hot Topics