I have a list with two columns. Column A contains names, which are also
sheets in the same book. Each name has it’s own sheet. The name also
appears in cell A2 of each sheet.

If A2 of each sheet equals a name in Column A I want the info from the
corresponding row of Column B to be pasted in the sheet with the same
name in cell B2.

Example


Sheet 1 – A1=Billy B1=10
A2=Mary B2=15
A3=Chester B3=6

Sheet Billy – A2=Billy B2=15
Sheet Mary – A2=Mary B2=15
Sheet Chester – A2=Chester B2=6

I want the values for B2 auto populated from Sheet 1.

I guess what I want is for the program to search column A of sheet1
until it finds a match, then put the info from columnB in B2 of that
sheet, then proceed to the next sheet.


--
mehare
------------------------------------------------------------------------
mehare's Profile: http://www.excelforum.com/member.php...o&userid=37483
View this thread: http://www.excelforum.com/showthread...hreadid=573067