Drop Down menus
I hope someone can help me with this.
I have a spreadsheet that I have been working on and it has drop down menus. There are three drops down menus in consequent order in three differents row with rows in between them. I needed to ad more rows that were formatted like these so I just copy and pasted them below the ones that were currently there. There is a certain point on my spreadsheet that when I choose the drop down menu to select the item I want, the others below automatically set to like the one I am choosing working with above. Does anyone know what I am doing wrong? Please help. Thanks, |
Drop Down menus
How did you create the original drop-downs? Was it by using Data Validation
within a cell, or by setting up a drop-down control from one of the toolboxes? If from one of the toolboxes, I suspect that the linked cell recording the selection made from the drop-down is remaining the same, so when you choose from one of the drop-downs sharing a single 'record my change' address, all that share that address now reflect the latest change made. Right click one of the drop-down controls and choose: (for controls created from the Controls Toolbox) [Properties] (for controls created from the Forms tools) [Format Control] In either case, once the next window opens, look for a value named LinkedCell or "Cell Link". That address should be different for each of your drop down controls. If there's no entry for the value (LinkedCell/Cell Link), then I've guessed wrong and we must look further. "Sonnie3015" wrote: I hope someone can help me with this. I have a spreadsheet that I have been working on and it has drop down menus. There are three drops down menus in consequent order in three differents row with rows in between them. I needed to ad more rows that were formatted like these so I just copy and pasted them below the ones that were currently there. There is a certain point on my spreadsheet that when I choose the drop down menu to select the item I want, the others below automatically set to like the one I am choosing working with above. Does anyone know what I am doing wrong? Please help. Thanks, |
All times are GMT +1. The time now is 05:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com