| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special problems
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special problems
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special problems
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special problems
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special problems
Hi kristin
See if this add-in is working for you http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "kristin-101" wrote in message ... 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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special problems
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" wrote: Hi kristin See if this add-in is working for you http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "kristin-101" wrote in message ... 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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special problems
You are welcome
Have nice weekend -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "kristin-101" wrote in message ... 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" wrote: Hi kristin See if this add-in is working for you http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "kristin-101" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
| 'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
| In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
| Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions | |||
Hybrid Mode
