Hi there

I am trying to copy about a dozen files into one file.  I highlight the file, CTRL + C, go to the target file CTRL P and nothing happens. (The clipboard is empty it says. Tried again, this time I highlighted the top A1  - now I get a message that I can only paste into the A1 cell. However, when I do this, it will copy on the existing data that I already have and want to save and delete at the same time the existing data! How can I copy into the existing file that already has some data on it?  I was told about the VBA process but it seems to complex to me.  I am comfortable with copy and paste ...  

Please explain step by step,   This Excel 2010

Thanks you.   Gabe


I am assuming that you are wanting to copy data from one sheet to another sheet, or another sheet in another workbook.

The copy paste feature will be the easiest to use rather than writing a macro.

In the sheet that you want to copy from, first paint the data that you want to copy then right click (while your cursor is within the painted section) and select copy from the drop down menu.  Then go to the sheet you want to paste to and click on the cell that is at the top left of the area you want to paste to, then right click and select paste from the drop down menu (or in the alternative you can simply hit enter and the data will be pasted).  Do this with each of the sheets you are copying from and that should do it for you.

FYI you may also have the copy and paste option buttons on your toolbar, if you do then you can use them instead of the right click.  

Hope this helps

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here


All Answers

Answers by Expert:

Ask Experts


Richard Roberts


Can assist you in most areas of Excel, have been working with it for about 15 years in many types of applications, but primarily in financial and accounting applications. I am a CPA and many client or client problems have necessitated the use of excel. I am not an expert in charting, macros, or pivot tables.


Have been working with Excel for about 20 years primarily in accounting and financial areas.

BA, Certified Public Accountant

©2017 About.com. All rights reserved.