Hi, i am not a local in China but I think i can work on your project with my regional research experience.
I was working with WINN News Singapore to provide news listing for Toyota Singapore in one year as freelancer, which, I think, has well prepared my mind to apply for your post. In order to ensure appropriate data collection upon your requirements, i will use the method, known as 4W and 1H, as follows:
- 4W (what, when, where and who) to provide you specific information relating to any events you looking for of what/when/where a particular thing happened and who did that.
- 1H (it is how) to give you overview of details relating to the events with impacts and consequences and how a particular thing make sense to your requirements.
As the result, i proposal to deal with your excel userform based on what i have done with spreadsheet made for WINN News Articles summary. Accordingly, I use VBA to make data entry in one sheet and recorded data another sheet for analysis. I can create various types of excel userform, which still ensure your system running smoothly and accurately with optimal VBA codding, together with combining drop-down list to categorize data entry. I also ensure minimal communication in your busy time, but optimal output by giving visualized reports on what i am working on your project to sooth your minds.
Hope to be your selection. Thank you for your attention.