Create Script/Formula for Google Sheets

  • Posted:
  • Proposals: 7
  • Remote
  • #675724
  • Awarded
Paul S.
Stephen H.Iain W.Ilyas A.Abu N. + 2 others have already sent a proposal.
  • 0

Description

Experience Level: Intermediate
Description of support work: I have a Google Sheet, it's to manage logistics for a manufacturing business (production batches, stock and ordering) - I need someone who can create a formula/script to perform provide the following functionality, here is background and overview:

Within the same Google Sheet document, I have two sheets - sheet A and sheet B.

Sheet A contains a list of dates in cells C3:C22 and on each row (i.e. for each date), there are 10 values in Columns:

F, J, N, R, V, X, AD, AH, AK, AO

On Sheet B I have inserted a 'List from a range' validation drop down which takes the above list of dates from Sheet A. I need to make it so that when a date is selected from this drop down, data from THAT ROW on sheet A is imported into the following specific cells on Sheet B:

G4, H4, I4, J4, K4, L4, M4, N4, O4, P4

For example, if selecting the date 02/03/2015 - this sits in Sheet A, cell C5.
So that would take the values from Sheet A, cells: F5, J5, N5, R5, V5, X5, AD5, AH5, AK5, AO5
And import them into Sheet B cells: G4, H4, I4, J4, K4, L4, M4, N4, O4, P4

if selecting the date 15/04/2015 - this sits in Sheet A, cell C23
So that would take the values from Sheet A, cells: F23, J23, N23, R23, V23, X23, AD23, AH23, AK23, AO23
And import them into Sheet B cells: G4, H4, I4, J4, K4, L4, M4, N4, O4, P4

When a new date is selected on Sheet B, it should instantly populate the cells with values.

Hopefully the above is a clear explanation, I am sure this is a very easy job for someone with the right Excel/Sheets experience! If you have any questions, please let me know.

** Please only bid if you know how to achieve the above result **
Extra notes:

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.