Hello again expert!
I was hoping someone could help me out. I have attached a simple lay-out of what am trying to do....
In sheet 1
Filter Cell Y and select OPEN
Filter Cell P and select TBA
Then get the BUYER in Sheet 1 (cell B) and LINK To Sheet 2 Cell A
Then get the TOF NO. in Sheet 1 (Cell A) and LINK To Sheet 2 Cell B
Then get the DATE in Sheet 1 (Cell C) and LINK To Sheet 2 Cell C
Please help to provide the best formula. Thanks
Bookmarks