According to the table format, fill 1-12 months data to the "data" this year, for every one a month on the number of article is not fixed, and constantly add, when there is a change, so the current face data "this year's data", in turn, add automatically, each row shows a company's name, the same as a single person in column B to repeat show;
Each month's data in a cell as A1, so late to sort out each quarter of data, can be clear at a glance, because the front of each table data every quarter to organize a new head of settlement;
A data cell will automatically add box line as well as the various symbol, no data, no, the format is as follows;

https://yunpan.cn/c6C79jZkq8PPC (code: 1282)

CodePudding user response:

Please the teacher for help, thank you

CodePudding user response:

No 360 account, can't download?

This kind of problem, you're missing a "quotation",



Really want to do this, there is no difficulty,
As long as know the source data format, what data to extract (whether screening, screening conditions), how to deal with (or summary),
Use VBA programming are certainly possible,
Many years ago, I have done two similar things,