This for the Banana ripening rooms where we keep tracking of the ripening progress for 5 to 6 days until it gets ripe. So, currently we the user enters data in to the Row 1- Today Row which is link to another report and copy and paste manually to respectively date for the day.
So,I would like to create a macro to copy and paste value from one Row to another row based on today's days value.
for instance, in this attached file i have created macro which copy and paste cell's value as the specify the range but i would like to copy and paste value for the based on today's day.
So, when use click on the macro button, the data will be copy from the Row 1 (from C12 to K12) to the row reference to date volume to that day's date.
I would be highly appreciated if any one can help me.
Thank you
So,I would like to create a macro to copy and paste value from one Row to another row based on today's days value.
for instance, in this attached file i have created macro which copy and paste cell's value as the specify the range but i would like to copy and paste value for the based on today's day.
So, when use click on the macro button, the data will be copy from the Row 1 (from C12 to K12) to the row reference to date volume to that day's date.
I would be highly appreciated if any one can help me.
Thank you