I have a list with two columns. Column A contains names, which are also sheets in the same book. Each name has its 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.
Bookmarks