Forum Discussion
Help Auto-populating columns from master tab to other sheets?
You can apply filter formula in the other wortsheets to automatically update the data from your masterfile (Sheet 1 in my example).
=FILTER('Sheet 1'!C2:C333,('Sheet 1'!C2:C333<>""))
Above formula returns all data of column C and range C2:C333 of Sheet 1.
=FILTER('Sheet 1'!B2:C333,('Sheet 1'!B2:B333<>""))
Above formula returns all data of column B and C of range B2:C333 of Sheet 1.
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.
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) )=FILTER(Sheet1!A2:D19,Sheet1!B2:B19="Yes")
This formula includes only rows with "Yes" in column B.
Unfortunately I don't know if there is a way to prevent the blank cells in column D from being pulled over as zeros.
- Thank you so much! I am going to try this and see how it works. If I need more help I will surely be back 🙂
