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

Beceriler: Excel, Visual Basic, Veri İşleme, Excel VBA, Excel Macros

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Monterey, United States

Proje NO: #21073930

Bu iş için 23 freelancer ortalamada $162 teklif veriyor


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 Daha Fazla

$300 USD in 3 gün içinde
(722 Değerlendirme)

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 Daha Fazla

$250 USD in 5 gün içinde
(338 Değerlendirme)

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 in 3 gün içinde
(310 Değerlendirme)

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 Daha Fazla

$155 USD in 3 gün içinde
(120 Değerlendirme)

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 in 3 gün içinde
(330 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(265 Değerlendirme)

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 Daha Fazla

$180 USD in 4 gün içinde
(231 Değerlendirme)

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 Daha Fazla

$175 USD in 3 gün içinde
(87 Değerlendirme)

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] Daha Fazla

$250 USD in 3 gün içinde
(127 Değerlendirme)

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 Daha Fazla

$100 USD in 3 gün içinde
(57 Değerlendirme)
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(51 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(32 Değerlendirme)

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 Daha Fazla

$225 USD in 4 gün içinde
(10 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)

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 Daha Fazla

$100 USD in 2 gün içinde
(1 Yorum)

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 Daha Fazla

$100 USD in 3 gün içinde
(1 Yorum)

( ͡ᵔ ͜ʖ ͡ᵔ ) 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 in 7 gün içinde
(0 Değerlendirme)

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 Daha Fazla

$250 USD in 7 gün içinde
(0 Değerlendirme)

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 Daha Fazla

$120 USD in 7 gün içinde
(0 Değerlendirme)

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 Daha Fazla

$140 USD in 7 gün içinde
(0 Değerlendirme)