There is one summary sheet titled
"All Closed".
There are fourdata sheets titled.
-"Non Event-Closed"
-"Earnings-Closed"
-"Positive Comments-Closed"
-"Syndicate-Closed"
Each data sheet has rows of data starting in row 12. I need help writing a macro that can copy every row with data on the five data sheets and combine them on the summary sheet ("All Closed"). Once all of the data is copied to the summary sheet then sort the data by date ascending (Column B).
Thanks
Bookmarks