Solved copying sets of data in xcel from one spreadsheet to another

October 10, 2012 at 03:32:08
Specs: Windows 7
How can I copy groups of data from one spreadsheet to another when the cells are split up? Is there a way to ensure that data from certain columns are matched and correctly placed into a different spreadsheet?

See More: copying sets of data in xcel from one spreadsheet to another

Report •

October 10, 2012 at 07:06:40
✔ Best Answer
You can do it using the Clipboard.

This may sound a bit complicated at first,
but once you see how it works you'll find it
very easy.

On the Ribbon, Select the Home Tab

Look carefully at the lower right corner of the Home Tab,
to the right of the word Clipboard, there is a small box with
an arrow.

If you mouse over this box, a popup window showing the Clipboard
should appear.

Click this small box, and the Clipboard Pane should appear on the left
of your sheet.

Now select your first range of cells and press CTRL-C
the range of cells should appear in the Clipboard Pane.

Next select your second range of cells and press CTRL-C
and your second range should appear below the first set.

Repeat as many time as needed.

Now go to your new spreadsheet,
Select where you want to Paste your First selection
In the Clipboard Pane, if you mouse over your first selection
there will be a drop box on the right side, select the drop box
and select Paste, and your first selection will be pasted to
your location.

Now select a new location for you second selection,
and repeat.


Report •
Related Solutions

Ask Question