I have a google sheets spreadsheet with about 10 sheets. I need a convenient input sheet to do as follows:
1) Input sheet has a drop down menu asking to which tab I want to add a new entry
2) The input sheet pulls the columns from the tab selected
3) I can (a) add a new entry, (b) update a new entry or (c) move the entry to a different tab
4) The input sheet has to be flexible to let me choose which columns to add or ignore and to update if I add additional columns to the tab
5) The input sheet has to be flexible enough to include additional tabs if additional tabs are added to the spreadsheet.
6) I have to be able to update the code myself...meaning the code should not be hidden and inaccessible.
I run a law office and the spreadsheet has different tabs for different types of clients (for example: business law, estate planning, etc.). I know how to add an input sheet for each tab. What I want is ONE input sheet for all of them that I can use and select the tab I want to add to.
14 freelancers are bidding on average $169 for this job
Hello I have completed very similar tasks with great reviews. I am have years of experience with Google Sheets Script development. This project will be completed quickly. Regards Sean
I have read your requirements and I can do this error free. Relevant Skills and Experience I have experience of plus five years of using google sheet. I am well familiar of it.
I'm Professional Google Sheets and Excel expert, I love my job and i do my best for this work. My experience is relevant to you, I will be glad if we have a business relationship