Forum Discussion
Forms Questions Pulling Data From Excel
Hi everyone,
I wonder if you can help me! I'm trying to setup an operational process between a requisitions form and a stock control excel spreadsheet.
The excel spreadsheet lists all of our stock, broken down via mac address for each device (IP phones, modems, networking equipment, etc.). This spreadsheet already automatically tracks stock levels, as well as a few other things.
I would like to setup a Form my team can fill in remotely where they can select specific devices for the warehousing team to then set aside for programing. This would automatically remove that device from the spreadsheet to more efficiently track stock levels.
Is there a way to link a Microsoft From and Excel spreadsheet to accomplish this? If not, is there another way to accomplish the same goal?
Thanks!