Hello,

I am all new to excel and I am trying to get information from sheet 1 to automatically transfer to the appropriate sheet. In sheet 1, I have listed various organizations by provinces. I have created an additional sheet for each province. I would like all the information from sheet 1 to transfer to the appropriate sheet. For example, if I write Ontario in sheet one, all the information associated to that will transfer to sheet 5 (titled Ontario).

Is this possible in excel?

Thank you so so much for all your help!