Find Jobs
Hire Freelancers

Excel form to be auto populated with data from a different worksheet in the same workbook

$10-30 USD

Closed
Posted over 5 years ago

$10-30 USD

Paid on delivery
Hello I have a small job which requires drop-down menus to be created and cells to be auto-populated with the information given in the worksheet. There are only 8 or so cells to format in this way so this will be an easy and quick job for anybody proficient with excel. Please have a look at the spreadsheet uploaded to have a good idea of the work required. Thank you
Project ID: 17697185

About the project

27 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
27 freelancers are bidding on average $31 USD for this job
User Avatar
Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 400 + projects with 100% client satisfaction. I can help you with Excel form to be auto populated with data from a different worksheet in the same workbook I have more than 5 years of the experience in Excel, Visual Basic Please ping me for more discussion. Thanks.
$150 USD in 2 days
4.9 (317 reviews)
7.9
7.9
User Avatar
Hello! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to create some drop-down boxes. However, in the attached preadsheet I saw that you'd like to have some cells automatically filled which can only be done through VBA code. Please, advise. I've delivered more than 240 projects in the last 5 years and this makes me very confident with your task. I can deliver the project within 1 day including all required revisions for $30. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon. Sincerely, Paris Pallas
$30 USD in 0 day
4.9 (214 reviews)
7.3
7.3
User Avatar
I can do it for you quickly and exactly. Please contact me for saving your time and your money .
$30 USD in 1 day
4.9 (120 reviews)
6.9
6.9
User Avatar
Hi I am expert in Microsoft Office specially Excel, Word and Access Database. Data Entry and Processing is my passion with years of experiences. I am talented and very hard working also know the value of time so, always try deliver work on time. My motive is to make my employer happy with quality of service. If you are looking for data entry work I hope to deliver you the best of best services. Hire me to get the job Expertise:
$19 USD in 0 day
4.8 (161 reviews)
6.5
6.5
User Avatar
hi sir, i will create the dropdown form in the sheet and based on user selection, will fetch the rest of the corresponding data from the second sheet in the same workbook, ready to do right now, thanks
$15 USD in 1 day
4.9 (332 reviews)
6.4
6.4
User Avatar
Hey Mate, This looks doable to me. I am an expert in VBA with over 5+ years of experience. Ping me to discuss more about budget and timeline Thanks A
$35 USD in 3 days
4.9 (173 reviews)
6.5
6.5
User Avatar
Hello, I am proficient with Excel and VBA. I would love to help with this project. Please contact me for more information.
$25 USD in 1 day
4.9 (137 reviews)
5.8
5.8
User Avatar
- Can get the drop downs created, have done dynamic dropdowns as well where in based on selection of the first the second dropdown will populate the values. Based on FundName drop down, the XD date would be populated (DropDown) - Based on fund code selciton the Fund Name PayDate DIvident OEIC Can be populated for the tasks. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables
$25 USD in 1 day
4.7 (50 reviews)
6.0
6.0
User Avatar
I can create the necessary drop downs and populate the remaining fields as mentioned in the attached file I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
$30 USD in 1 day
4.9 (89 reviews)
6.0
6.0
User Avatar
Hi, I am an excel VBA expert and this is a very easy job for me to execute. Please go through my profile so that you can be confident about me. Hope to chat with you soon Thanks Sajid
$20 USD in 1 day
4.9 (50 reviews)
5.4
5.4
User Avatar
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$100 USD in 3 days
4.8 (63 reviews)
5.6
5.6
User Avatar
Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, automatic simulators and charts drawing) as an Industrial Engineer at Michelin Romania. I am always keen to improve my work quality and productivity and, to achieve these goals, I made complex Excel sheets to automate my tasks and eliminate errors. I can finish this task in maximum 1 hour. I will be glad to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
$25 USD in 1 day
5.0 (19 reviews)
5.2
5.2
User Avatar
Hi, I have read the project description & seen the attached file. I can design a great Fund tracker with form control & dynamic for you. I can make any type of code to make excel automation. Please send a massage so we can discuss more. Thank You
$25 USD in 2 days
5.0 (12 reviews)
3.8
3.8
User Avatar
Hi there, i understand your requirement and if you need a sample work can provide. if you have any questions please let me know, can start now your project according to the your guide line with Confirmation.
$15 USD in 0 day
4.8 (10 reviews)
2.4
2.4
User Avatar
Hi I have gone through your job description . i am ready to do this task . Waiting for your reply Thanks
$15 USD in 1 day
5.0 (18 reviews)
2.4
2.4
User Avatar
Hi there, we can add some vba code to automate your requirements. I've been in excel vba macro for 3 years and currently creating company tools for users reporting. Willing to help you with your project, just let me know and we can discuss it further. Thanks, Marlou
$30 USD in 1 day
2.3 (6 reviews)
4.1
4.1
User Avatar
Hello Sir, i am expert in in excel formula and i will do this job in very cheapest rate just message me sir. i will sent you sample files than we can start work. message me sir. I am interested in Your Project, and make payments when your project done, we dont scam peoples here, talk first and when you satisfy than we star work, Regard, Muhammad Tahir
$10 USD in 1 day
1.5 (3 reviews)
2.9
2.9
User Avatar
Hello.. I understand the requirements and it is a simple data validation option that'll be done in minutes
$19 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, This is how may I help with your job post: 1. Dropdowns can be easily referenced from the XD Spreadsheet by using the name manager on each column and we can make it adjustable so that new entry in the XD Spreadsheet could be shown in the dropdowns. 2. For the date and time stamp, we can create a simple event handler in the worksheet using MACRO. In an event that there are changes in the entries of column C, Column D of the same row will reflect the Date/Time stamp. 3. For "Automatically populated from Column I", we can use either VBA code or VLOOKUP function to do the job. I am very much willing to discuss more this project with you. Thank you and have a nice day ahead! Jimboy
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
United Kingdom
4.9
4
Payment method verified
Member since Jun 10, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.