Excel Drop Downs and Truncating
$10-30 USD
Paid on delivery
I have a quick and easy project I need some assistance with. I have attached an example of the data and what I'm looking for. The yellow columns in Sheet2 are what I'm looking to automate.
I want to populate drop down boxes in column D on Sheet 2 with the rows from Sheet1. For example, I want D2 on Sheet2 to have the data from row 2 (2017) to be in the drop down box. I mocked it up on the sample, but I need to be able to do this across ~500 rows so I want it to automatically make a drop down based off of matching columns A in Sheet1 and Sheet2.
Then I would like it to break out the result across columns E-H as I mocked up in Sheet2.
Hopefully this is quick and easy for someone that is good at this stuff. I want it to be easily expandable so I can self serve on the additional rows. Looking for someone that is online now so they can ask questions and could do this right away. Thanks.
Project ID: #17083006
About the project
Awarded to:
I do that kind of job very easily. I have and example I made yesterday. If you wnat it I can Show you an example. I can do it with a formula. Zero mistakes.
39 freelancers are bidding on average $25 for this job
HI, I am good at Excel and formulas (Data validation) I have reviewed the requirement and i can use offset to get the data into the dropdowns as required and then separate the text as required. Looking forward More
Excel expert at your service. Please check my past reviews for your reference. Looking forward for your message so that i can quickly implement the solution.
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
I can do it for you quickly and exactly. Please contact me for saving your time and your money. .
Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
I have download that attached excel file. Please message me so that we could discuss in details. I would start work on it it right now. 1-I would write VBA to fill dropdown for each row from sheet1 D column. 2-Vba More
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.
I have 10 years experience with Data Processing in Excel and Web Researching. I work with: Web Search Web Scrapping Excel Access PowerPoint Statistics Data Processing Data Collecting (Using Macro) M More
Hello, I went thru the description. This project can be done by today Kindly contact me and you can see my previous projects and reviews I look forward to hearing from you Thanks regards Thushara
i can do this, please review my profile and inbox me. i have good command over ms excel especially pivot table, charts, advance formulas,etc. i have done this before. Thanks
I can Help you I am an excel expert. I have lots of experience in analizing data and building control panels in global companies I will do my best to have this done asap and with good quality
Hello, I am online write now and looking at your spreadsheet. I would be glad to do this work for you but I have a couple of questions. Regards, Crystal
sir,I can do anything by excel formulation, you can choose me for this work, I can make accounting finance calculator also
hello we are a team of MS Office expert we can help you automate your excel sheet as required by you. let's chat to discuss it further and get your job done at the earliest.
Am well versed with the Microsoft Excel projects. Though I do not prove using this site, I have done a couple of the in past job sites. Accept my bid for a guaranteed well done work.
I am available to assist in carrying out the project. I am versed with Drop down list and data validation. Put me in the Job and let's make it a success
Have 6 years of expertise in excel, lets connect and get started on this to finish it fast Regards, Dinesh