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

77 freelancers are bidding on average $79 for this job

$130 USD in 1 day
(248 Reviews)
7.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
(137 Reviews)
6.5
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
(88 Reviews)
6.5
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
(120 Reviews)
6.6
wsh2

At your earliest convenience, could you please attach a copy of your workbook(s) to a private chat message so we may better discuss your requirement. Thank you in advance! Greetings from Easton PA, USA.. {smile} More

$88 USD in 3 days
(42 Reviews)
6.1
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
(55 Reviews)
6.2
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
(92 Reviews)
6.0
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
(99 Reviews)
6.2
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
(101 Reviews)
6.2
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
(115 Reviews)
5.7
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
(48 Reviews)
5.3
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
(65 Reviews)
5.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
(49 Reviews)
5.0
carlosperezit

Hi I’m an expert in Excel and VBA I have been working in software development for the last 20 years Regards Carlos

$111 USD in 2 days
(25 Reviews)
4.8
vsprybhanu

Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I have excellent knowledge and experience of manipulating data in columns with date ranges, advance formulas, developi More

$45 USD in 3 days
(39 Reviews)
4.7
teeares

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.

$30 USD in 1 day
(45 Reviews)
4.8
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
(26 Reviews)
4.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
(10 Reviews)
4.3
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
(15 Reviews)
4.4
serdaryalcin

Hello, It seems like an easy VBA project. Please share the file, 1 hour work. Best Regards, Serdar Yalcin

$49 USD in 3 days
(19 Reviews)
4.2