?
Solved

copying excel worksheets from one file to another

Posted on 2013-01-16
4
Medium Priority
?
475 Views
Last Modified: 2013-01-16
I use ms office excel 2007 and I would like to be able to combine some of my existing worksheets into a single worksheet (Lets call it "A". How do I copy a worksheet from one file onto a page in the worksheet "A" keeping all formatting including height and width, formats, formulas and fonts. I don't want to have to recreate the worksheets.
0
Comment
Question by:PawloA
  • 3
4 Comments
 
LVL 31

Accepted Solution

by:
gowflow earned 2000 total points
ID: 38782766
you want this thru VBA ?

if not VBA then open both workbook go to the one you want to copy click on the sheet you want righclick and choose move or copy tick on copy then in the upper box choose the destination workbook then select where you want the sheet to end click ok and the worksheet has ended in the destination workbook.

gowflow
0
 
LVL 1

Author Comment

by:PawloA
ID: 38782806
I spent some time doing this and to copy a worksheet from one file to "A" you go to the original sheet and rightclick on the sheet name at the bottom of the worksheet and select "Move or Copy" then right click "Create a copy" box otherwise the result will move the file instead of copying it. From the "To Book" choose the file you want to copy it too. In my case it would be "A". and hit "OK" and you are done.
0
 
LVL 1

Author Comment

by:PawloA
ID: 38782814
I've requested that this question be closed as follows:

Accepted answer: 0 points for PawloA's comment #a38782806

for the following reason:

I figured it out before someone commented on here.
0
 
LVL 1

Author Closing Comment

by:PawloA
ID: 38782815
Thanks. It was the same as my solution.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question