En cours

Excel invoice issues fix(using drop list and vlook up functions.)

The major thrust of the project is to generate an invoice in

excel on a third worksheet from the first and second worksheets which

contain customer and discounts data, product and price data

respectively.

The two functions in use are drop list and v-lookup functions. It is

expected that when a customer name is entered on the invoice all other

data should come up automatically. However, entering a customer name only

captures data in text, while numerical information such as the customer

code and discount rate is not captured.

Although, the numerical data can be obtained by using the customer code to

retrieve all relevant data for the invoice, the project requirement is to

be able to retrieve information using the customer name.

NB:

You will be expected to fix the issue with my attached excel invoice and also document a step by step approach on how the solution was reached.

THIS HAS TO BE FINISHED IN A MAXIMUM OF 5 HOURS IF YOU KNOW WHAT YOU ARE DOING

Compétences : Comptabilité, Traitement de Données, Excel, Gestion des Stocks, Traitements & Salaires

Voir plus : worksheet accounting, solution accounting, major issues accounting, know accounting, accounting name, excel invoice product list, v lookup, customer data excel, accounting price list, vlook, using generate, step up, price excel, numerical solution, invoice, invoice processing, excel accounting, come up, come name, accounting solution, excel accounting worksheet, fix excel, pending invoice, excel drop, product project excel

Concernant l'employeur :
( 155 commentaires ) birmingham, United Kingdom

N° du projet : #2409880

Décerné à :

jaimecruz

Hi I'm really interested in your project. I'm an Excel Expert Programmer.

30 $ USD en 0 jours
(9 Commentaires)
4.2

7 freelance ont fait une offre moyenne de 30 $ pour ce travail

bouslimi1979

Please check PM. Thanks

30 $ USD en 1 jour
(35 Commentaires)
5.4
binaryromel

=========== Excel Expert here! Please check PM. ===========

30 $ USD en 0 jours
(46 Commentaires)
5.2
ethicalboy

Hello, I like to work with you in this project.

30 $ USD en 1 jour
(29 Commentaires)
4.8
Engineer85

Hi i an excel programmer and interested in the job. Please send the excel sheet. Thanks

30 $ USD en 0 jours
(13 Commentaires)
4.4
suhailr23

Hello. I am willing to give it a try. Do send me the excel workbook. Thanks

30 $ USD en 1 jour
(0 Commentaires)
0.0
mutum

I think i'm very luck to found a job like this one. nut i'm new to this kind of job, with determination, I'll prove it you you all gyus that I have the ability to success.. please, consider me as one of your employed. Plus

30 $ USD en 5 jours
(0 Commentaires)
0.0