RE: Importing unopened worksheet into an open Workbook

From: Rich <Rich_at_discussions.microsoft.com>
Date: Sat, 1 Jul 2006 11:18:02 -0700

you could just open your new workbook and minmise it

then open each of the other workbooks inturn ,

select the tab with the data in and right click

select move or copy

then move the page into the new book

it is easier that it sounds and keeps the original formating ext ,,, and is less hassel that copying and pasting accross both books

"GrayesGhost" wrote:

> If an unopened Excel Workbook only contains a single worksheet, is it
> possible to import the data from that worksheet into another Workbook that is
> open, without having to open the other file?
Received on Sat Jul 01 2006 - 11:18:02 PDT