如何按日期比较数据，并在数据差异太大时提醒我 [英] How to compare data by the dates and alert me when the data difference is too big

查看：41 发布时间：2019/6/17 3:51:36 exceldev

本文介绍了如何按日期比较数据，并在数据差异太大时提醒我的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我希望创建一个宏，它可以帮助按日期分析数据并通过警报/弹出消息通知我。我有一个预测材料计划文档，我会每天更新它，数据会每天更改。我有大量的数据到
外观，如果我手动完成它需要太长时间。我希望创建一个宏，可以通过日期分析数据，并在数据之间的差异太大时通过弹出消息提醒我。任何线索或帮助将不胜感激。

例如：

01/01/2016 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; 02/01/2016

日期 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; AMOUNT &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;    DATE &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; AMOUNT

01/02/2016 &NBSP; &NBSP; &NBSP; 5 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; 01/02/2016 &NBSP; &NBSP; &NBSP; 5 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP;

02/02/2016 &NBSP; &NBSP; &NBSP; 5 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; 02/02/2016 &NBSP; &NBSP; &NBSP; 5 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;

03/02/2016 &NBSP; &NBSP; &NBSP; 6 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; 03/02/2016 &NBSP; &NBSP; &NBSP; 10 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;

04/02/2016 &NBSP; &NBSP; &NBSP; 5 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; 04/02/2016 &NBSP; &NBSP; &NBSP; 5 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;

05/02/2016 &NBSP; &NBSP; &NBSP; 10 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; 05/02/2016 &NBSP; &NBSP; &NBSP; 20 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP;

06/02/2016 &NBSP; &NBSP; &NBSP; 10 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; 06/02/2016 &NBSP; &NBSP; &NBSP; 15 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP;

07/02/2016 &NBSP; &NBSP; &NBSP; 5 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; 07/02/2016 &NBSP; &NBSP; &NBSP; 8 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;
&NBSP; &NBSP; &NBSP; &NBSP;

08/02/2016 &NBSP; &NBSP; &NBSP; 8 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; 08/02/2016 &NBSP; &NBSP; &NBSP; 9 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;

09/02/2016 &NBSP; &NBSP; &NBSP; 5 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; 09/02/2016 &NBSP; &NBSP; &NBSP; 10 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;

2016年2月10日 &NBSP; &NBSP; &NBSP; 9 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; 2016年2月10日 &NBSP; &NBSP; &NBSP; 2 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;

解决方案

当数据之间的差异太大时，通过弹出消息提醒我。 br />

没有任何意义，你可以用一个简单的公式做到这一点并输出一条消息或进行条件格式化......

安德烈亚斯。

Hi,

I've wish to create a macro which could help analyse the data by the dates and inform me via an alert/popup message. I have a forecast material planner document which i would update it daily and the data would change everyday. I have tons of data to look through and it take way too long if i were to do it manually. I wish to create a macro that could analyse through the data via the dates and alert me via popup message when the difference between the data is too big. Any clue or help will be much appreciated.

EXAMPLE:
01/01/2016 02/01/2016
DATE AMOUNT   DATE AMOUNT
01/02/2016 5 01/02/2016 5
02/02/2016 5 02/02/2016 5
03/02/2016 6 03/02/2016 10
04/02/2016 5 04/02/2016 5
05/02/2016 10 05/02/2016 20
06/02/2016 10 06/02/2016 15
07/02/2016 5 07/02/2016 8
08/02/2016 8 08/02/2016 9
09/02/2016 5 09/02/2016 10
10/02/2016 9 10/02/2016 2

解决方案

alert me via popup message when the difference between the data is too big.

Makes no sense, you can do that with a simple formula and output a message or do a conditional formatting...

Andreas.

这篇关于如何按日期比较数据，并在数据差异太大时提醒我的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文

如何按日期比较数据，并在数据差异太大时提醒我 [英] How to compare data by the dates and alert me when the data difference is too big

问题描述

相关文章

其他开发语言最新文章

热门教程

热门工具

登录关闭

如何按日期比较数据，并在数据差异太大时提醒我 [英] How to compare data by the dates and alert me when the data difference is too big

问题描述

相关文章

其他开发语言最新文章

热门教程

热门工具

登录 关闭

登录关闭