Quickly move data to another workbook without copy and paste
- Date: November 4th, 2008
- Author: Mary Ann Richardson
- Category: Microsoft Excel, Tips
- Tags: Data, Mary Ann Richardson, Microsoft Excel, Productivity, Microsoft Office, Office Suites, Software, Figure B Excel
Excel offers a fast, convenient way to transport data from one workbook to another. Here’s a look at this simple technique.
Let’s say you keep all records for your clients for the Philadelphia region in one Excel workbook. The first worksheet lists the company name, address, and contact name and title. The second worksheet keeps a record of the clients’ sales transactions. You would like to use the information in the Excel workbook to send weekly reminders of weekly promotions to your clients. However, you don’t want the marketing staff to work with the same workbook as the sales staff. Using Excel’s worksheet copy/move feature, you can quickly create a workbook that contains only the information needed to address your weekly promotional mailings. Follow these steps:
- Open the workbook containing the customer data.
- Right-click the first worksheet tab.
- Select Move Or Copy from the shortcut menu (Figure A).
Figure A
- Click the To Book drop-down list and select (new book).
- Select the Create A Copy check box (Figure B) and click OK.
Figure B
Excel creates a new workbook (Book1) and copies the data from the first worksheet to Sheet 1 of the new book. Save the new workbook as Mailing Lists.
To add another list of clients from another workbook — say, one containing records on customers from Cherry Hill, NJ — follow these steps:
- Open the Mailing Lists workbook.
- Open the second workbook containing the customer address listing for Cherry Hill on Sheet 1.
- Right-click the Sheet 1 tab.
- Click Move Or Copy from the shortcut menu.
- Click the To Book drop-down list and select Mailing Lists.
- From the Before Sheet list box, select (move to end).
- Select the Create A Copy check box (Figure C) and click OK.
Figure C
Miss an Excel tip?
Check out the Microsoft Excel archive and catch up on other Excel tips.
Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
