Excel Drop Downs and Truncating

Probíhá Zveřejněno před 5 lety K zaplacení v momentě doručení
Probíhá K zaplacení v momentě doručení

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.

Zpracování dat Excel Visual Basic

Identifikační číslo projektu: #17083006

O projektu

39 nabídek Projekt na dálku Aktivní před 5 lety

Uděleno uživateli:

adrianaangaritam

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.

$13 USD za 1 den
(1 recenze)
0.0

39 Freelnceři na tento projekt zveřejňují nabídky v průměru $25

cgullapalli

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 Další

$15 USD za 0 dní
(947 Recenzí)
8.1
Teloquence

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.

$25 USD za 2 dní
(339 Recenzí)
7.7
P0L

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.

$30 USD za 1 den
(416 Recenzí)
7.7
zebracaro

I can do it for you quickly and exactly. Please contact me for saving your time and your money. .

$30 USD za 1 den
(130 Recenzí)
7.1
DeepSyaal

Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?

$20 USD za 1 den
(259 Recenzí)
6.6
customizedata

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 Další

$30 USD za 0 dní
(121 Recenzí)
6.6
periyannas

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.

$50 USD za 1 den
(131 Recenzí)
6.6
sloker18

I am proficient with excel macro/VBA development, I have reviewed your workbook, I can write the macro to create drop down as per your specification, I am available to start your project right away, feel free to messag Další

$25 USD za 1 den
(116 Recenzí)
6.4
rumarahman

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 Další

$25 USD za 1 den
(42 Recenzí)
5.2
nelumindralal

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

$25 USD za 1 den
(28 Recenzí)
4.6
swajantalukdar

available to start right now.

$35 USD za 1 den
(19 Recenzí)
4.4
haleem0786

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

$35 USD za 1 den
(27 Recenzí)
4.1
marudelavallaz

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

$25 USD za 1 den
(1 recenze)
3.7
lherreraz

Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas, functions and Macros using VB. I already checked the file Další

$25 USD za 1 den
(15 Recenzí)
3.8
CMaira

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

$30 USD za 0 dní
(4 Recenzí)
2.7
salimmurshed1111

sir,I can do anything by excel formulation, you can choose me for this work, I can make accounting finance calculator also

$15 USD za 2 dní
(2 Recenzí)
1.7
osamasuleman

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.

$18 USD za 1 den
(1 recenze)
0.3
natashaluke9

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.

$25 USD za 1 den
(0 Recenzí)
0.0
olaosunolayemi

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

$25 USD za 1 den
(0 Recenzí)
0.0
DazzlerFreelance

Have 6 years of expertise in excel, lets connect and get started on this to finish it fast Regards, Dinesh

$25 USD za 1 den
(0 Recenzí)
0.0