Google Sheets/Excel Drop-Down Menu Dev

Develop a Google Sheet for the purpose of maintaining a musical group's repertoire and set lists (lists of songs to be played at a concert).

** See youtube link

[login to view URL]

* Sample google sheet with all the data will be provided

* Sample excel file is attached that accomplishes the drop down menu/referencing (Setlist [login to view URL])

Develop a Google Sheet that accomplishes the following specifics:

- A sortable MASTER Sheet that contains a master list of a musical repertoire.

- TABS (additional sheets) that contain dropdown menus to select songs from the MASTER sheet.

The MASTER sheet.

The master sheet is a list of songs, their composer, arranger, length in minutes, genre, status (how the band sounds), Practice Link, and Notes. The master list is a constantly changing list that has additions and edits continually.

Special considerations within the master sheet:

- Must support conditional formatting (for color coding the status)

- Ability to sort the rows by, for example, Genre (this is built into Google Sheets’s functionality), without affecting the tabs

- Ability to add new rows without affecting the data in the tabs. For example, a set list is generated in the TAB, then a new song is added to the MASTER repertoire list. This new song addition should not affect the data in the tabs. Contrarily, if a Status is changed from a “2” to “3” on the MASTER list, this should be reflected in the tab. Similarly, if a spelling correction is made to a song in a row on the MASTER index that is being referenced by a TAB, this correction should be reflected in the TAB.


The TAB is another sheet that serves as a “set list” for a band performance (a list of songs that the band will play for a concert). The TAB will have a dropdown list that allows user to select from a list of songs to add to the “set list”.

Special considerations for the TABS

- Need to have a template set list sheet that can be duplicated for when new performances are scheduled

- Drop down menus allows the user to select a song, and the data displayed in the TAB will include the full row of information referenced in the MASTER list

- A summation that adds up the total time of the songs

- Formatting the same as the example workbook

- Ability to reorder the rows independent of the data from the MASTER list. In other words, the MASTER index should be able to be sorted by column without changing the sorting on a TAB. Similarly, a TAB should be able to be sorted without changing the sorting on the MASTER.

** The song selected via drop down in each TAB must reference an entire row from the MASTER index. Then, if the data in the MASTER changes, this change shall be reflected in all of the TABS.

- Example workbook is attached that contains drop downs. This doesn’t work for me because I cannot reorder the songs in each set list, and I’

- Data sheet is linked to look at the data (the MASTER list of songs two exmaples of TABS (set lists)

- Video with explanation is attached

Kemahiran: Excel, Visual Basic, Pemprosesan Data, Excel VBA, Excel Macros

Lihat lagi: latest project assistant part time working hanoi, add project references install time, project plan website time plan, joomla project fork log time, needs project addresses real time video streaming, project jobs part time, mobile dialer project estimation duration time development, project attiny2313 delay time, project camping button time, project management competencies time spreadsheet, project management real time iphone, project related college time table management college source code, project report real time clock ds1307, matlab signal process project code explanation, net project work part time, project cartoon explanation, online project work part time work, deleted project

Tentang Majikan:
( 0 ulasan ) Monterey, United States

ID Projek: #21073930

23 pekerja bebas membida secara purata $162 untuk pekerjaan ini


Hello, 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 freelancer.com and have been featured by the fre Lagi

$300 USD dalam 3 hari
(722 Ulasan)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Lagi

$250 USD dalam 5 hari
(338 Ulasan)

Hello, I’m a Google Sheets expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$200 USD dalam 3 hari
(310 Ulasan)

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed Lagi

$155 USD dalam 3 hari
(120 Ulasan)

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$150 USD dalam 3 hari
(330 Ulasan)

HI, I have better idea to achieve, what you are trying to get. I will create a small GUI in google sheet using Html/CSS and javascript. It will user friendly GUI, which will help you add/remove songs to be played. An Lagi

$55 USD dalam sehari
(265 Ulasan)

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Lagi

$180 USD dalam 4 hari
(231 Ulasan)

Hi there, I am an Excel expert with over 17 years of experience and I'd love the opportunity to build out your Google Sheet based set list tool. The specs you have listed along with the video (super helpful by the way Lagi

$175 USD dalam 3 hari
(87 Ulasan)

I am a Google Sheets, Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL] Lagi

$250 USD dalam 3 hari
(127 Ulasan)

Hi, I am an excel VBA expert and proficient in google spreadsheet. Thank you for sharing the link as it explains almost all aspects of this project. However, we can always discuss if you want something more to be adde Lagi

$100 USD dalam 3 hari
(57 Ulasan)
$100 USD dalam sehari
(51 Ulasan)

I am postgraduate with more than 6 years of experience in advanced excel based tools, VBA automation, Google spreadsheets, google scripting and data processing. I have successfully completed similar projects, please h Lagi

$90 USD dalam sehari
(32 Ulasan)

Hello Employer, I have gone through the project requirement and everything is clear to me. I am ready to discuss on the project. We are sincere and experienced data entry/processing team. Have fast typing skill and Lagi

$225 USD dalam 4 hari
(10 Ulasan)

Hi,sir. I am super interested in your project - 'Google Sheets/Excel Drop-Down Menu Dev' :) I believe that my 12+ years of experience in development makes me highly qualified for this project. I'm sure that I would be Lagi

$155 USD dalam sehari
(7 Ulasan)

Hi there I represent SuperSimpleCloud and we specialize in Google Sheets and other Google Apps development. In fact, I've made a working proof of concept of your requirement to demonstrate to you our ability to do this Lagi

$100 USD dalam 2 hari
(1 Ulasan)

Hello. I have just read your requirements and I am really interested in your project. I have rich experiences in Excel and VBA. I can also inject DLL files for security of functions. You can communicate with me at any Lagi

$100 USD dalam 3 hari
(1 Ulasan)

( ͡ᵔ ͜ʖ ͡ᵔ ) Hi, Dear. I saw your posting with interesting. I have experience with your request skills. So I think I can solve your project asap I will wait for your response. Kindly regards.

$250 USD dalam 7 hari
(0 Ulasan)

Hi, I’ve read your Job description and I have also gone through the files you have attached. You are looking for an MS Excel and Google sheets expert and this is what I specialize in. I can help you in creating a goog Lagi

$250 USD dalam 7 hari
(0 Ulasan)

Thanks for sharing details of the job description. I am interested in this opportunity. Kindly find my profile summary below I have work experience of over 25 years working in the various finance segment. Complete kno Lagi

$120 USD dalam 7 hari
(0 Ulasan)

I have excellent knowledge of MS office with excellent typing speed. I can assist you with any kind of Data entry work. I assure you 100% Quality of work delivered. I can perform any kind of copy paste data on websites Lagi

$140 USD dalam 7 hari
(0 Ulasan)