通过单击Google表格中的图标，将单元格值从一个单元格自动复制到另一张工作表 [英] Autocopy cell value from one cell to another sheet by clicking an icon in google sheets

问题描述

我想通过单击C2中的图标，将单元格A2中的单元格值复制到新的电子表格中.

I would like to copy cell value from cell A2 to a new spreadsheet by clicking on an icon in C2.

当有人单击C2时，我想为新电子表格添加时间戳.

Preferable I would like to add a timestamp to my new spreadsheet when someone clicks on C2.

有人可以帮我解决这个问题吗?

Could someone help me out with this matter?

我在此处制作了一个测试电子表格: https://docs.google.com/spreadsheets/d/1SUqqwr2fGZTDFMyCw9WRWUljSoHUO05X_a0arqLPUdo/edit#gid = 0

I have made a test spreadsheet here: https://docs.google.com/spreadsheets/d/1SUqqwr2fGZTDFMyCw9WRWUljSoHUO05X_a0arqLPUdo/edit#gid=0

匿名用户不仅应在工作表的编辑者中单击该图标.

The icon should be clickable by an anonymous user not only by the editor of the sheet.

非常感谢您的帮助

推荐答案

我在另一个论坛上发布了相同的问题，在这里，我得到了这个答案，这次对我有帮助.感谢Kishan帮助我.答案发布在这里: https://support.google.com/docs/线程/31690663?hl = zh_CN

I posted the same question in another forum and here I got this answer which helped me out this time. Thanks to Kishan for helping me out. The answer is posted here: https://support.google.com/docs/thread/31690663?hl=en

这篇关于通过单击Google表格中的图标，将单元格值从一个单元格自动复制到另一张工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！