Collecting Data from Different Forms/Spreadsheeets

[AlexChatz]

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

 

[konew1]

is all the data on a single sheet in each of the site files, or is it spread over more than one sheet?
Is your audit summary doing calculations based on the site data (example; adding up the total number of units sold) or is it just checking that certain cells have got data entered? or something else?
Do you expect the site files to be updated all the time, so you need you audit summary to update

 

[AlexChatz]

hi konew1

The data i would like the techs to collect is 1 spreadsheet file with 3 tabs worth of stuff (spread over more than one sheet).. i tried to add the file to this thread but couldn't figure that part out...

The Audit summary just need to collect the data and display all one 1 sheet... no calculations necessary. (that i assume can be done later)
Some cells may be empty which is fine just list it as en empty cell..
i will be collecing the file about once a month and happy to file them all in one location (rename them if nessesary) and have the Audit summary spreadsheet do its thing..

Can i email you the spreadsheets i have?

 

[konew1]

Don't send me the file, I don't think I can help you.
There are several addins here http://www.mrexcel.com/forum/excel-questions/628649-recommended-add-ins-links.html
that let you post sections of spreadsheets to the message board

 

[AlexChatz]

so can anyone help?