Macro - Auto Paste Special
 

Hi,

I have a ordering file that details customers date of last order, and when
we need to send out there next order, which is calculated using a formula,
that gives another date, usually one month in the future, thou sometimes only
2 or 3 weeks.

This varied depending on the customer.

Any ideas how to get a macro to only copy and paste the current days orders
dates, over the previous order date, to give a new next order date?

I can't seem to figure it out my self.

Thanks for the help