VBA to display expiry dates

[EimearC]

Hi,
I'm hoping someone here can help, I have a register of items that have a testing due date, I would like if the user could press the PATTestcmd button on the Reports tab that would refresh a testing due date list directly underneath it. The list items refer to2 columns on the Register tab, column A which is the asset number & column V which is the due date. The thing is there would be a lot of blanks & it would be great if it could get sorted by date due, there will be overdue items also so if the order could go overdue, then due, a list of the next 30 items to display would be great.
I've attached the worksheet there, please come back to me if you have any questions about it. Any help would be so appreciated
Thanks

EquipmentRegisterEC.xlsm

[jaslake]

Hi EimearC

Assign this Code to the Button Click Event...

Please Login or Register  to view this content.

[EimearC]

Hi John,

Thank you so much for your help, it looks fantastic.
The only thing is that it relates to column V on the register tab where I need it to pull the dates from column W, I just reread my first post & I had marked that wrong, my apologies.
I did an attempt to change your code from where I saw Field & Columns 22 & changed them to 23 but now when I run the report all the dates on the report tab are 01/Jan/1900.
Would you be able to show/highlight where to change the date due column please?
Thank you so much.
Eimear

[EimearC]

Hi John,

Actually I can see the vba is copying the formula that I have in Column W across, not a paste values, I believe a paste as values will do the trick if you are able to write that in?

Many thanks,
Eimear

[jaslake]

Hi Eimear

Making the indicated changes should do it...

Please Login or Register  to view this content.

[EimearC]

You're a genius! Thank you so much, I was just googling how to do a paste value
That's absolutely brilliant.