Forum Discussion

Copper Contributor

Oct 22, 2021

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...

excel

OliverScheurich

Gold Contributor

Oct 22, 2021

Jcain1022

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.

Jcain1022

Copper Contributor

Nov 03, 2021

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.