# Copy information on the screen, then copy and set it on another sheet, in particular a specific cell

**URL:** <https://community.glideapps.com/t/copy-information-on-the-screen-then-copy-and-set-it-on-another-sheet-in-particular-a-specific-cell/72412>\
**Category:** Ask for Help\
**Created:** [April 9, 2024, 8:40am UTC](https://community.glideapps.com/t/copy-information-on-the-screen-then-copy-and-set-it-on-another-sheet-in-particular-a-specific-cell/72412 "2024-04-09T08:40:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rcart](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rcart/32/71447_2.png) [@Rcart](https://community.glideapps.com/u/Rcart)\
**Post date:** [April 9, 2024, 8:40am UTC](https://community.glideapps.com/t/copy-information-on-the-screen-then-copy-and-set-it-on-another-sheet-in-particular-a-specific-cell/72412/1 "2024-04-09T08:40:54Z")

</div>

Hello,  
I would like to modify a specific cell in a Google Sheets spreadsheet. My aim is to retrieve the information from my current page, in particular the “Batch number”, in order to copy and paste it into a specific cell on another sheet. Via an action button?

Is this possible with a free version?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 9, 2024, 8:53am UTC](https://community.glideapps.com/t/copy-information-on-the-screen-then-copy-and-set-it-on-another-sheet-in-particular-a-specific-cell/72412/2 "2024-04-09T08:53:12Z")

</div>

It would only be possible if you have a Legacy Free Plan, as the new Free Plans do not allow you to connect to a Google Spreadsheet.

---

<div class="post-metadata">

**Author:** ![Rcart](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rcart/32/71447_2.png) [@Rcart](https://community.glideapps.com/u/Rcart)\
**Post date:** [April 9, 2024, 9:01am UTC](https://community.glideapps.com/t/copy-information-on-the-screen-then-copy-and-set-it-on-another-sheet-in-particular-a-specific-cell/72412/3 "2024-04-09T09:01:21Z")

</div>

I’m able to connect to the Google Sheet spreadsheet without any problem. What is the procedure for performing this action?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 9, 2024, 9:07am UTC](https://community.glideapps.com/t/copy-information-on-the-screen-then-copy-and-set-it-on-another-sheet-in-particular-a-specific-cell/72412/4 "2024-04-09T09:07:56Z")

</div>

Create a single relation from the current row to the row in the other table that you want to update, then use a Set Column Values action to change the value.

> **[Relations | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/relations)**
>
> Create relationships and link rows together.

> **[Set Column Value | Glide Docs](https://www.glideapps.com/docs/automation/actions/set-column-values)**
>
> Change column and row values.