Newbie: Return values from one sheet to another if not blank

[cburket]

Hi Excel geniuses!

I have a master sheet that is fed by a MS Form collecting data. In the workbook, along side the master sheet are additional sheets that I'd like to have a small range of the data from the master sheet displayed—if not blank.

Each user that completes a form will produce data that collects in different areas of the Master Sheet, so the goal is to only populate the additional sheets with data when there is data in that specific section collected.

 

[Joe4]

Welcome to the Board!

You can use the new Filter function to dynamically pull data from your Master sheet to the other sheets.
It is a spill function, so you only have to enter the formula in one cell on the other sheets, and all the matching data will automatically spill over to the other cells.
See: FILTER function - Microsoft Support

 

[cburket]

Welcome to the Board!

You can use the new Filter function to dynamically pull data from your Master sheet to the other sheets.
It is a spill function, so you only have to enter the formula in one cell on the other sheets, and all the matching data will automatically spill over to the other cells.
See: FILTER function - Microsoft Support

Thanks Joe! This is perfect. If I wanted to return the results from Column B and G:L. how would I do that? Here is my working formula:
=FILTER(MASTER!G:L,MASTER!F:F=A2,"")

Thanks in advance!

 

[Joe4]

Thanks Joe! This is perfect. If I wanted to return the results from Column B and G:L. how would I do that? Here is my working formula:
=FILTER(MASTER!G:L,MASTER!F:F=A2,"")

Thanks in advance!

With two formulas in cells next to each other, i.e.
in first cell:

=FILTER(MASTER!B:B,MASTER!F:F=A2,"")

and then in cell right next to it on the right side:

=FILTER(MASTER!G:L,MASTER!F:F=A2,"")

 

[Joe4]

Actually, you can combine the two formulas in one cell if you use the HSTACK function, like this:

=HSTACK(FILTER(Master!B:B,Master!F:F=A2,""),FILTER(Master!G:L,Master!F:F=A2,""))

Here are details on the HSTACK function:

HSTACK function - Microsoft Support

support.microsoft.com

 

[cburket]

Actually, you can combine the two formulas in one cell if you use the HSTACK function, like this:

=HSTACK(FILTER(Master!B:B,Master!F:F=A2,""),FILTER(Master!G:L,Master!F:F=A2,""))

Here are details on the HSTACK function:

HSTACK function - Microsoft Support

support.microsoft.com

Perfect! This is exactly what I needed. Thanks Joe!