Import score from one worksheet into another worksheet

O

Oldie

New Member
Joined
Jul 31, 2007
Messages
9
I have worksheet one with names in Column A and a score in column B.
A1 Jones B1 252
A2 Smith B2 199 etc.
I want the persons scores to be input to cells in say column E on worksheet two if their names happen to be displayed in column A of worksheet two.
Worksheet two's names will be changed every time I import data.
Thanks again people.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
You must log in or register to reply here.

Similar threads

D
  • Question
VBA for Copying & pasting (with resizing) Named ranges from one workbook to another
Replies
3
Views
169
doctorhifi
D
P
  • Solved
Cell Name change based on another cell BG Colour
2 3
Replies
20
Views
568
PeterOz
P
K
  • Question
Copying data from one table into another worksheet
Replies
2
Views
307
Herakles
H
cyrilbrd
  • Question
VBA display pictures in a table
Replies
2
Views
204
cyrilbrd
cyrilbrd
I
  • Question
Send worksheet values to another worksheet
Replies
3
Views
191
ipbr21054
I

Forum statistics

Threads
1,207,094
Messages
6,076,549
Members
446,212
Latest member
KJAYPAL200

Share this page

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