Transferring Data from Multiple sheets to one [Closed]

Report
Posts
1
Registration date
Thursday April 6, 2017
Status
Member
Last seen
April 6, 2017
-
Hello,

Disclaimer: I am new to macros and VBA, so reading the code is difficult, but I am making it a priority to learn.

My problem.
I track continuing education courses for my company, specifically from two organizations. At this time I have two sheets in one excel document that lists:

Organization 1
A Course Number
B Due Date
C City/State
D Day 1
E Day 2
F Course Name
G Speaker(s)
H Course Processing Status

Organization 2
A Course Number
B Due Date
C City/State
D Day 1
E Day 2
F Course Name
G Speaker(s)
H Course Processing Status

I am trying to create one document that displays:
1. Upcoming courses and where I am in the process from creation to completion
2. What Courses are being held for each month and which City and State they are
being held (a Calendar option would be amazing)
3. An ability to have a red light/green light to alert course facilitators if there are
issues with their course.

I tried using the advanced filtering but I ran into problems having more than one List Range Page (Organization 1 is on one page and Organization 2 is on another) I created a macro and would do the advanced filter on Organization 1, and copy to column J1 - Z1, and the Organization 2 and Copy to J300- Z300 , then transfer all the courses to A5-H5, using J-Z as my List range. This isn't working and looks really sloppy. I am sure that there is a better way, maybe even easier? Does anyone have a better suggestion on how I can approach this?

Thank you,

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!