Make a drop down menu in a spreadsheet
Posted: Mon Sep 11, 2017 7:20 pm
Hi Everyone!
I hope you are all safe and not being blown away by hurricanes or flooded.
If you are, our prayers are with you!
I am currently writing an app that collects data and the data is then emailed to the admin.
Once there, it can be imported into Excel or Libre Office.
That is all working fine, hurrah!
I can export the data as a comma separated text file.
This can then be imported easily.
However the admin wants a drop down menu created in the spreadsheet during the import.
Is there a way of doing this from the text file?
Any help would be warmly appreciated as always!
Best wishes,
Jessamy.
I hope you are all safe and not being blown away by hurricanes or flooded.
If you are, our prayers are with you!
I am currently writing an app that collects data and the data is then emailed to the admin.
Once there, it can be imported into Excel or Libre Office.
That is all working fine, hurrah!
I can export the data as a comma separated text file.
This can then be imported easily.
However the admin wants a drop down menu created in the spreadsheet during the import.
Is there a way of doing this from the text file?
Any help would be warmly appreciated as always!
Best wishes,
Jessamy.