Deleting blank rows in a table that occur from an IF function

[maywal]

I have two tables in separate tabs.

The first holds all information about my projects with a column with a yes/no option. Those that fulfil the yes criteria are fed into my second table via an IF formula. However, this means that those that ='no' show but as blank cells.

Is there a way of transferring over the data I need whilst ignoring the blanks? Or perhaps something I can do afterwards to delete the blanks as new data is filtered in?

Thanks

[protonLeah]

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

[maywal]

I have attached an example but not the actual.

[JeteMc]

Try the following:
1) Select Sheet2!C3,
2) Paste the following formula into the formula bar:

Please Login or Register  to view this content.

3) Double click the fill handle to copy down to C29,
4) With the range C3:C29 still selected, pull the fill handle of C29 across to E29.
Let us know if you have any questions.

[maywal]

Thank you, this works in my example sheet. However my actual sheet has tables starting in A7. Could you advise on how to edit the formula to suit as I can't seem to get it to work.

[maywal]

It is working now. Thank you.

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.