Copy data from two different sheets

spycein

Board Regular
Joined
Mar 8, 2014
Messages
135
Office Version
  1. 365
Platform
  1. Windows
Hello Everyone,
I have two sheets with follow data:
Sheet 1
SR. NoData
1A
2B
3C
4D
5E
6F
7G
8H


Sheet 2
SL. NoData
1100
2200
3300
4400
5500
6600
7700
8800


I am looking for a formula/way to copy data from above sheets to a third sheet in following format

Sheet 3
Data
A
100
B
200
C
300
D
400
E
500
F
600
G
700
H
800

I also want to make the process as reference error proof, i.e. if i delete any row in sheet 1 or Sheet 2 then the results in Sheet 3 should not give #REF! error.

Hope i explained my query properly.
Thanks in advance.
Best Regards,
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Forum statistics

Threads
1,215,528
Messages
6,125,342
Members
449,218
Latest member
Excel Master

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top