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 :-)

[Pepe Le Mokko]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you this time.)

[AliGW]

It seems to me that a formula will not do what you want. I think you will need a VBA solution. Shall I move the thread for you?

[Kev1311]

Apologies - feel free to move and I will edit my post :-)

[AliGW]

Thread has been moved and I already updated the thread title for you so that you know what we expect for the future.