Poppinjay

I have to keep a listing of companies that are exhibiting at a conference. I have the initial excel file of the first responders. For the next few months, I'll be receiving additional listings of 2-20 more responders in excel files. These need to be added to the original file, in alphabetical order. Is there anyway other than cutting and pasting each individual listing to merge these seperate workbooks?

__________________
I think the Apocalypse is happening all around us. We go on eating desserts and watching TV. I know I do. I wish we were more capable of sustained passion and sustained resistance. We should be screaming and what we do is gossip. -Lydia Millet

alpha phi

I don't know alot about excel
But here is what I found
Hope this is helpful
How to Merge Workbooks in Excel

Microsoft Corporation

__________________

Jinn

As far as I've seen, Microsoft's "share and merge" system is just a glorified copy and paste with a few more steps. If you were getting all of the spreadsheets at once, you could try it.. make all the new ones shared, and merge them into the old one. However, since they're coming in sporatically, you're probably better off just pasting it to the end of the old workbook and resorting them.

__________________
"I'm typing on a computer of science, which is being sent by science wires to a little science server where you can access it. I'm not typing on a computer of philosophy or religion or whatever other thing you think can be used to understand the universe because they're a poor substitute in the role of understanding the universe which exists independent from ourselves." - Willravel