Do you want to bring whole sheets from other files into one file? Or do you
want to copy the contents of the sheets into one sheet on the one file? HTH
Otto
Are the files in the same format - i.e. do the hold the same fields in
the same order, or do they contain different information - is there a
field that could function as a key such as customer number or something
like that?
If there are sheets that you want in File A, but they are in File B,
try this:
Open both files.
Select all the sheets that are File B (hold down the Ctrl key while
selecting the tabs) then right click and select 'Move or copy'...select
File A in the To book: dropdown.
If you have Create a Copy checked off at the bottom, it will copy those
sheets you selected. If Create a Copy is NOT checked off at the bottom
of the dialog box, it will MOVE the sheets you selected to File A from
file B.
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.
