View Single Post
 
Old 02-03-2015, 01:33 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by excerbated123 View Post
1. The tax rate does need to be on sheet 1 as later I will add tables to enter customer information and the tax rate changes depending on their location
OK. So if that's the case, just have any equations look the rate up based on the customer information from a table rather than you having to do it yourself. Up to you. If that's something you would like done, let me know.

Quote:
I would however like to be able to type in the box and have it match up to a selection without having to scroll down and click it.
Unfortunately, it is not possible to do everything you want with a simple data validation drop down. It will select the first item on the list that has the same first characters that you type e.g. Apple from AP. But not elsewise e.g. Apple from PL.

It may be possible using form controls (I doubt it). However, it may lead to problems nesting the dropdowns (i.e. populating one based on the value of another). I have never used nested form controls. I just briefly tried to do it and it didn't work.

Quote:
I want to be able to create an entry, and then the next row automatically populates. If I don't use the row, I don't want anything to be there, and I want the grand total bar to automatically adjust to be 2 rows down from the last entry
This will require code in Excel.

Quote:
You've pretty much got what I'm trying to do, that's awesome man. Again, thanks so much for your help. I'd love to know how you went about doing it.
My pleasure.

This will show you how to make the nested data validation, including how to add spaces to your categories.

This will explain the VLOOKUP.

I don't think it was any more complicated than that. If you need any further help or explanation, feel free to PM me or respond here. Cheers!
Reply With Quote