Forum Discussion
Jcain1022
Oct 22, 2021Copper Contributor
Help Auto-populating columns from master tab to other sheets?
I need help having information on one sheet auto populate to other sheets. For example, the first sheet is sort of a "master" for participant information and on other sheets I only want certain colum...
Jcain1022
Nov 03, 2021Copper Contributor
OliverScheurich Thank you so much. I am hoping to be able to only pull over some of the data from Sheet 1 to Sheet 2. I have a list of names in column A. I have a field of yes/no answers in column B. then I have additional data in columns C-F. I want to pull over Columns A-D only if there is a "yes" in Column B.
Also, If cells are blank in Column D, I want them to stay blank when I pull them over to Sheet 2. Currently, they are pulling over as zeros and making the sheet very cumbersome to look at.
Thanks for your continued help.
SergeiBaklan
Nov 03, 2021Diamond Contributor
Formulas in Excel do not return blank as a value, but you may return empty string instead:
with
=LET(f, FILTER(A2:D9,B2:B9="yes"), IF( ISBLANK(f), "", f) )