Copying Data from Time sheet to Summary sheet without opening summary file-Additional checkpoint

  • Hi AlI I have below code which basically copies the data from one excel sheet to another excel sheet and is working fine in doing its job.I want additional control in the below code.

    In my time sheet , I have to restrict people from updating more then one day information, example - If I am updating information for May 1st and if excel contains information for multiple days (May1,2,3,4) it should update only for 1st may. Can i add any logic by referring to any cell which is my date input cell. Also Column A has multiple dates inputted.