Forum Discussion

Jcain1022's avatar
Jcain1022
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 columns to populate.  Can someone assist me? Also, fyi, I am not the most tech savvy 😞 generally I just look at videos and follow them and that's been "easy enough" but I cannot seem to find what I am looking for. 

 

I'm using Microsft Office 365 version 2109

excel

5 Replies

  • OliverScheurich's avatar
    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's avatar
      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.

Resources