combine multiple workbooks? overcome 255 character limit?

W

Wayne

I want to combine multiple worksheets from different workbooks into one.
There are text boxes with more than 255 characters that require me to go back
and individually copy all these text boxes...very time consuming. Can I do
it in fewer steps by selecting the workbooks to combine and make one new one?
 
L

Luke M

Why not just select the worksheets you want (You can use SHIFT or CTRL to
select multiple sheets), and then right-click, copy entire worksheet yo your
new workbook. This would transfer the text boxes with the sheets.
 
N

NC

this doesn't overcome the 255 character limit.

Luke M said:
Why not just select the worksheets you want (You can use SHIFT or CTRL to
select multiple sheets), and then right-click, copy entire worksheet yo your
new workbook. This would transfer the text boxes with the sheets.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
Click to expand...
 
L

Luke M

I was able to use this method and copied a text box containg over 3000
characters. (using XL 2003). What error are you encountering?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I merge/combine different workbooks with different sheets 2
Is there a 255 character limit in pivot table cells? 1
Combining data from multiple workbooks 2
how to enter data on multiple workbook at the same time 3
How do I combine multiple worksheets into one worksheet? 1
combine information from multiple file into many different files. 2
Excel Excel VBA Macro to combine multiple workbooks into one 0
Compatibility Mode error w/ Defined Names 1

Top