Linking cells to specific sheets.

[JoePick87]

Hi. Is it possible to link cells to specific worksheets?

excel.png

Basically I have a selection of school children's names/class/year group. I want the data of children who are in say 'Senior 2' class to copy and link onto a sheet called Senior 2. I've tried to attach an image of what I have so far.

Sorry if this doesn't make much sense! Hope it does.

Thanks in advance for any help.

Joe

[MatthewHart74]

Not sure if you're using the insider edition on 365? if so does the attached work?

[JeteMc]

@JoePick87, as opposed to a picture please follow the instructions in the banner at the top of the page and upload the workbook from which the screen shot is taken.
Yes, this is possible with the 2013 version.
Let us know if you have any questions.