Fermé

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.

Compétences : Saisie de Données, Traitement de Données, Excel, Architecture Logicielle, Visual Basic

en voir plus : 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

Concernant l'employeur :
( 1 commentaire ) London, United Kingdom

Nº du projet : #19765379

44 freelance font une offre moyenne de $114 pour ce travail

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 ( Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(708 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(352 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(307 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(138 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(418 Commentaires)
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... Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(134 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(134 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(56 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(49 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(30 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(112 Commentaires)
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] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(99 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(81 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(50 Commentaires)
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 :)

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(13 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(22 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(6 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(7 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(20 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(4 Commentaires)
2.9