csv to Excel AUTOMATIC allocation of figures
$10 USD / Stunde
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.
Projekt-ID: #6701048
Über das Projekt
25 Freelancer bieten im Durchschnitt $13/Stunde für diesen Job
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
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
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
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
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
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.
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
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
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
it is possible to update specific cell of excel sheet. about scanning the pdf and getting the specific number, I need to check.