Hi!
I've created a sheet that will be used by our company for creating requests for purchase orders. Some of the information required to be chosen via a drop down list will need to be updated periodically. I would like to update the information, without having to always send a new form out. I know I can pull the information form another Excel workbook, but I believe that if an employee is not on the network or does not have access to where the external workbook is saved, the data won't pull in. I was wondering if it's possible to create a Google spreadsheet, have that updated and if the data would update automatically if connected to the internet?
TIA!
I've created a sheet that will be used by our company for creating requests for purchase orders. Some of the information required to be chosen via a drop down list will need to be updated periodically. I would like to update the information, without having to always send a new form out. I know I can pull the information form another Excel workbook, but I believe that if an employee is not on the network or does not have access to where the external workbook is saved, the data won't pull in. I was wondering if it's possible to create a Google spreadsheet, have that updated and if the data would update automatically if connected to the internet?
TIA!
