Code/Formula to copy data from one table to another on same worksheet

[hmltnangel]

Hello,

I need some help please with creating some sort of formula or code. I need to move data on my worksheet from one table to another, depending on certain conditions.

The data I input each day is in a small table covering B4:G300.

In the table, column E contains either "1" or "0". If column E has a "1" I want columns B:G of that row transferred to the another table in the same sheet spanning I4:N300. Basically it is looking for discrepancies in the data (identified by the "1" in column "e) and I want it to show the discrepancies on a new table just next to the original data.

All the column headers are the same on each table.

Thanks!

 

[SteveO59L]

in i4 and filled to n4, then filled down to row 300

=if($e4=1,b4,"")

 

[hmltnangel]

Thanks - that kinda works. It just copies it into the same location on the second table. Is there a way for it to bin the blanks? For instance - only around 6/7 rows will be a match in this situation and its only those I need to move into the second table. Id rather they were all bunched in one group at th etop instead of spread over 300+ rows.