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
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] Daha Fazla
Bu iş için 32 freelancer ortalamada $175 teklif veriyor
Hi, I understand the project requirements and willing to start as soon as possible. Looking forward to working with you. Thanks & Regards Khushi India
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
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 Daha Fazla
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
⭐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.
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