Forum Discussion
If Cell in certain column is value then show other related cells in a seperate sheet.
Hi all, i have a sheet attached https://krbnswedu-my.sharepoint.com/personal/jenkinsa_krb_nsw_edu_au/Documents/Diverse%20Learning%20help%20examples.xlsx?web=1 I only want to be updating dat...
Jenkinsakrb Thanks. I trust that you can follow what I've done in the attached file. If not, let me know.
- Thanks heaps but this does not work when I add another row to the data in main sheet. EG if i added another name
Jenkinsakrb 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.