Færdiggjort

Excel data import and export into Xero

Our supplier (Ingram Micro) currently provide us an option to manually download all our sales (with multiple clients) from their web portal in an excel format to view our total monthly sales.

We are looking for an efficient way (custom tool, macros, form, VB etc) to be able

1. Download the data (Ingram Excel data will have far too many data, ie 30-40 row/fields) each month

2. We only need 4 fields to invoice our clients (Customer Name, Quantity, Product and Unit Price etc)

3. Need to be able to select different Customer for invoicing

4. Paste/import data into Xero excel format for invoicing

We are looking for something easy to use with minimal steps. Let me know what other information you would need.

I've added sample excel documents for you to review, please have a look

Regards

Sez

Evner: Excel, Visual Basic, Visual Basic for Apps

Se mere: php data import export, excel data import template, net data import export, magento commerce data import export, data import export philippimes, visual basic excel macro import export, visual basic excel macro import export 2007, 2005 program data import export, excel data import virtuemart, data import export vbnet, excel data import microsoft dynamics, excel qtpro import export produkte, excel vba import export, excel data import access crosstab queries, excel data import virtumart, magento data import export extension, vbscript data import export, magento excel data import

Om arbejdsgiveren:
( 0 bedømmelser ) Sydney, Australia

Projekt ID: #22683400

Tildelt til:

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] Flere

$200 AUD in 3 dage
(128 bedømmelser)
6.0

32 freelancere byder i gennemsnit $175 på dette job

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 Flere

$220 AUD in 3 dage
(327 bedømmelser)
7.9
sohandas

ok understood, i can make a python script for this, can you please message me so that i can demonstrate the proof of concept? thanks.

$250 AUD in 3 dage
(238 bedømmelser)
7.1
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Looking forward to working with you. Thanks & Regards Khushi India

$250 AUD in 5 dage
(250 bedømmelser)
7.0
RRconsultant

Greetings! I am a Chartered accountant with Silver Champion level certification from Xero. I am keen to help you with the requirements. Look forward to hear from you. Thanks, RRC

$250 AUD in 12 dage
(62 bedømmelser)
6.6
dvcontact

Hi, Would you like to see a quick demo of your project on developing a tool that can import/download sales information from a certain web portal into Xero Excel format completed before you award the project? You can co Flere

$150 AUD in 5 dage
(52 bedømmelser)
6.4
mateenbhatti94

Dear sir I will build the excel document that will do all these 4 steps that will help your work. I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me Flere

$150 AUD på 1 dag
(75 bedømmelser)
6.2
zu02

Hi I need format of downloaded Excel file(s) , then format of output Excel file. And better if you can prepare a little sample of income and outcome files with explanation of how calculates outcome file fields . Ho Flere

$250 AUD in 7 dage
(33 bedømmelser)
5.8
Ahmed818

Hello, ⭐⭐⭐⭐⭐ i am interested in this project , can begin now waiting your answer on chat Regards ⭐⭐⭐⭐⭐

$140 AUD in 2 dage
(52 bedømmelser)
4.5
pjlnel

Dear Sir or Madam, I am a South African based professional Accountant with a proven track record. My qualifications include a post graduate degree in Management Accounting. My software experience include but is not li Flere

$140 AUD in 7 dage
(2 bedømmelser)
2.5
DominikKrivarics

Hi, I can develop a custom excel macro for you that can streamline your workflow. Please send me some sample files first so I can get to know the project better. Thanks, Dom

$150 AUD in 7 dage
(5 bedømmelser)
2.6
mintu1302k

Hello! I am Excel, Access and VBA expert with 6+ year experience. I have good experience of lots of project in excel,access,outlook,word,power point, web scraping, manipulate data, linking to SQL Server and read data Flere

$100 AUD in 3 dage
(3 bedømmelser)
1.5
pushar71

we have a excel based invoice tool where it will pick the revevant fields and put them in to the invoice that you can save as PDF and send it to your end client. we can do a quick demo and make change to it as you need Flere

$140 AUD in 7 dage
(1 bedømmelse)
1.3
scripts24

Greetings Php Expert Technologies Pvt. Ltd.! Php Expert Technologies is a full service, design, and development company offering end to end technology solutions for mobile and web platforms. We have proven our expertis Flere

$250 AUD in 7 dage
(1 bedømmelse)
0.4
skoli0831

GOOD AT EXCEL AND DATA PROCESSING I DO THIS KIND JOB EVERY DAY AND I AM GOOD AT IT SO HIR ME GET YOUR WORK DONE

$190 AUD in 7 dage
(0 bedømmelser)
0.0
Rm507704

I need a work please send me project Relevant Skills and Experience I need a work

$155 AUD in 3 dage
(0 bedømmelser)
0.0
SimbaTeam

⭐Dear, client⭐ I've read your description and checked through your requirements. I can deliver this project perfectly. Look forward of hearing from you soon. Regards.

$250 AUD in 7 dage
(0 bedømmelser)
0.0
jayeshvs101

I'm am perfect for this job and have much knowledge in Excel and worksheet .so i want you to hand over the project to me and relax your work is done

$277 AUD in 4 dage
(0 bedømmelser)
0.0
manuelmata3000

Hello, I'm an excel specialist. Allow me to participate in this project you won't be disappointed. Regards

$120 AUD in 7 dage
(0 bedømmelser)
0.0
sailoganathan

Hi boss, Hope all is well!! We went thru your requirement. Hope .your project will be complete as per your terms. Why you offer us? We having a set of peoples with around 8 years experience in database handling, Flere

$140 AUD in 7 dage
(0 bedømmelser)
0.0
rajgurupramod21

Excel Expert with success in maintaining and organizing data, fill gaps, and sustain quality control [login to view URL] and exported data from text files, saved queries, or databases; used automatic outlining, inserte Flere

$140 AUD in 7 dage
(0 bedømmelser)
0.0