HI I have an excel document that I populate daily. I run a Crystal report and export that then I copy/paste the columns in the final 'form'.
The form changes only on 2 areas daily.
Dates of Appointment: July 4, 2018 and Date run: Thu July 5, 2018 @8AM ( i can keep the time static although manually I do adjust it). The rows are usually to about 150-180.
Every day I copy the previous days from and change the dates and delete the rows. I think it would save some time if they already existed. Is there a way to make this for say an entire month in one shot?
The form changes only on 2 areas daily.
Dates of Appointment: July 4, 2018 and Date run: Thu July 5, 2018 @8AM ( i can keep the time static although manually I do adjust it). The rows are usually to about 150-180.
Every day I copy the previous days from and change the dates and delete the rows. I think it would save some time if they already existed. Is there a way to make this for say an entire month in one shot?
