I know that MS Forms can use the data to populate an XL spreadsheet to collate and summarise. Unfortunately my company does not allow the use of MS Forms (very frustrating). I have created a form in Word, although I could create it in XL if that is what is required. Is there any way I can take data from the forms and collate automatically within XL...? I honestly do not know where to start or if this is even possible. I would have multiple completed forms as separate workbooks which I would have to align to another spreadsheet, so this would have to be dynamic in a way that I am currently unfamiliar with or even sure whether it is possible. any suggestions or assistance would be gratefully received.
Bookmarks