I am not an expert in Excel and I would say that I am a beginner on this program.
I am working on an enrolment spreadsheet. On Sheet 1, I named it pre-enrolment (names, enrolment date, course and if its a successful enrolment or just plain enquiry), on Sheet 2, I named it system, data A, B, C, D are the same ((names, enrolment date, course) but this time only those SUCCESSFUL enrollees.
Question: What is the formula to automatically copy info A, B, C and D from Sheet 1 to Sheet 2 - Only the successful enrollees.
Thanks in advance
How to transfer specific data from one sheet to another