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!
Hi,
It should be possible with VBA and is quite a popular question if you do a search of the board.
If you don't find the answer you're after post back, preferably with a sample of the worksheets and how you would like the merged file to look.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Ron de Bruin provides multiple solutions to this kind of problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks