In excel, if I have blank cells in a particular column of a table, can I then include the whole row with the blank cell in a separate sheet?

Question

**See image for a screen shot of the spreadsheet

I am looking to create a separate sheet in the same workbook that only contains orders without invoices. In my invoice column some cells have invoice numbers and some do not. I want to show ship tickets without invoices.

Answer 1

Hi @Amy Alksnis

You may try Excel Power Query.

• Select the data range > Data tab > Get & Transform Data group > From Table/Range.
• Set the filter for 'Invoice Number', select 'null'.
• Click 'Close & Load', the results will load a separate sheet in this workbook.
• Once there is the change for Invoice Number, you may click Data tab > Queries & Connections > Refresh All.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---

Answer 2

It is pretty simple to do manually:

• Select the entire region containing your data.
• Sort the selection using the invoice column.
• The rows without invoices will appear at the top or bottom of the selection.
• Select the rows of without invoices.
• Ctrl-C to copy.
• Ctrl-V to paste into the new worksheet.
• If desired, select the entire region and sort on ship ticket to restore the display.

If this is something you need to repeatedly, record a macro performing these steps.