Improve an Excel Workbook usability

Zamknięty Opublikowano 4 lat temu Płatność przy odbiorze
Zamknięty Płatność przy odbiorze

Hi,

I have got an excel workbook which I need to improve the usability of and allow me to work faster.

The workbook has two sheets within it that work together. One is a list of around 500 item which have a description, and then a set of data that goes with it. On another sheet I create receipts. On the sheet that I create the 'receipts' I currently have a drop down menu linked to the price list, which I choose the name and then the other sets of data automatically gets entered. This way of working is not the fastest, instead of a adrop down menu, I need to start typing and allow excel 'flash fill' the entries from the price list.

Please let me know if you have any ideas on how I can improve the usability of this workbook.

Thanks.

Wprowadzanie danych Przetwarzanie danych Excel Architektura oprogramowania Visual Basic

Numer ID Projektu: #19765379

O projekcie

40 ofert Zdalny projekt Aktywny 4 lat temu

40 freelancerów złożyło ofertę za $114 w tym projekcie

schoudhary1553

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 Więcej

$220 USD w ciągu 4 dni
(635 Oceny)
8.6
zekovicm

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 Więcej

$155 USD w ciągu 3 dni
(222 Oceny)
8.1
rinabuoy13

Hello, I am an independent, experienced excel expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.

$55 USD w ciągu 3 dni
(177 Oceny)
6.9
dvcontact

Hi, I have examined your project description about improving Excel workbook usability for faster data entry. You can be confident that this project will be professionally completed. Rather than just show you past simi Więcej

$150 USD w ciągu 2 dni
(75 Oceny)
7.0
rohitagarberg

HI Sir I will write a function that will be auto linked to the first sheet and will fill data on type the item on the cells Regards

$90 USD w ciągu 3 dni
(579 Oceny)
7.0
RavinduJayzz

Hey there ! I would love to help you out with this project. I am an Excel Expert and a detail oriented person. Check my reviews to an idea about my work. Hope to hear from you. Thanks :)

$50 USD w ciągu 1 dnia
(71 Oceny)
6.4
mascotindia123

Hello, It would be great to get on board and support the growth of your company. I am great at data entry, very accurate and also experienced in databases - I know how important it is to have clean, well structured d Więcej

$140 USD w ciągu 1 dnia
(33 Oceny)
6.2
razvancotofana

Hello Mar, I'm well experienced in excel and I can come up with some creative ideas on how to improve your user experience. I would appreciate if you can send me the file so I can give you my feedback. BR, Razvan

$50 USD w ciągu 7 dni
(21 Oceny)
6.1
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entry, excel

$98 USD w ciągu 3 dni
(113 Oceny)
6.3
vsprybhanu

Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Więcej

$120 USD w ciągu 3 dni
(147 Oceny)
6.2
sorinacho88

Hello, Please read below what I can do for you. 1. Double click the cell 2. An entry box will pop up with autocomplete 3. Hit enter or click ok and all info will be added to the relevant place. This is done Więcej

$30 USD w ciągu 0 dni
(80 Oceny)
5.7
paulodayto08

Hi Good Day! A serious freelancer here. I've done a lot of work like this as a Project Management Officer. I can help you with this project. I know what you are saying. Please consider my bid. With my experienc Więcej

$80 USD w ciągu 2 dni
(79 Oceny)
5.4
Excel4You

Hi! Your task is clear for me. I'm going to implement a kind of user friendly interface for your Excel file.

$150 USD w ciągu 10 dni
(23 Oceny)
4.6
JSAConsultants

Hey! Please contact me first before placing any order. I am a qualified chartered accountant and working in an Audit/Consultancy firm as an auditor from 7 years. I had done ACCA, ICAEW, ICAP.I have experienced more tha Więcej

$100 USD w ciągu 7 dni
(16 Oceny)
4.5
Monirulop

Hi, I am Monir and it will be my pleasure to assist you with this project. I have read your project description. You can expect from me I strong commitment to a deadline, the highest quality, and a fluid/friendly com Więcej

$100 USD w ciągu 0 dni
(31 Oceny)
4.1
nishajaryal37

Hello there, I am Nisha(Data Entry Expert) with experience of more than 5 years. I worked for multiple clients internationally and made them happy by providing them more than their expectations. I have expertise Więcej

$155 USD w ciągu 3 dni
(5 Oceny)
3.0
ska5761b99170406

Dear Sir/Madam, I have gone thru your requirement and i believe i am excellent candidate for this project i am an excel expert with 11+ years of work experience i can give you a lot of ideas once i look at the data. Więcej

$50 USD w ciągu 3 dni
(6 Oceny)
2.8
PageOllice

Hello Dear, I have expertise in data management and analysis data. I like to search the internet and to do research work. I am interested in your project and invite you to discuss in details. Looking forward to hear Więcej

$40 USD w ciągu 3 dni
(3 Oceny)
2.4
kohencpa

Hello, I am an accountant with advance excel skills. I can convert pdf files and format them to your liking. I write complex formulas, pivot tables and Vlookups as well as VBA Macros. Please contact me and we will get Więcej

$111 USD w ciągu 2 dni
(2 Oceny)
2.1
techlinesols6

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do th Więcej

$225 USD w ciągu 7 dni
(4 Oceny)
2.7