Dropdown - list of inventory items based on a sale date

[RickG75]

Hi All,

I am able to create a dropdown to select inventory items.

I would like to be able to limit the items in the dropdown list by a sale date indicated on the invoice.

Is this possible?

Link spreadsheet:

Dropbox - File Deleted - Simplify your life

www.dropbox.com

Thanks,

Rick

 

[Peter_SSs]

This is perfect! Exactly what I was hoping for.

Cheers. Glad it helped.

I would like to make A14 on the Invoice tab a dropdown from the Sale Date from the Inventory tab. Is there a way remove the duplicate dates from the A14 dropdown?

Sure.
Say use column K on the invoice tab.
Format column K with the date format you want

RickG75.xlsx
	A	B	C	D	E	F	G	H	I	J	K
13	Date:
14	08/24/20
15	Invoice No:
16	327000
17	Name:
18
19	Address:		Phone:
20
21	City, State, Zip:		Email:
22
23
24	Item #	Description	UOM	Qty	Unit Price	Total Price
25	1		Ea							Hoops - Green	08/24/20
26	2		Ea							Diamond Stud	08/31/20
27	3		Ea							Necklace - Blue
28	4		Ea							Leather Belt - Black
29	5		Ea
30	6		Ea
31	7		Ea
32	8		Ea
33	9		Ea
34	10		Ea
Invoice

Cell Formulas
Range	Formula
J25:J28	J25	=FILTER(Inventory[Item],Inventory[Sale Date]=A14)
K25:K26	K25	=SORT(UNIQUE(Inventory[Sale Date]))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
B25:B34	List	=J$25#
A14	List	=K$25#

 

[RickG75]

Hi Peter,

Again, perfect and what I was hoping for.

There are some other features of this application I would like your help with but I don't want to wear out my welcome.

Should I post the new items on the board?

Thanks,

Rick

 

[Peter_SSs]

Again, perfect and what I was hoping for.

No problem.

Should I post the new items on the board?

Yes, just post specific questions in the forum.

If they are closely related to these ones you can continue in this thread.

Otherwise start a new thread for new topics. You can always provide a link to this thread if there is some relationship to this one and you think it beneficial for potential helpers to know about this one.