If Cell in certain column is value then show other related cells in a seperate sheet.

Question

Hi all,&nbsp;&nbsp;i have a sheet attached&nbsp;https://krbnswedu-my.sharepoint.com/personal/jenkinsa_krb_nsw_edu_au/Documents/Diverse%20Learning%20help%20examples.xlsx?web=1&nbsp;&nbsp;I only want to be updating data on the sheet titled main. I want the other sheets to sort through the data on main and display only the columns that I want. For example on the "Year 7" sheet i would like it to have column A B C L Y shown if column B has the number 7 in it.&nbsp;&nbsp;I want the other sheets to automatically update the data as i enter it on the Main tab. (used to be able to do this on Google sheets but now I am transitioning to excel I have struggled!)&nbsp;Thanks legends,&nbsp;

riny_van_eekelen · Answer

Jenkinsakrb&nbsp;That link doesn't work. At least not for me. Can you upload the file here?

jenkinsakrb · Answer

Riny_van_Eekelen&nbsp;

riny_van_eekelen · Answer

Jenkinsakrb&nbsp;Thanks. I trust that you can follow what I've done in the attached file. If not, let me know.

jenkinsakrb · Answer

Thanks heaps but this does not work when I add another row to the data in main sheet. EG if i added another name

riny_van_eekelen · Answer

Jenkinsakrb&nbsp;Ah, I see. You get a #SPILL error. That's because of the formulae in column D. Delete them. Then it should work. See attached.&nbsp;

Forum Discussion

If Cell in certain column is value then show other related cells in a seperate sheet.

7 Replies

Resources