合并工作薄、合并工作表---excel外接程序插件:多薄多表合并 mergebooks_setup.exe

下载地址:http://yunpan.cn/cmPGYNFu5HkH7  访问密码 1ba7
update: there is a backup at ///box///

多薄多表合并——excel 外接程序插件

使  用  说  明

一、功能:
1、多薄合并:将当前文件夹(默认)或某一文件夹下所有工作薄合并到一个自动新建的“汇总表”工作薄中。可以选择“合并所有工作表、按位置选择的工作表、按名称选择的工作表”,还可选择“保留重复行(默认)”、“去除重复行”。

在启动excel后(未保存)的新工作薄中点击该按钮则打开“文件夹选择”对话框。

2、多表合并:将当前工作薄中的工作表合并到一个自动生成且位于最后的“汇总表”工作表中。可以选择“合并所有工作表、选择的工作表”,还可选择“保留重复行(默认)”、“去除重复行”。

3、清除数据:清除当前工作表或当前工作薄中所有工作表数据。 默认“取消”按钮(即按Enter后)仅清除当前工作表中的数据。

4、分类汇总:将所选区域第一列相同的行的其后各列数据进行汇总(求和),并将汇总结果放置到所选择的目标区域。分类汇总结果为第一列不再有重复行,即第一列“去除重复行”,其后各列数据求和。

5、拆分表格:

⑴拆分工作薄:把当前文件夹(默认)或某一文件夹下的所有工作薄(或选择的多个工作薄)中(标签)名称相同的工作表合并到一个工作薄中,重复使用,又可合回来。可以把一个工作薄拆分成多个工作薄;也可以把多个工作薄合成一个工作薄。

⑵拆分工作表:将所选单元格以下的不同文本数据拆分到不同的工作表中。

6、选择查询:在所选区域第一列中查找,并将查找结果(符合查询条件的许多行)放置到所选择的目标区域。

7、多薄汇总——求和(默认)、全部求和、平均、计数:将某一文件夹或当前文件夹下的所有工作薄中的当前工作表的数据按照所选择的单元格区域汇总(求和、平均、计数)到一个自动新建的“汇总表”工作薄中。工作表与工作表一一对应,单元格与单元格一一对应汇总(求和、全部求和、平均、计数)数据。。

8、多表汇总——求和(默认)、全部求和、平均、计数:将某一工作薄中所有工作表数据,按照所选择的单元格区域进行汇总(求和、平均、计数)。

9、插入空行:在当前单元格下隔行插入空行。

10:删除空行:删除当前单元格以下的所有空行或0值行。

11、插入表头:在所选择的表头区域下方,隔行插入表头(工资条)。

12、批量打印:当前文件夹(默认)或某一文件夹下的所有工作薄全部打印,可以选择打印“整个工作薄”、按名称“选定工作表”、按位置“指定工作表”,可选择“打印份数”、“逐份打印”,还可打印 “预览”。

二、注意:
“多薄合并、多表合并”:要合并的工作薄(或工作表)中工作表的表头行数必须相同;仅复制表头以下的行;工作表对应合并。可选择“去除重复行”、“保留重复行”。不破坏原始表格和数据,可反复多次使用,从而实现追加合并。

“多薄求和、全部求和、多薄平均、多薄计数”:仅处理固定行列的表格,工作表、单元格按位置对应汇总。“多表求和、全部求和、多表平均、多表计数”类似。

三、安装使用:
1、 下载、安装过程中,可能受360警告、拦截,甚至直接被灭了,这是360处理未知程序的正常处理方式。可选择“添加信任”、“直接运行”、“信任程序所有操作”,如果被灭了,可找回。
安装完成后,在excel203工具栏或excel2010“多薄多表”选项卡中会有“多薄合并、多表合并、清除数据、分类汇总、拆分表格、选择查询”等功能按钮。(见下图)

2、默认安装位置为C:\WINDOWS\mergebooks.dll  ; 如果电脑进行了多用户设置,如电脑用户为lcb,可把mergebooks.dll复制到C:\Documents and Settings\lcb\Application Data\Microsoft\AddIns\mergebooks.dll  中。

3、Excel2003调出“多薄多表”方法:

如果在excel2003工具栏中没有以上按钮,则按如下方法进行:

第一步(添加到COM加载项):打开excel,在“工具栏”上点击“COM加载项”。调出如下窗口。

把“可用加载项”中的“mergebooks.dll” (打勾),此时excel2003工具栏中将出现按钮;如果没有出现,则继续点击上图中的“添加”按钮,进入以下窗口:


在右边窗口中选择Mergebooks.dll——确定——返回(第一个窗口)——(继续)确定返回——关闭excel。

第二步(添加到工具栏):再次打开excel2003,点击“COM加载项”进入第一个窗口,把左边窗口中的“Mergebooks”(打勾)——确定(返回),即可出现在工具栏中。

4、Excel2010调出“多薄多表”方法:文件——选项——自定义功能区——(右边)“多薄多表”(打勾)


开发者:hu73248@163.com;或QQ:249165513

Russian warplane, Turkey missile, Syria territory, ISIS and petrol business


Turkey shot down Russian warplane
1
When reading international news with my phone, I am VERY astonished to read this news that Turkey government military shot down one of the 2 Russian warplanes SU-35, these 2 Russian warplanes were on the way to air base after they carried out a task aimed at ISIS.
I guess most people will also be astonished, turkey must be crazy!

The Russian warplane was shot down in Syria territory where was controlled by anti-Syrian and pro-Turkish Turkmenistan armed militants.
Both the two pilot parachuted from the destroyed warplane, but were supposed to be shot by pro-Turkish militants.

2
Turkey president Erdoğan said it is needed because the Russian warplanes were violating Turkish airspace as as 17 secs.
Then, Turkey gov summoned the 5 permanent member state (of UN Security Council): USA, China, UK, France and RUSSIA.

3
Russia president Putin said this is "stab in back".
The USA said USA is not involved in this incident.
The Europe, UK and France called both sides to be calm down.

4
ISIS(Islamic State of Iraq and the Levant) is a terrorist organization, it is ISIS who killed French in Paris and Chinese in Mali. Syria gov said ISIS sold petrol to Turkey at a lower price.

5
Maybe Turkey gov military mistaken Russian warplanes as Syria government's.

6
But it is sure that Turkey must be mad, Russia is striking ISIS terrorists, Putin will let Turkey what is price.
Turkey is silly.

Russia is doing something...
The Turkey vehicles destroyed by air strikes of Russian military


The Russian S-400 air defense missile has been deployed in Syria


step-by-step: How to open Excel 2010 files in separate windows in Windows 7

By default, Excel files are opened in a same window in Windows 7. But sometimes you might want to view some files at the same time on your screen. To do this, you can start a new Excel process (excel.exe) by clicking the Excel button from the Start menu.

However, you can configure your computer to always open Excel files in separate windows. We recommend that you only use the method in this article when your computer has sufficient RAM.To have us configure your computer to open Excel files in different windows for you, go to the "Here's an easy fix" section. If you prefer to configure your computer to open Excel files in different windows yourself, go to the "Let me fix it myself" section.

Here's an easy fix

To fix this problem automatically, click the Download button. In the File Download dialog box, click Run or Open, and then follow the steps in the easy fix wizard.
Because the change involves modifying registry keys, the easy fix solution will create a registry backup at your desktop
This wizard may be in English only. However, the automatic fix also works for other language versions of Windows.
If you’re not on the computer that has the problem, save the easy fix solution to a flash drive or a CD, and then run it on the computer that has the problem.

here to download an easy fix to solve this problem.

hmm, if you want to fix it by yourself, give up now, because it is something about code, not hard to do, but complicated. via https://support.microsoft.com/zh-cn/kb/2636670

good computer softwares

眼睛护士
经常使用计算机的您是不是有眼睛干燥,疲劳不适的情况呢? 眼睛护士(eyefoo.com)是一个可以定时提醒休息,保护眼睛的护眼软件、健康软件。//////下载见box

ccclear 电脑清理工具

KMPlayer

office-skills

excel身份证提取出生年月日
将函数=MID(B2,7,8)输入如图所在位置,回车或是点击任一单元格,即自动提取出出生日期。B2为身份证号的坐标,7为从第7位数字提了起,8为提取8个连续数字。如只想提取出年月,可以输入=MID(B2,7,6)

excel 身份证 年龄


身份证 excel 提取性别

win7 excel 多窗口独立显示//////不相互覆盖---EN
下载这个小工具MicrosoftEasyFix**** //////box-软件安装

合并多个excel---多薄多表合并 search in this blog

excel 页眉页脚 一共几页第几页 设置
“页面布局”—>“打印标题”—“页眉/页脚”---自定义页眉等等




bubblews.com was shut down

Today when I want to login my bubblews account, it shows:

Greetings,

After being up and running for almost 3 years now we regrettably need to inform you that we will be shutting Bubblews.com down. The climate for display advertising has drastically changed and made it impossible for us to sustain the business model and operations.

We want to thank everyone that was a part of this journey. We wish you all the very best.

–Bubblews

I have earned some extra dollars by writing articles at bubblews years ago, and there are many people said bubblew com could not last long at that time, now it becomes true.

whatever, to bubblews com.



Here is one short analysis I wrote befor bubblews' going down about why bubblews.com will be shut down:
The reasons why Bubblews will be shut down in the coming future:
I always insist that there will be one day Bubblews should and will shut down, sooner or later. Here is why:
1, Because Bubblews shares too high revenue with the users that actually Bubblews itself can not afford, the revenue is too high that it is a little unbelievable, what to say, maybe Bubblews is cheating you and us.
2, At the same time, people who write at Bubblews are firstly for the money, secondly for sharing useful and helpful article. Many people at Bubblews are busy in writing, connecting, liking articles, just want to make more money, only a few people are writing articles with high quality, which is the reason directly leads to the close down of Bubblews.
3, Bubblews is not as good as they said to people, the time of redemption money to your Paypal account is becoming longer and longer, from 3 days to one week, from one week to one month, from one months to three months, who knows, maybe next time you need one year or more time to wait for your Bubblews redemption money to your Paypal.

The 6 kinds of people who don't replace a new cell phone after using their phones more than 3 years

recently, I read one interesting Chinese article online, I really want to share this to most people, so translate it from Chinese to English.

the question is that who will do not replace a new cell phone after using his phone 3 years.

1 the ones who use nokia phones. nokia phone is the "best" phone of the world.

2 the ones who use iphone4 or iphone4s. Steve Jobs will be very proud of iphone4/4s.

3 the ones who only use cell phone to send messages and give calls. these phones are are designed simple, "if you dont use it, it is just something like a brick".

4 the ones who only love the brand. different people have different preferences when they are choosing their phones, some only use apple iPhone, some only use Samsung, some only use blackberry...
if you ask them why, the answer will be that "there are no reasons, we are just fans"

5 the dawdlers. the dawdlers are so lazy that they dont even want to buy a new cell phone on the web store.

6 the poor people who are short of funds. not because they dont want to buy a new smart phone, but that they do not have too many funds after paying foods, rents and cloths. careful to talk about this topic with them, they will be not happy, even angry...

社会阶层 社会资源

给你提供个全新的角度。
社会层级用信息的获取能力和占有量来衡量:
最底层:没电脑没电视没报纸,信息由每晚村口聊天得来。信息具有极大的局限性。
底层:有电视有报纸,被动接受信息。
中下层:会使用电脑等设备获得信息,但大部分信息没有实际意义。
中层:有一定的信息渠道,有一定信息转化为产出的能力。
中上层:信息渠道较稳定高效,以获取的信息数量和质量来决定行动,信息基本就是生产力。
上层:信息资源的创造者和分配者。

看了这个分法,你就明白为什么芙蓉姐姐之流拼了命也要出名的原因了,也能明白最红的明星总是传言不断的了。
———————————————————————
在学术界有种观念与大家分享:世界上的万事万物都可以归结为信息的集合。从这个角度来看,一切实物和虚拟的社会资源均可称之为信息资源。这种观点常见于科幻小说和电影(ps:别以为写科幻小说的作家都是白痴,其中有很多大牛)。
所以说,以资源占有量划分阶层的方法,也可归结到以信息占有量划分阶层方法里面。
via http://www.zhihu.com/question/21183775/answer/17500905

把信息资源转换为生产力

Which country is the most powerful in Europe---United-Kingdom, France or Germany?

A British, a German and a French are talking about this, here is what they say:

German(cautious): if i say it is Germany, you will not launch sanctions against Germany.
French(irony): hmm, whatever, it is not British.
British(anti-irony): what is the question? Actually mentioned France?!

German(serious): ok, if not allow me to say Germany, that should me British.
French(helpless): fr-de friendship is over!!!
British(satisfied): this question is over.

Muji

When I went to the MUJI store at the first time in a city where there is no home, I found that I have deeply loved the MUJI products. And I told me that I will buy the MUJI stuff as possible as I can.

What is MUJI? MUJI, whose full name is "Mujirushi Ryohin", is one Japanese groceries-retail company which mainly sells a wide variety of household and consumer goods. In Japanese, "Mujirushi Ryohin" means the quality product without label. MUJI products are paid attention to be simple, environmentally friendly and natural.

The characteristics of MUJI goods:
Backing to nature:good design, quality raw material, nice craftwork. That is quality product.
Be simple: Muji product is the product what the product itself should be, be simple is one important character of Muji goods, be simple and there are no labels as little as possible.
Be concentrate on every detail. rational analysis,simple product tone, full of design sense and full consideration on every detail.

In short, Muji is more a philosophy of life than a brand.

Excel 身份证号码 自动计算年龄

在实际生活中,往往要根据身份证号码自动计算年龄,在Excel中,采用Excel2003YEAR函数获得当前年份,采用Excel2003MID函数取得身份证号码的出生年份,可快速地根据身份证号码自动计算年龄。 如图所示,在B2单元格输入身份证号码,在C2单元格输入: =YEAR...