Forum Home
Press F1
Thread ID: 131264	2013-04-30 08:13:00	Spreadsheets with dropdowns and ranges - help	Morgenmuffel (187)	Press F1

Post ID	Timestamp	Content	User
1339055	2013-04-30 08:13:00	Ok I have inherited a spreadsheet to look after, Basically i use the first sheet to log incoming stock, it has a few dropdowns on it eg supplier and when i have selected supplier the cell next to it becomes a dropdown containing products from that supplier. The information for the dropdowns comes from the second sheet of the spreadsheet Basically overtime Stock has been added, but no new suppliers have, so all the stock has been added under one supplier, I would like to fix this, but i can't figure out how to add a new supplier so that it appears in the dropdown well ok if i insert the new supplier between to existing suppliers then yes i can get it to appear. I also cant work out how to add stock and have it appear for that supplier. I would also like to be able to see the extent of the range for each supplier and edit it, to move out stock that doesn't belong to that supplier. My main issue is i can't see how the stock is connected to the suppliers, i can't seem to visually see the information that tells me what the range is anywhere	Morgenmuffel (187)
1339056	2013-04-30 09:07:00	Okay "Name Manager" shows me the ranges for each name. I think I'm getting there, awesome when you figure out the correct button	Morgenmuffel (187)
1