Hi All
I want to send out a spreadsheet to all me techs at different site which they would fill out (identical form). Which then i would collect electronically via email and then save all the excel files in a folder.
IE. Site Audit 1.xlsm Site Audit 2.xlsm etc etc...
I would like to crate an Audit Summary off all the information gathered in the spredsheet that automatically updates with the more spreadsheets i add into the folder....
Can this be done? if so how?
Thanks in Advance!
Alex
I want to send out a spreadsheet to all me techs at different site which they would fill out (identical form). Which then i would collect electronically via email and then save all the excel files in a folder.
IE. Site Audit 1.xlsm Site Audit 2.xlsm etc etc...
I would like to crate an Audit Summary off all the information gathered in the spredsheet that automatically updates with the more spreadsheets i add into the folder....
Can this be done? if so how?
Thanks in Advance!
Alex