Feb 16 2019 10:36 AM
I want a workbook that multiple people can use at the same time and update where every entry is saved to the next available row and no data is over typed. I have seen this before and believe some macros may be involved but I have no idea how to go about it myself. Any suggestions welcome. Thanks
Feb 16 2019 11:34 PM
Feb 17 2019 08:37 AM
The easiest way to do this is with Microsoft Forms in an Office 365 business environment. You set up the form to ask the questions as to what goes in each field. Multiple users can fill out the form simultaneously and it will populate your Excel file one record at a time and prevent any overlap. The users won't edit or open the file in Excel. Just you would to get the data out, or you could connect to it from another Excel or Power BI file via Power Query. Just point it to that table in that file. In that event, no one opens the file in Excel. It is just a database.
Sep 12 2019 01:27 PM
@silina Use the Forms app in your Office 365 subscription. https://forms.office.com