I have 2 sheets
- Data sheet
- Invoice sheet I want to copy date, invoice No and value mentioned in three columns of data sheet to invoice sheet based on these conditions: a. Vendor name in cell B1 of invoice sheet b. Start and end dates in cell D1 & F1 c. When invoice value is greater then 0 I have tried a code as shown in the shared sheet but with no success here is the link to sheet
https://docs.google.com/spreadsheets/d/1mS482lNWX4fG-5RX1yaZxxp17gvxt56vE3DXtPdk56U/edit?usp=sharing