Improve an Excel Workbook usability


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.


Evner: Dataindførsel, Databehandling, Excel, Software Arkitektur, Visual Basic

Se mere: excel workbook software, convert excel workbook windows application, convert excel workbook, large amount of text in excel cell, how to style excel spreadsheet, how to make an excel spreadsheet look professional, how to make excel spreadsheet, easy to read excel spreadsheets, how to design excel sheet, how to make an excel spreadsheet look nice, how to improve excel spreadsheet, convert excel workbook stand alone application, convert excel workbook standalone, data excel workbook master workbook using vba, convert excel workbook visual basic, upload excel workbook turbolister, excel workbook update service, convert excel workbook stand alone program, excel workbook packaged standalone software, excel workbook project tracker

Om arbejdsgiveren:
( 1 bedømmelse ) London, United Kingdom

Projekt ID: #19765379

44 freelancere byder i gennemsnit $114 på dette job


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( Flere

$222 USD in 3 dage
(708 bedømmelser)

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 Flere

$220 USD in 4 dage
(352 bedømmelser)

Hello, I am ready to improve your current excel sheet to its works much better. I need to discuss in details before starting. Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Flere

$250 USD in 3 dage
(307 bedømmelser)

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 Flere

$155 USD in 3 dage
(138 bedømmelser)

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 in 3 dage
(418 bedømmelser)

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... Flere

$155 USD in 3 dage
(134 bedømmelser)

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 in 3 dage
(134 bedømmelser)

Greetings from Easton PA, USA.. {smile} Highly experienced (25+ years) MsACCESS/MsEXCEL/SQL/VBA Business Information, Programming, and Database expert with Guru / Mentor level technical credentials at www.experts-exch Flere

$200 USD in 7 dage
(56 bedømmelser)

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 Flere

$150 USD in 2 dage
(49 bedømmelser)

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 Flere

$140 USD på 1 dag
(30 bedømmelser)

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 in 3 dage
(112 bedømmelser)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Flere

$100 USD in 2 dage
(99 bedømmelser)

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 Flere

$120 USD in 3 dage
(81 bedømmelser)

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 Flere

$30 USD in 0 dage
(50 bedømmelser)

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 på 1 dag
(13 bedømmelser)

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

$150 USD in 10 dage
(22 bedømmelser)

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 Flere

$100 USD in 7 dage
(6 bedømmelser)

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 Flere

$100 USD in 0 dage
(7 bedømmelser)

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 Flere

$80 USD in 2 dage
(20 bedømmelser)

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 Flere

$155 USD in 3 dage
(4 bedømmelser)