Forum Discussion
Linking excel and power point in shared environment
I need some advice / guidance Currently i am managing COVID-19 Data in my Region / State in Excel and Power Point files. I receive different data in form of Excel tables / Power Point files, which ca...
Hi saddi2u,
as suggested my mathetes try using Microsoft Forms or google from to collect the data with your selected data-point, this will ease your data entry and your can quickly analyze the data.
Microsoft Forms are best to collect the data.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.
About forms, I currently struggling with following issues:
1. I need my form to be filled by authorised user and not anyone else
2. Since my Table has date column, i want my user to avoid duplicate date entries. For one day, only one record (or Row) is enough. And once the user updates / enteres a record, he / she should be able to modify it at any point in time using "search Date" field.
3. My Table has some Colums that has formula field, so i don't want all of my columns to be filled through Form. I only need selected columns to be filled by user through from.
Your valuable suggestions are appreciated.
Here's the link of Google sheet
https://docs.google.com/spreadsheets/d/1az3WHu2SBwdcfe73HR67WXrh8gW18JduBYc2lt_8H2s/edit?usp=drivesdk
1. I need my form to be filled by authorised user and not anyone else
2. Since my Table has date column, i want my user to avoid duplicate date entries. For one day, only one record (or Row) is enough. And once the user updates / enteres a record, he / she should be able to modify it at any point in time using "search Date" field.
3. My Table has some Colums that has formula field, so i don't want all of my columns to be filled through Form. I only need selected columns to be filled by user through from.
Your valuable suggestions are appreciated.
Here's the link of Google sheet
https://docs.google.com/spreadsheets/d/1az3WHu2SBwdcfe73HR67WXrh8gW18JduBYc2lt_8H2s/edit?usp=drivesdk