Issue with Array

[ATLGator]

Hello again,

I am trying to copy course names and codes from one workbook to another and am having issues with the array.

On the "Master Course List", if there is an "X" in Column O, then I want to add the course name and course code to the new worksheet. I have already successfully done one like this, however that was when I added the course name and code to Columns A & B. This one is adding the name and code to Columns A & C. The bolded section is what is giving me trouble. How do I reference each cell in Columns A & C to make them equal to the course name and code?

Please Login or Register  to view this content.

Thank you!

[ATLGator]

To compare, here is the one I completed successfully.

Please Login or Register  to view this content.