Hi Gebos.
To answer a few items here. There is nothing special about the data or position.
The second sheet does have colums next to colum B or other information. What identifies the record on the second sheet is the exact same text as in the first sheet.
eg apples on the first sheet and many apples on the second sheet. But besides apples on the second sheet there is other information. But the important thing here is to ignore that, just so long as when i click on the first sheet say in the apples cell it will do a search for apples on the second sheet. thats all. I'll try to insert an image to show. ok i uploaded, but who knows where it went. If you see the pic, if i click on oranges in sheet one, i want it then go to sheet two to the first occurrence of oranges it finds which is sheet2 B14
|