Hi All !
four days I worked to my spreadsheet,now, I am only one step before the end. And how it is, I have problem
I created dependent drop down lists containing unique distinct values in spreedsheet according to the instructions ( Create dependent drop down lists containing unique distinct values in excel | Get Digital Help - Microsoft Excel resource ) , everything works like in excel.
Only one thing doesn't work Application function to the next rows.. I tried use timestamp, but without successful, maybe I used wrong it.
When I look at the instructions, they use next instructions for it (Create dependent drop down lists containing unique distinct values in multiple rows | Get Digital Help - Microsoft Excel resource), but they using VBA....I know, exist google scripts... but I can't use them
Have you anyone some solutions for it?? if yes, then I thank you very much!!
There is my test spreedsheet:
https://docs.google.com/spreadsheet/ccc?key=0Asiaoa2t4PpGdGJDWk5wSE43LVdyTXJHU3R0SHdkY0E
Please take the copy to your Google Docs.
Thank you for advice!!
Note:
If it possible list without items #N/A I will be happy !!
four days I worked to my spreadsheet,now, I am only one step before the end. And how it is, I have problem
I created dependent drop down lists containing unique distinct values in spreedsheet according to the instructions ( Create dependent drop down lists containing unique distinct values in excel | Get Digital Help - Microsoft Excel resource ) , everything works like in excel.
Only one thing doesn't work
Application function to the next rows.. I tried use timestamp, but without successful, maybe I used wrong it.When I look at the instructions, they use next instructions for it (Create dependent drop down lists containing unique distinct values in multiple rows | Get Digital Help - Microsoft Excel resource), but they using VBA....I know, exist google scripts... but I can't use them
Have you anyone some solutions for it?? if yes, then I thank you very much!!
There is my test spreedsheet:
https://docs.google.com/spreadsheet/ccc?key=0Asiaoa2t4PpGdGJDWk5wSE43LVdyTXJHU3R0SHdkY0E
Please take the copy to your Google Docs.
Thank you for advice!!
Note:
If it possible list without items #N/A I will be happy !!
Last edited:
