How to fill an array with values in column C based on Column D date value of Today

Hi

OK just replace the old code with this........... i updated it since the sample i sent you earlier

Please Login or Register  to view this content.

just give it a try, dont forget to change some dates to today

Thanks
Paul S.

It errors out (Subscript out of range) at this line

Please Login or Register  to view this content.

Sorry

Please Login or Register  to view this content.

Try this

Ok, almost there, Now it is putting the Packing List # in the right spot, but it is only taking the first 3 instances where it finds the todays date. Then it is putting the Tracking # in the Project # column leaving the Tracking # column empty. See attached file. I changed a date in an earlier shipment to todays date and added one to the end for a total of 5 entries that would be on the shipping report for 1/9

Totally different method...

Please Login or Register  to view this content.

Wow if i need to obfuscate my work ill contact you .. joke

interesting method.

Thanks for the help now I will try and mend it to work with separate workbooks.

You just need to modify the Sub Header and a line or 2 of code.

Please Login or Register  to view this content.

then if you have a button your planning on putting on each sheet you can easily call this sub using the correct name.

Code the 2015 sheets button to

Please Login or Register  to view this content.

This would require you create controls on each sheet and code them slightly diferent........ or you could use the current Year (2016) to determin where the new data is comming from or a textbox etc etc.