I have 1 File of Gogle Sheet that contain many sheet tabs with different data, but same order to organize it. How to do this automatically so I can save time instead copy paste one by one for each tab?
The order is:
- Move Data from C4 to H4
- Move Data from C6-C15 to G5-G14
- Move Data from D4 to H15
- Move Data from D6-D15 to G16-G25
Thanks
Sugeng siang fermipan,
To MOVE values will require an apps script.
I recommend you try looking in StackOverflow forum about how apps scripts are written.
When searching, here are some terms you should include:
- getValue
- getValues
- setValue
- setValues
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks