How to transfer specific data from one sheet to another [Closed]

Report
Posts
1
Registration date
Monday October 24, 2016
Status
Member
Last seen
October 24, 2016
-
Hello,



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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!