Dear Forum
I am trying to set up my file so that when a column in one tab contains a particular character string,
then a prescribed set of cells from that associated row are automatically copied to a row in another tab.
I have attached an example file where there is a list of teacher schools and names in the Teacher Info tab.
Tabs C1 and JM2 are event tabs with data from each delegate pertinent to the event.
If a course code of C1 is entered on the teacher's row in any of the 3 colums for Course code1,2 or 3,
I would like the tab C1 column to have the list of schools and names for the people who are listed to go on that course
In my example that would be the data for people 1,2,4,&5.
I would be grateful for any help you can suggest, as I have gone round the 'houses' several times without success.
My experience of this Forum is that there has always been some amazing person on the other side of the world who can work it out in minutes!
Fingers crossed!
Bookmarks