Try my add-in


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"kristin-101" wrote in message ...
I'm very new with macros. Are there any different ways to solve this problem?

"Luke M" wrote:

You might want to take a look at this artice by Ron de Bruin on creating
summary workbooks.

http://msdn.microsoft.com/en-us/library/cc837974.aspx

Ron's site:
www.rondebruin.nl
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"kristin-101" wrote:

So I've got 11 workbooks with thousands of entries and I'm trying to combine
them all into one Master Workbook. Initially, I went to each sheet,
highlighted, copied, and then went into my master pressed paste special and a
menu like this: http://i40.tinypic.com/15rjli0.jpg (I need to choose text
because I have a bunch of macros behind my text and I can't let it be
formatted) Let's call it menu 1.
I did a whole book with that menu 1, now when I paste special a menu like
this:
http://i39.tinypic.com/66x4le.jpg Menu2 pops up, and it doesn't have the
option to paste special text like I need. I found out that if you copy
outside of Excel that it will go straight to your windows clipboard (which
leads me to menu 1) but I need to copy from Excel and it only takes me to
office clipboard and won't work.