Paste Special problems

[kristin-101]

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.

 

[Luke M]

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:

 

[Ron de Bruin]

Hi kristin

See if this add-in is working for you
http://www.rondebruin.nl/merge.htm

 

[kristin-101]

I'm very new with macros. Are there any different ways to solve this problem?

 

[Ron de Bruin]

Try my add-in


--

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

 

[kristin-101]

Thank you so much Ron! Wow, I think you've lifted 1000 pounds off my
shoulders and you made my week! Thank you very much!

 

[Ron de Bruin]

You are welcome

Have nice weekend

--

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