Drop down lists and multiple worksheet auto update

[Keiralea]

Hello.

Could someone please help me with my spreadsheet? I want it to do 2 things; 1 of which I have managed but now I have an error re my drop down lists.

1. I have a main worksheet, where I enter and update rows. Depending on the answer in Column N, all of the corresponding data in that row is auto updated in the subsequent worksheets. That is perfect and I am happy with it.

2. I would like the main worksheet to have drop down lists to choose from. Normally I have no problem adding these, but when I do, I cannot save it as I receive an error message that states the data validation is refered in other values.

Can someone help me with my objective 2 please? Is there a way I can attach my file?

Many thanks!

 

[andrewkard]

Hello! Can you post a sample of your file somewhere and give us the link?

 

[Keiralea]

Hi Andrewkard,

I can't find how to attach my worksheet, and the FAQs say you can't. The HTML creator is defunct too.
I don't know how to link it elsewhere. Tips?

Thanks,

Hello! Can you post a sample of your file somewhere and give us the link?

 

[andrewkard]

Not here, somewhere in web, fileshare's service