If E4 = Y Copy Data from Sheet 2 to Sheet 3

[Kev1311]

Hi all, really could do with some help on how to do the following (if at all possible)...


I have an excel book with multiple sheets (attached).

The first sheet shows what we are required to produce on a project. Based on what is required (by adding a Y into a cell) I want to generate a list of drawing numbers and titles on another sheet. This will then feed into another bit of software called Autodesk Dynamo, which will generate sheets within our design package (that bit I have worked out how to do). The full list of drawings are on sheet 2 but I only want a list of drawings that are actually selected on sheet 1 (with a Y) to appear on sheet 3.

Sheet 3 is what Dynamo will be reading.

I was thinking of using the IF function. Such as.... IF "Sheet 1 Cell A1" contains "Y" Copy line "Sheet 2 Line A" to "Line 1 Sheet 3". Obviously that's not the code but hopefully it simplifies what I am trying to achieve. I have a feeling I am over thinking this and there may be another simpler way?!

Thank you in advance :-)