Find Jobs
Hire Freelancers

Google Apps Script to copy and paste values between sheets

$10-30 AUD

Concluído
Publicado há mais de 9 anos

$10-30 AUD

Pago na entrega
Hi, I need to process rows of data from one sheet to another within a Google Drive Spreadsheet using Scripts. Layout: Sheet1 has the data, each row represents a line of data to be processed Sheet2 has a matrix 8x14 cells which the data goes in to Sheet3 has formulas that apply calculations to the data put in the matrix on Sheet2 Sheet4 has the results in each row Part 1: Data from a cell in a row in Sheet1 should be pasted in to a cell in Sheet2. ie Sheet1!A1 goes to Sheet2!A1 but Sheet1!B4 goes to Sheet2!C3 for example (further details given in the spreadsheet). Part 2 (you do not need to do this part, but here for explanation): Sheet3 has a number of formulas that process the data in the matrix on Sheet2. Once one rows data from Sheet1 has been pasted in to the correct cells of Sheet2 to complete the matrix a number of values will be calculated by the formulas in Sheet3. Part 3: The values calculated by Sheet3 need to be copied to Sheet4 along with an ID reference from Sheet1 Part 4: Sheet1 has a column "DONE", for the row that has been processed this should be filled with the value "1" indicating that row has been processed. Part5: The matrix in Sheet2 is cleared and the cycle is repeated with the next row of data from Sheet1. Parts 1 to 4 repeat until all rows in Sheet1 are marked with a "1" in the "DONE" column. The script is to run on Google Apps Scripts ([login to view URL]). An example of the spreadsheet is here: [login to view URL] Although not absolutely necessary the script should move the cell values from Sheet1 to Sheet2 cell by cell, rather than multiple cells at a time in a range (ie move cell B4 to D6, don't move a range such as B4:B8 to D6:D10). Thanks
ID do Projeto: 6702370

Sobre o projeto

3 propostas
Projeto remoto
Ativo há 10 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
hello, This work of Moving data from one sheet to other of spreadsheet can be easily done by JavaScript, I can also show you the method of doing this by creating a dummy spreadsheet and doing operations over it. We can discuss this further on chat, Thanks a Lot, Priyanka
$30 AUD em 1 dia
0,0 (0 avaliações)
0,0
0,0
3 freelancers estão ofertando em média $70 AUD for esse trabalho
Avatar do Usuário
A proposal has not yet been provided
$30 AUD em 2 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) AUSTRALIA
Rundle Mall PO, Australia
5,0
1
Método de pagamento verificado
Membro desde set. 9, 2014

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.