Hi Experts:
I have 2 excel tabs. They have similar data. In both tabs there is a reference number. I want to merge data from both tabs into tabOutput so that data from both tabs is matched with the reference number.
Therefore I want that in the merged tab there is 1 row with combined data from sheet A + data from sheet B.
This will be a live document. Every week we will add new rows to the tab A and B. So the formula has to be set up this way that the merged tab Output will refresh each time we add new data.
Thanks in Advance.
gul
Bookmarks