I have a spread sheet that I have 2 drop down sets. once I get the results from both sets of drop downs I then need to update the values on the 2 items.
drop down 1 (a1) drop down 2 (b1) result1 (c1) (c1) = data in sheet2 column3 row x column 1 and 2 are for the drop downs. I would like to either enter a new value in (c1) or if that cant be done new result goes in (d1) and then make a button or something in f1 that can cause the new value in D1 to be updated in shee2 where (c1) was pointing to.
either i am searching with the wrong terms or something as I can't find any suggestions on how to do so from google.
Update: Switch and port would be dropdowns old/current cube would be retrieved data new cube would be the editable field and would put data in the current cube's source cell. old cube's source cell would be emptied.
Switch Port Old Cube Switch Port Current New cube Vlan 1stwest 2 b 1steast 1 x 2114 15 [ Update ]
switch port cube vlan ..... 1stwest 1 a 1stwest 2 b 1steast 1 x 1steast 2 y
I am still in the development stage on how I want to arrange all these things. I was planning on having the 1st sheet have the update button and a clickable network diagram. if you clicked on each switch picture it would take you to the sheet that is related to that switch. the first 4 to 40 lines would be a mock up of the switch ports that would use vlan column for conditional formatting and cube for labeling.
for the drop downs it would be nice to have switch drop down select data of sheet .... and then port vlan etc be used from which ever sheet was selected in the switch section. I am also not opposed to making the last sheet data only with column A being the switch B being the port C being cube D being vlan etc. and then using the specific switch sheets to pull data from that master list page.