Hi,
We have process sheet for all the Employees where daily 20 Excel files will be sending to me ,which i have to copy the Data for that day, so without erasing previous days data it should copy Data for that Days date from Every Excel to Master sheet.
----If Take system date it will be good to copy as per Date wise data.If system date is 31st May 2016 it has to copy only that date's data if no data then leave that sheet.
Hope you have got my query.Kindly sort out macros for this.
We have process sheet for all the Employees where daily 20 Excel files will be sending to me ,which i have to copy the Data for that day, so without erasing previous days data it should copy Data for that Days date from Every Excel to Master sheet.
----If Take system date it will be good to copy as per Date wise data.If system date is 31st May 2016 it has to copy only that date's data if no data then leave that sheet.
Hope you have got my query.Kindly sort out macros for this.
