Pasting cell values to next row in another sheet with a button

[Jordan Robbins]

Hello! I am trying to use a button to click and it will copy from specific cells and paste those values into another sheet. But I need it to paste to the next row each time I enter new values and click the button. hope that makes sense. lol

[Keith Andersen]

Do you need a specific row moved to another sheet or do you need to select a row or rows to move to a different sheet?

On Sat, Sep 23, 2023, 9:10 PM Jordan Robbins <jrob...@jrhomesecurity.com> wrote:

Hello! I am trying to use a button to click and it will copy from specific cells and paste those values into another sheet. But I need it to paste to the next row each time I enter new values and click the button. hope that makes sense. lol

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/7291e98f-074a-4dc5-b193-465dfd919c21n%40googlegroups.com.

[Jordan Robbins]

I have about 4 or 5 cells in a column that I want the values I type in them to auto populate in a row in sheet 2 when I click the button and go to the next row and do it again when I type different info in sheet 1 cells and click the button again.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAJ8MD4w3zQ4re-Ri65Eq9pHsdgWV%2BSRCaH6fpQrXN6Jk9iQDDQ%40mail.gmail.com.

[CBMServices Web]

Why don't you create a sample spreadsheet with what you want done and share it with us so we can see what you need.

Also share what script you put together so we can give you pointers on where to proceed.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CALakct4ukMUSJ19ZF5MK11q%2BQ%2ByvoWFdVaXbcNxTqxxkbRPgmw%40mail.gmail.com.

[Keith Andersen]

Jordan,

Watch this video and make a copy of the spreadsheet to make it your own so that you can be the sole editor of it. It contains all the coding you will need. If you have problems let us know.

https://youtu.be/KozfAC8cpqE?feature=shared

Keith 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAFX%2Bz3X5%2BJv19Rknzu5632_OU_xppmeObtjA9T_nf5fXF55B%2Bw%40mail.gmail.com.

[Jordan Robbins]

Here is a sample sheet. I want to fill in info on sheet 1 and click the submit button and auto populate next row on sheet 2 each time.

https://docs.google.com/spreadsheets/d/1mbFU_GGYFU66GMRbNZl7K4gfaIKAS6oopi1gK9k11mY/edit#gid=0

[Keith Andersen]

Open this sheet then make a copy. That will make you the owner and give full editor access. Obviously you will need to go through the permissions process.

https://docs.google.com/spreadsheets/d/1WeVkAdX0RQIdR8sbJy628yx-t-ZB_aUq2w32ePbtcqU/edit?usp=sharing

This sheet directly answers your question and contains two additional functions that show how to select a data row and move that data to either the top row or bottom row. of another sheet.

Hope it serves your needs.

cheers

Keith,

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/bbd599c5-2086-4a95-82e6-c26716b41256n%40googlegroups.com.

[Jordan Robbins]

Thank you!

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAJ8MD4xjY5u-w8evRSmGdEnarc_9OPTFmRXkCcUp-pEkk9Xk-Q%40mail.gmail.com.

[Keith Andersen]

My pleasure.

Cheers

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CALakct5xj7J4g2XKBRieVxzEc3KLxtuZh01GWFD1aM3tJcW7Xw%40mail.gmail.com.