Merge multiple spreadsheets into one?

[jjmiller]

I have an Excel question I need help with. I have a spreadsheet that I’d like to send out to multiple people, have them fill in some information, and email it back to me. When I get it back I’d like to have all of them merge into the same spreadsheet without the need to manually copy & paste. We don't have access to a shared drive or any type of file sharing environment.

Is this possible? I’m running Excel 2003.

Thanks!

 

[VoG]

See if this helps http://msdn.microsoft.com/en-us/library/cc837974.aspx

 

[MrKowz]

Welcome to the forums!

Yes, it is possible. However, the approach (and code) is largely based on how the data looks (what columns are being filled).