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.