csv to Excel AUTOMATIC allocation of figures

Geschlossen Veröffentlicht Nov 7, 2014 Bezahlt bei Lieferung
Geschlossen

Hi there.

We are stocktakers for pubs and need to enter the till sales into our Excel report.

We are often given csv or Excel files which we manually enter into our Excel spreadsheet.

I dare say it's pretty easy to convert the csv file to Excel, but I was just wondering....

a. Is it possible to *automatically* allocate the appropriate figures into our spreadsheet ?

ie. Lets say the first product on the till report is Bacardi and it has sales of £100. Is it possible from a press of a button for Excel to read the word Bacardi and then allocate £100 worth of sales against this product in our spreadsheet ? Obviously then do the same for every product on the customer's till report.

b. Probably much harder, but sometimes we are given a printout. Is it at all possible to scan the sheets, convert the PDF to Excel and then allocate all the amounts as above ?

It would be great to hear what is possible.

Thanks.

Fahrzeug Ingenieurwesen Excel JavaScript PHP

Projekt-ID: #6701048

Über das Projekt

25 Vorschläge Remote Projekt Aktiv Dec 14, 2014

25 Freelancer bieten im Durchschnitt $13/Stunde für diesen Job

rajeshsonisl

Hello! With 99% completion rate, 720 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page https://www.freelancer.com/u Mehr

$42 USD / Stunde
(539 Bewertungen)
7.5
shikhamehta

Hey, I am an expert in excel based automation solutions as you will see in my work history here on freelancer. For your purpose, I can create a macro that will take the customer's till report as input and allocate the Mehr

$11 USD / Stunde
(200 Bewertungen)
6.8
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Mehr

$11 USD / Stunde
(76 Bewertungen)
5.8
goswamiarpit475

Hi, I am ready to work for you.I have 4 years of experience in Php with all version/sql. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within time fram Mehr

$10 USD / Stunde
(31 Bewertungen)
5.6
best4best

Hi, Option "a" is possible, but option "b" is not as you first need to convert the data from scanned file to Excel with OCR software. That data need to be checked manually for accuracy before processing in Excel. Mehr

$11 USD / Stunde
(86 Bewertungen)
5.5
ethicalboy

Hello, answer to your first question is yes and it can be done using a macro, also let me know if you are using mac or windows but answer is to your second question is negative since it needs a very strong application Mehr

$10 USD / Stunde
(57 Bewertungen)
5.1
JonNxt

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing / debugging VBA code. You may check my portfolio Mehr

$10 USD / Stunde
(33 Bewertungen)
4.8
sakhunzai

Hi there , I would like to see a) sample excel file , with sample data file to be filled b) Do you use excel sheet as database ( complex scripts and calculations added ? ) c) For scanning the document into p Mehr

$11 USD / Stunde
(5 Bewertungen)
4.1
avinashjain09

Hello, Can we have more discussion on your project. From excel to csv and from csv to excel is possible. And it is also possible that you enter the data in a web form and you can get the result in the form of excel or Mehr

$10 USD / Stunde
(13 Bewertungen)
4.0
GabrielSoare

Propunerea nu a fost încă furnizată

$20 USD / Stunde
(7 Bewertungen)
3.6
nikopolidis

A proposal has not yet been provided

$10 USD / Stunde
(2 Bewertungen)
2.8
renesontiongson

Hi! excel automation is my masterpiece in my accounting field. Feel free to message me with your actual data and start the work after you reward me. Thank you.

$10 USD / Stunde
(4 Bewertungen)
2.3
TonmoyRoy111

Dear Sir, I ensure you of completing the project within the specified time.I have a previous experience of Data Compilation. Besides I am an Electrical Engineer and currently working in a reputed Power Plant in Ind Mehr

$10 USD / Stunde
(4 Bewertungen)
2.2
solutionland2014

HI I'm an IT student with good knowledge in excel and macro. I can help you to do your job. a. is possible but about b, it's depand on pdf format, for some item possible and for some item we loose some date and str Mehr

$10 USD / Stunde
(6 Bewertungen)
2.0
prabakarm23

Greetings for the Day!!! i have 5 years of experience in Data entry and typing , Excel macro, VB script and VB application creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, M Mehr

$11 USD / Stunde
(4 Bewertungen)
1.8
AlexandrK1

please send the csv file, i can complete it in 1-2 days .

$11 USD / Stunde
(5 Bewertungen)
1.7
macroPOL

Hello, Yes it is possible (a. and ie.). b. is not possible. Could you send a sample csv file and you excel report file? I am sure that the job is easy and should not take a long time. I'm Excel and VBA prog Mehr

$10 USD / Stunde
(2 Bewertungen)
1.1
abagunjal

it is possible to update specific cell of excel sheet. about scanning the pdf and getting the specific number, I need to check.

$33 USD / Stunde
(0 Bewertungen)
0.0
parthiv88

A proposal has not yet been provided

$11 USD / Stunde
(0 Bewertungen)
0.0
zheiva

Предложение еще не подано

$11 USD / Stunde
(0 Bewertungen)
0.0