Formula to copy paste values from one sheet to another based on cell value
I need help with the following. I need a way to find only rows that match a value in a cell on another sheet then copy all the matching rows and columns with the matching value to another sheet. Thanks in advance.
If Sheet1 value in B2 = Sheet2 value in A5:D1000 then
copy all rows and columns to Sheet3
and if Sheet1 value not on Sheet2 do a search n Sheet4 and copy those values...