Đã Đóng

Improve an Excel Workbook usability

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.

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel, Kiến trúc phần mềm, Visual Basic

Xem nhiều hơn: 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

Về Bên Thuê:
( 1 Nhận xét ) London, United Kingdom

ID dự án: #19765379

44 freelancer đang chào giá trung bình $114 cho công việc này

jaylancer43

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 freelancer.com and have been featured by the freelancer community ( Thêm

$222 USD trong 3 ngày
(708 Nhận xét)
8.4
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 Thêm

$220 USD trong 4 ngày
(352 Nhận xét)
7.9
Webxpert4u

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 Thêm

$250 USD trong 3 ngày
(307 Nhận xét)
8.0
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 Thêm

$155 USD trong 3 ngày
(138 Nhận xét)
7.3
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 trong 3 ngày
(418 Nhận xét)
6.7
polarjin2017

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... Thêm

$155 USD trong 3 ngày
(134 Nhận xét)
6.9
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 trong 3 ngày
(134 Nhận xét)
6.4
wsh2

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 Thêm

$200 USD trong 7 ngày
(56 Nhận xét)
6.5
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 Thêm

$150 USD trong 2 ngày
(49 Nhận xét)
6.3
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 Thêm

$140 USD trong 1 ngày
(30 Nhận xét)
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 trong 3 ngày
(112 Nhận xét)
6.3
aubrey03

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] Thêm

$100 USD trong 2 ngày
(99 Nhận xét)
5.7
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 Thêm

$120 USD trong 3 ngày
(81 Nhận xét)
5.5
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 Thêm

$30 USD trong 0 ngày
(50 Nhận xét)
5.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 trong 1 ngày
(13 Nhận xét)
4.9
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 trong 10 ngày
(22 Nhận xét)
4.0
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 Thêm

$100 USD trong 7 ngày
(6 Nhận xét)
3.3
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 Thêm

$100 USD trong 0 ngày
(7 Nhận xét)
3.4
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 Thêm

$80 USD trong 2 ngày
(20 Nhận xét)
3.6
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 Thêm

$155 USD trong 3 ngày
(4 Nhận xét)
2.9