I need to design an Excel Spread sheet. I have 300 equipments that some of them are inspected every 3 days and some of them every 4 days and some of them every 7 days. This excel sheet shows the inspection date for a year. For example if an equipment is supposed to be inspected on 10/20/2010 and the frequency of inspection is set to every two days, if we shift the inspection date to 10/19/2010 and keep the same frequency, I want a macro to update the date for the whole year without me doing the copy, past and move the cell. Only with a running a macro
Please help me. I do appreciate it.
Regards,
Guity
Please help me. I do appreciate it.
Regards,
Guity