Closed

VBA in MS Excel

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.

Skills: Excel, Visual Basic

See more: vba import excel ms project schedule, excel vba workbook name add, excel ms word programing vba, add sum column excel vba, excel vba install com add, excel vba import worksheet add, excel vba auto install add, excel vba workbook name add workbook, excel vba automatically install add, add reference excel addin vba, sum columns excel using vb6, add references excel macros vba, excel vba referencing macros add, sum columns excel sum, sum columns excel, sql access excel vba, excel vba lock sheet user script, excel vba xml file, excel vba cut paste cells, excel vba dashboard, excel vba macro paste adjacent column, simple excel vba, excel vba access vba, excel vba word style heading, inventory excel vba

About the Employer:
( 0 reviews ) United States

Project ID: #11792800

75 freelancers are bidding on average $78 for this job

$130 USD in 1 day
(254 Reviews)
7.7
Webxpert4u

Hello, Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net for Applications (vba) inside out; writing Microsoft Excel Macros. I can easily create macro to format More

$147 USD in 3 days
(152 Reviews)
7.3
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$50 USD in 2 days
(234 Reviews)
7.4
aarifakhtar

Hi: Please share the sample data and the file. Please note that over 90% of my completed projects are related to Excel and Macro. Moreover, I have 100% completion rate and 5-star feedback on projects. Please connect wi More

$50 USD in 1 day
(155 Reviews)
6.9
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$50 USD in 3 days
(263 Reviews)
7.0
ksriniravi

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporti More

$40 USD in 1 day
(149 Reviews)
6.6
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More

$100 USD in 0 days
(194 Reviews)
6.8
katilinas

Hello. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!

$120 USD in 3 days
(112 Reviews)
6.4
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr More

$150 USD in 7 days
(138 Reviews)
6.6
chriskerpini

Hello, My name is Chris and, as you can see from my profile, I have 16+ years experience working with Excel/VBA and 13 years teaching them (all levels). I certainly can do excellent work with your project. I read ca More

$50 USD in 1 day
(72 Reviews)
6.5
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 280 projects. Please look at the feedback left by my employers to know more about my work. Wai More

$80 USD in 3 days
(120 Reviews)
6.3
macroPOL

Hello, I am Excel and VBA expert. I can write a macro (in Excel VBA). It will sum each value for each day for a date range. Can I see the file? Please note that I have 100% completion rate and 5-star feedbac More

$88 USD in 3 days
(64 Reviews)
5.7
rengrish

Hi I have understood your requirement clearly. I can complete this job within 1hour or even less. Please ping back. I can give you solution on the spot. I have 10+ years of experience in Excel & VBA. Please check my p More

$45 USD in 0 days
(137 Reviews)
5.9
MohsanEijaz

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y More

$35 USD in 1 day
(67 Reviews)
5.9
$30 USD in 1 day
(54 Reviews)
5.5
vw7209238vw

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

$37 USD in 1 day
(47 Reviews)
5.5
osmemon

5 Years of Experience. Highly competitive team. Hire us for best and accurate results of your projects

$30 USD in 1 day
(34 Reviews)
5.6
haibg2111

Dear the client, it's pretty easy task. I can create you a VBA built-in function or tab that you can use to calculate

$30 USD in 1 day
(31 Reviews)
5.3
MoohHHooM

Hi, i am ready for this project... I have it ready for you know, please share a sample sheet now so i can test it again .

$30 USD in 0 days
(30 Reviews)
5.4
satishtl

- Can build the macro on click of the button would add up all the dates with 12:00 or any condition within which the date range falls. - Have expertise in Excel automation, macros, formulas, calculations, summarising More

$30 USD in 2 days
(43 Reviews)
5.5