I need a macro code to do the following as mentioned in the description

Question

1.00/5 (1 vote)

See more:

I have an excel sheet as mentioned below:

Date	EmpName	TimeWorked	Sun	Mon	Tue	Wed	Thu	Fri	Sat
5/7/2017	ABC	3							
6/7/2017	ABC	4							
7/7/2017	ABC	5							
9/7/2017	ABC	6							
4/7/2017	XYZ	8							
5/7/2017	XYZ	8							
6/7/2017	XYZ	8							
7/7/2017	XYZ	8							
8/7/2017	XYZ	8							
9/7/2017	XYZ	8

The assumption here is that the sheet contains the number of hours worked for employees in one week. If an employee has not worked in any day, there won't be an entry in the sheet & the macro should update zero (0) for the corresponding day.

I want the macro to give the below result:

Date	EmpName	TimeWorked	Sun	Mon	Tue	Wed	Thu	Fri	Sat
5/7/2017	ABC	3	0	0	3	4	5	0	6
6/7/2017	ABC	4							
7/7/2017	ABC	5							
9/7/2017	ABC	6							
4/7/2017	XYZ	8	0	8	8	8	8	8	8
5/7/2017	XYZ	8							
6/7/2017	XYZ	8							
7/7/2017	XYZ	8							
8/7/2017	XYZ	8							
9/7/2017	XYZ	8

The date is in MM/DD/YYYY format.

What I have tried:

I am not a technical person & not very good with macros.

Posted 4-Oct-17 15:38pm

Member 13446361

Updated 4-Oct-17 19:46pm

Patrice T

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2017-10-04T19:46:00

It doesn't quite work like that.
We do not do your work for you.
If you want someone to write your code, you have to pay - I suggest you go to Freelancer.com and ask there.

But be aware: you get what you pay for. Pay peanuts, get monkeys.

The idea of "development" is as the word suggests: "The systematic use of scientific and technical knowledge to meet specific objectives or requirements." BusinessDictionary.com[^]
That's not the same thing as "have a quick google and give up if I can't find exactly the right code".
So either pay someone to do it, or learn how to write it yourself. We aren't here to do it for you.