Scenario:
Within same workbook, two tabs of data that need to be extracted to a third tab.
Tab 3 - Master file 35K rows
Tab 2 - Will very monthly
Tab 1 - end result
What I would like to do is:
Using Tab 2, compare to Tab 3 master, if column B is equal in both tabs, then I would like to see in Tab 1 would be data from Tab 2, and one column from Tab 3
Column A, B, C, E & F from tab 2 and column K from Tab 2
End result will look like this:
Customer #, Part#, Qty, Invoice Price, Invoice #, Invoice date
Column A, Column B, Column C, Column K, Column E, Column F
I need this to be set up in a way that someone not too familiar with Excel can simply drop in the information to Tab 2 and let the function do it's thing to create Tab 1.
Within same workbook, two tabs of data that need to be extracted to a third tab.
Tab 3 - Master file 35K rows
Tab 2 - Will very monthly
Tab 1 - end result
What I would like to do is:
Using Tab 2, compare to Tab 3 master, if column B is equal in both tabs, then I would like to see in Tab 1 would be data from Tab 2, and one column from Tab 3
Column A, B, C, E & F from tab 2 and column K from Tab 2
End result will look like this:
Customer #, Part#, Qty, Invoice Price, Invoice #, Invoice date
Column A, Column B, Column C, Column K, Column E, Column F
I need this to be set up in a way that someone not too familiar with Excel can simply drop in the information to Tab 2 and let the function do it's thing to create Tab 1.
