View Full Version : Spreadsheets with dropdowns and ranges - help

30-04-2013, 08:13 PM
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

30-04-2013, 09:07 PM
Okay "Name Manager" shows me the ranges for each name.

I think I'm getting there, awesome when you figure out the correct button