"He who marches out of step hears another drum." ~ Ken Kesey
I've done a similar thing before, in FileMaker. I roughed it all out first on paper, then started building... you just have to carefully think it through. And, to play the flute, just blow in this end, and move your fingers on the other...Steve
I am in the process of creating a master order sheet for a large city fire department. It is very complex with dozens of different items and sizes, and specific titles involved. My goal is to have a main sheet that the person in charge in can add the persons name and select each item and size, from there everything is tallied with formulas so on a separate page item sizes are tallied and that can be sent to us. In the past we were always given hundreds of individual hand written sheets for each person and it never ended well. We have requested they come up with a better system for us. The task has fallen on me naturally. This is all fine I am pretty good with excel and a lot of the formulas but i am self taught.There is one thing holding me up right now, when a fire fighter, paramedic, battalion chief, LT, etc. etc. orders a T-shirt the back of that shirts has their title. I need to tally up each of these titles, so is there a way to add a selection type button or radio button in excel that the person doing all the inputting can simply select. Simply put, person types in persons name in the first field, next field is union tees which has a list of sizes. Person puts a qty in the correct size. Next field (fields) is the titles which the person has to select the correct one. Not only do I need that added to the tally sheet but also correlated to the size the person chose. This way when the tally is submitted to us The list will be for example: Navy Union Firefighter xl 57 L 30 2X 32 etc.Does any of this make sense? God I hope so.
Quote from: Sbrem on February 04, 2014, 04:10:00 PMI've done a similar thing before, in FileMaker. I roughed it all out first on paper, then started building... you just have to carefully think it through. And, to play the flute, just blow in this end, and move your fingers on the other...SteveBut is there a way to add in a selection box that is added to a total on a different page? Obviously it would require a macro of some sort and,that is where I fail miserably with excel. I have all the page layouts roughed in. All items are roughed in and the easier formulations are done. It's just these last couple of hurdles that are slowing me down.
What about a form on google docs that would be crazy simple to build, you could save each form and have a separate tally sheet, best of all you just supply the customer with the drive link and when they are done you pull it up and your doneSent from my iPad using Tapatalk
See if this gets you started. I use Open Office but it should work in Excel.order form testThere are 2 sheets. The Order Form sheet is where the custy enters the info. The Items sheet is for you to add your item details and get a count. Let me know if you need assistance in setting it for your use.