自动更新Excel工作表 [英] Auto-updating an excel sheet
问题描述
我一直在发送人员表格（表格可以是任何类型），以填写他们的详细信息，一旦他们填写，他们发送它对我和我手动更新了Excel表格及其详细信息。
我想自动完成该过程。
一旦他们填写表格，Excel表格将自动更新。
事情是我不希望他们看到其他人的详细信息，所以我不能向他们发送一张公用表。
包含所有详细信息的Excel位于Google-Docs上。
有没有办法使用从每个人收到的信息自动更新Google-Docs中的Excel表格？
感谢您的帮助。
我尝试了什么：
如上所述，我一直在这样做到目前为止手动。
Hi,
I've been sending people forms (the forms can be in any type) to fill their details there, once they filled it they sent it to me and I manually updated an Excel sheet with their details.
I'd like to make that process automatic.
Once they fill the form, the Excel sheet will be automatically updated.
The thing is that I don't want them to see the details of other persons, so I can't send them a common sheet.
The Excel that contains all the details is located on Google-Docs.
Is there a way to automatically update the Excel Sheet in Google-Docs with the info received from each person?
Thank you for your help.
What I have tried:
As detailed above, I've been doing it manually so far.
推荐答案
你会怎么做？
我会使用2个WorkBooks。
First WorkBook只是表单，你发送给人们。
第二个WorkBook是你收集数据的地方。
在第二个WorkBook上，你构建一个自动化过程的宏。
VBA集成到Excel并且您可以将您的操作记录为宏，宏被记录为VBA程序。
然后，当您收到表单时，您在Excel上打开一个启动宏。
I would use 2 WorkBooks.
First WorkBook is form only and you send it to people.
Second WorkBook is where you collect data.
On second WorkBook, you build a macro that automate the process.
VBA is integrated to Excel and you can record your actions as a macro, the macro is recorded as a VBA program.
Then, when you receive a form, you open both on Excel an launch the macro.
ppolymorphe的回答是现货。我会进一步扩展并使用命名范围，对于单个细胞以及细胞组，使得更容易找到答案。因此，不是
ppolymorphe's answer is spot on. I would expand a bit further and used named ranges, for individual cells as well as groups of cells, to make finding the answers far easier. So instead of
A5 ，而不是 Answer1 。
这篇关于自动更新Excel工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
