我需要一个宏代码来执行以下描述中提到的操作 [英] I need a macro code to do the following as mentioned in the description

问题描述

我有一张excel表，如下所述：

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

这里假设工作表包含一周内员工的工作小时数。如果员工没有在任何一天工作，那么表格和表格中就没有条目。宏应该在相应的一天更新零（0）。



我希望宏给出以下结果：

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

日期是MM / DD / YYYY格式。



我尝试过：



我不是技术人员&不太好用宏。

The date is in MM/DD/YYYY format.

What I have tried:

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

推荐答案

它不是那样的工作。

我们不为你工作。

如果你想让别人写你的代码，你必须支付 - 我建议你去Freelancer.com并在那里问。



但是要知道：你得到了你付出的代价。支付花生，买猴子。



发展的概念就像这句话所暗示的那样：系统地运用科学和技术知识来满足特定的目标或要求。 BusinessDictionary.com [ ^ ]

这与有一个不一样快速谷歌并放弃，如果我找不到完全正确的代码。

所以要么付钱给别人去做，要么学会如何自己写。我们不是为你做这件事。

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.

这篇关于我需要一个宏代码来执行以下描述中提到的操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！