Hi all
I am after some assistance, please.
I have a spreadsheet that I would like to use to record student results. Sheet 1 is a summary sheet. Sheets 2-6 contain results for each different subject.
When I enter student data into sheet 1, I would like the text entered to copy and paste into corresponding cells in another worksheet.
E.g.
If cell A3 on Sheet 1 = 000111222, I want that data to automatically copy and paste into cell A3 in Sheet 2.
or, If cell B3 on sheet 1 = Mary, I want that text to automatically copy and paste into cell B3 in sheet 2
I would then like data from other sheets to copy and paste into sheet 1.
E.g.
If cell G3 contains text (list of 6 possible results from a drop-down menu), I would like that result to copy and past into a corresponding cell in sheet 1.
Hope that all makes sense. Thanks in advance.