Home>
In a spreadsheet that is in the same ID,
For example, I want to set the data of sheet A to be automatically copied to sheet B.
At that time,
(1) I want to copy the cell combination as it is.
(2) I want to copy the data at one line intervals on the A sheet and paste it at no intervals on the B sheet.
Is there a copying method that includes the above two conditions?
-
Answer # 1
Related articles
- javascript - [gas] write to a spreadsheet using a shortcut
- c # - i'm using addforce in my unity script, but i want to add a speed limit
- javascript - addition using ++ is not reflected in js
- amazon s3 - output csv file in s3 bucket to spreadsheet (using gas)
- javascript - i want to dynamically rename a variable when using a for statement
- javascript - get json data of external api using useeffect of react hooks
- javascript - i want to insert the start tag and end tag of html tags individually using jquery
- javascript - i wrote a script to download a file with js, but i don't understand the conversion to "shift-jis"
- javascript - i want to scrape with google apps script and get the topic link and name
- javascript - i want to output the data obtained from the api to a spreadsheet and summarize it in a table for easy viewing
- javascript - i want to change the process using check in jquery
- google api - i can't scrape using spreadsheet
- javascript - [gas] i want to select the spreadsheet id on the html side and pass it to the function
- javascript - i want to display pdf from url using react-pdf
- javascript - i want to download a file in sjis format using js (jquery)
- c # - [unity] i want to stop the script without using getcomopnent () enabled = false;
- i want to block script in html with javascript
- javascript - can you create a homepage using rails?
- javascript - i want to rewrite the inside of an element using the append method in jquery
Trends
I don't know what kind of image "automatic" is, but
If you create a script and set a trigger,
If you run it (press the button) it will be copied
Copied every hour
Copied if edited
Etc. can be set.
By the way, if the rules for merged cells are fixed and the copy destination sheet B is for reference only,
Prepare the merged cell on sheet B first,Referenced by functionThere is also a way to make it.
If you try to record macros manually
-For sheet A, copy the data at 1-row intervals, and for sheet B, paste without intervals.
As a flow of, you can reduce the trouble of selecting line by line by using a filter as shown below.
Select the range you want to copy on the A sheet (don't worry about every other line)
Create a filter (filter is set in the top cell)
Filter by condition>Select a custom formula
If the lines you want to copy are even lines
= MOD (ROW (), 2) = 0If the line you want to copy is an odd line
= MOD (ROW (), 2) = 1And press OK
Since it will be in the state of every other line, select the range and copy.
Select the start cell of the range you want to paste the B sheet and paste it.