Excel lookup datas from different worksheet and create invoice packing list and cover note (3 macro need to write)
$240-2000 HKD
Terminado
Publicado hace más de 6 años
$240-2000 HKD
Pagado a la entrega
I need Macro to finish the job automatically .
Open Invoice (template1 ), i will input all data in sheet "INPUT"Row 1-100
The Macro can according to PI number at Cell A1, C1,E1 ..... and lookup data ITEM NO, QTY, DESCRIPTION, UNIT PRICE ........ from "connect [login to view URL] Sheet MPRO_INV , [login to view URL]
Then output results to [login to view URL] Sheet Invoice1 start from ROW25, Invoice2,Invoice3 ....... Packing1 ROW15, Packing2,....... and add Jpg as signature chop at end of the contents .
The most important when amend Quantity and Unit price manually , the total amount must update.
I am not a random bidder. I hope I can do this one. Could you please provide the excel sheet that has these information. Please ping me if you are happy with my proposal.
Relevant Skills and Experience
VBA
Proposed Milestones
$1500 HKD - final payment
$1.500 HKD en 5 días
4,9 (16 comentarios)
4,7
4,7
15 freelancers están ofertando un promedio de $1.100 HKD por este trabajo
I am an Excel Macro specialist. I am confident that I can create the macro you need because I have a lot of experience in process automation. You may check the feedback in my profile.
Hello Sir,
I have read your project requirement and i can deliver your project with 100% quality . please give me chance to work on your job.
Relevant Skills and Experience
I have more than 7 years of experience in Excel Macros, Excel VBA . Please see my profile i have deliver almost 270 projects with 100% client satisfaction.
Proposed Milestones
$1500 HKD - Excel lookup datas from different worksheet and create invoice packing list
Hi there, I am Expert in Financial macros and can do this job with excellence. Thanks
Relevant Skills and Experience
Excel VBA, Finance
Proposed Milestones
$800 HKD - Milestone
I have expert team for your Excel Macros, Excel VBA project works, I have 50+ employees in my company they are ready to start works on your projects.
For details please contact with us.
Relevant Skills and Experience
My team has data entry, Data Processing, Excel's Excellently good experience, they have been work doing this for the past 1 year.
Proposed Milestones
$1244 HKD - We will finish this work as soon as possible, because it is a team work, you feel better
Hello, I'm ready to start work on it, I have experience more than 10 years in Excel VBA, and I hope to give me the chance to work.
thank you.
Stay tuned, I'm still working on this proposal.
Dear Client,
I am a management graduate has 10 years of experience in Sales and business statistics analysis. I am good in summarising and compiling research and survey reports.
Few of my works in Excel and Excel VBA are attached to my portfolio I invite you to visit to know more about services.
Skills relevant to your project
1. MS Excel and VBA
2. Business data analysis
3. Business presentations
4. Business Letter writing
5. Performance analysis formats
Thank you,
Sumesh MS
I think my profile is suitable for your work. I have been working with such projects for a very long time and im sure i will complete it accurately and within the given time. It would be greatly appreciated if you give me a chance to work with you.
About me,
Im Prakash, working as an Apps System Engineer / Application Programmer in an MNC and i have 3+ years of experience in various projects like VBA Automation, MIS Reporting , Dashboard , Database Designing and Implementation, MSBI (SSIS and SSRS) projects, MS SQL Server projects , VBA user forms and web scraping projects etc with team as well as individual contributor. Im interested to undertake freelancing works and complete them as per stipulated SLA.
Thank you.
Hey I am new here . I have worked in a multi national data analytics firm for 3 years on various tools such as R, Excel, SAS and tableau. I can assure you good quality and in time completion of your report. Please give me once chance to prove myself.