Hi,

I have a following problem:

In Sheet1 employees copy/paste some data about customers.

They always have same 5 rows and are always copies in column A (see photo below):

There can be thousands of rows because they keep adding each day new data.

I need to create a formula in Sheet2 to copy/paste all this data (using formula, not actually copy/pasting) into a table which is more easier to filter data in.

Example how I want it to look like:

so,

I want it all copied like this and avoid blank rows.

I tried using this formula for A2 in Sheet2 (and similar for B2,C2….) , but I am not sure how to skip the cell if it doesn’t match the criteria, so it ends up looking like this: =IF(COUNTIF(Sheet1!$A2,”*E-mail*”),Sheet1!$A2,””)

Any idea how to do this using a formula or is VBA needed here?

Thanks in advance!

​Hi, I have a following problem: In Sheet1 employees copy/paste some data about customers.They always have same 5 rows and are always copies in column A (see photo below): There can be thousands of rows because they keep adding each day new data. I need to create a formula in Sheet2 to copy/paste all this data (using formula, not actually copy/pasting) into a table which is more easier to filter data in.Example how I want it to look like: so,I want it all copied like this and avoid blank rows.I tried using this formula for A2 in Sheet2 (and similar for B2,C2….) , but I am not sure how to skip the cell if it doesn’t match the criteria, so it ends up looking like this: =IF(COUNTIF(Sheet1!$A2,”*E-mail*”),Sheet1!$A2,””)  Any idea how to do this using a formula or is VBA needed here? Thanks in advance!  Read More

​