LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ray Ray is offline
external usenet poster
 
Posts: 267
Default Merge (not consolidate) workbooks?

Hello -

I'd like to 'merge' two workbooks ( currently used for different
tasks) into one fully-functional workbook. That is, if WB1 handles
tasks 1-4 and WB2 handles tasks 5-9, I want to create WB3 to handle
tasks 1-9! Each workbook contains approx 15-20 tabs, with lots of
formulas and internal links ....

How would you merge these workbooks without manually re-creating all
of the moved tabs? I tried to cut/paste sheets, but the internal
links automatically became external links ..

all ideas are appreciated!

TIA,
ray

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help - need to consolidate workbooks yus786 Excel Worksheet Functions 5 February 13th 12 10:06 AM
Consolidate Several Workbooks into One jeannie v Excel Worksheet Functions 1 August 25th 06 12:18 PM
Consolidate multiple workbooks BillMarshall Excel Worksheet Functions 2 November 26th 05 09:40 AM
consolidate 2 different workbooks JackieB Excel Discussion (Misc queries) 1 July 29th 05 12:02 AM
Consolidate different sheets to different workbooks markx Excel Worksheet Functions 3 April 26th 05 03:30 PM


All times are GMT +1. The time now is 02:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"