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.
- Jcain1022Nov 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.
- SergeiBaklanNov 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) )
- OliverScheurichNov 03, 2021Gold Contributor
=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.
- Jcain1022Nov 03, 2021Copper ContributorThank you so much! I am going to try this and see how it works. If I need more help I will surely be back 🙂