Hi,
Please advise on VBA code for the following, I've had trouble finding similar threads...
Sheet1
Column A = Acquisition Date (A1 = "Acquisition Date" Header)
Column B = Buyer Name (B1 = "Buyers" Header)
Column C = Seller Name (C1 = "Sellers" Header)
Sheet2
Cell A1 = "Linn Energy" (this cell is a variable where the user can input a buyer or seller name manually)
The VBA macro will find the all the rows where either Sheet1.ColumnB = Sheet2.A1 or Sheet1.ColumnC = Sheet2.A1 and then paste those rows into Sheet2 starting in row 3 (2 rows underneath the input Cell A1)
It is essentially filtering the table in Sheet1 and outputing the matching rows into Sheet2
Appreciate any guidance. Thanks
Bookmarks