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
|