Most current dates - single cell from list of information

[bcowu9]

Hey guys very new to this and have a good understanding on excel in general. In regards to VBA's and Macros I am new. I have alot of data that I need to pull from and put into one cell. So for example Bill has A and E, these would need to be pulled and put into one cell on another page (I have complete this).. See below

slts.PNG


I have another row that includes dates... I need to just pull the most recent dates and NOT the older dates. Please let me know if you can help me out with this.

Bill

[FDibbins]

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )