I have a table in excel with values in columns between a date range. I would like to sum each value for each day for a date range at 12:00 PM everyday. For example if my date range is from 1st January 2016 10:30 AM to 31st May 2016 10:30 PM, I want to get the value at 1st Jan 2016 12:00 PM, 2nd Jan 2016 12:00 PM and so on until 31st May 12:00 Pm and add each of those values and bring the total.
I would like to create a Macro or Visual Basic code whichever is suitable.
The solution to your problem appears to be very simple. However, please send a copy of your spreadsheet. I have created many macros in Excel. I will be able to solve your problem.
Hello, I have skills and tools to support you with success, pleasecontact to have a chat. I am available. Please read my profile and comments from my clients as a reference