Google Sheets - Automating Row Transfer to New Tab Depending on Data Validation Selection


We need to know if it is possible to automate Row Transfers to a specific tab depending on the selected data validation drop down options.


Data Validation Drop Down Options: 1, 2 and 3

Tab Options: A, B and C

All entries are made in Tab A and the first Data Validation drop-down that would always be selected firstly is Option 1.

The process will follow that either Option 2 or Option 3 would be selected eventually.

Once Option 2 is selected it would automatically transfer the ENTIRE ROW to Tab B as a new entry and automatically remove the ENTIRE ROW from Tab A.

Once Option 3 is selected it would automatically transfer the ENTIRE ROW to Tab C as a new entry and automatically remove the ENTIRE ROW from Tab A.

We are not sure if this is possible, so we need a freelancer to confirm is the app is capable of this function before the project is rewarded.

Skills: Google Sheets

See more: automating google sheets, google sheets pull data from another tab, how to sort by row in google sheets, google apps script open file in new tab, google script open link in new tab, google sheets api create new sheet, google sheets sort by row, google sheets api append row, google sheets api append row example, google sheets api get last row, google sheets api append row python, google sheets append row, google sheets duplicate row, google sheets vlookup from another tab, post a new message to slack whenever a google sheets row is updated, google sheets importrange from another tab, google sheets automatically add formula to new row, google sheets copy row to another sheet based on cell value, google sheets send email when new row added, how to create new sheets for each row in google sheets

About the Employer:
( 21 reviews ) Sheffield, United Kingdom

Project ID: #22417416

10 freelancers are bidding on average £34 for this job


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Google Spreadsheet and VBA/Javascript programmer on and have been featured by the More

£150 GBP in 2 days
(2 Reviews)

" Completed more than 290+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Sa More

£20 GBP in 7 days
(1 Review)

Hi, I have understand the project requirement & interested to work for this project. Please send a message so we can discuss more & start the project. Thanks.

£20 GBP in 1 day
(1 Review)

Hi, it is possible in google sheets to automate the transfer of a Row to any tab based on selected criteria. I can do this job. Thanks

£20 GBP in 1 day
(1 Review)

__________________I am available right now______________________ Hi there, Quality and time is my commitment. I have done this many times, I want to say that, I will start right now and funds will be after your satisfa More

£15 GBP in 7 days
(0 Reviews)
£18 GBP in 1 day
(0 Reviews)

Hello, I am able to do the job mentioned in your project details. Also, able to handle the deadlines for the projects.

£10 GBP in 2 days
(0 Reviews)

"Dear Employer, I've read your necessities & I’m pretty confident that I'll be able to get your work done within the given time your desires conclude. I don't negotiate with the quality except quotation of project and More

£15 GBP in 7 days
(0 Reviews)

Hello, This work seems to be done. Can you give some detail or example file. It's possible if we draw the frame. I hope we could be in touch. Have a nice work, day.

£50 GBP in 7 days
(0 Reviews)

Hi, Its Google Silver Product Expert from GSheets(.)com having hands on experience in Google Sheets and Google Script which you can see on my website and youtube channel. You can see some of my work at: [login to view URL] More

£20 GBP in 3 days
(0 Reviews)