How to move data from one sheet to another?

This post will explain you how to move data from one sheet to another if your copy and paste function is not working properly. The two methods shown here will use a quick formula that you can use to present data in the same MS Excel file.

Move Data from One Sheet to Another

For each illustration, just think that we have two sheets such as Sheet 1 and Sheet 2 and we would like to move from cell A1 of Sheet 1 to cell B1 of Sheet 2.
Using the + Symbol in Excel Sheet
Initiate by taking the target cell (in our case B1 of Sheet 2) and writing in the + sign.

After that, right-click on the Sheet 1 label button to return to your data. Take cell A1 and then hit the Enter button.

Your data will be involuntarily copied into cell B1.

If you have executed the operation properly, then upon choosing cell A1, you should have the subsequent formula shown in the formula bar: +Sheet1!A1.

Using the +Sheet(X)!((XY) Formula

The next method will use the +Sheet(X)!(XY) formula

Take the cell in which you would like to exchange the data and type the formula +Sheet(X)!(XY)  into the formula bar.

Through the above conditions, the formula +Sheet2!B21 will duplicate data from cell B21 of Sheet 2.

In this,  X stands for sheet label; and XY stands for the intended cell coordinates.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s