Data Pickup from 1Excel Sheet to another sheet

vishesh

New Member
Joined
Jun 26, 2006
Messages
10
I have a querry where I needto pick some data from 1 sheet and put it into another sheet.
For example: Sheet 1 has data as John Smith in 1 coloumn and against this person there are various other datas in seperate coloumns.
Now in Sheet 2 I have just Smith's referance and I want to pick up some data's from sheet 1 related to John Smith.
Kindly help
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,114,385
Messages
5,547,650
Members
410,805
Latest member
Ginoji
Top