I am intending on building a Userform that will pull this data into it, but I only want it to pull data that has todays date in it, and then I will have a button next to each row to clear that particular range on excel sheet, and then I want a Final Button that removes all blank ranges and brings data back to top of list in excel. (Unless there is a way to do it all in the button that clears that particular row) I will only have 10 Rows in the Userform to pull into, so code should only pull the first 10 items with todays date. If there are more than 10 items, the I would just push pull set until it says no more items to pull, or remains blank.
It would pull CRN/Task/Date/Email into 4 separate boxes.
If we could get this to work, I can then get 4 other lists configured myself.
It would pull CRN/Task/Date/Email into 4 separate boxes.
If we could get this to work, I can then get 4 other lists configured myself.