Excal vba sheet

£20-250 GBP

W trakcie realizacji

Opublikowano

12 miesięcy temu

£20-250 GBP

Płatne przy odbiorze

Excal VBA Sheet for Automated Calculations of Sales Data We are looking for a VBA expert to help us create an Excal VBA sheet that can perform automated calculations for our sales data. The ideal candidate should have experience in VBA programming and data analysis. I have a daily sheet that we need to move data from one sheet oto a new layout including inserting new row and taking dats fro existing row List oif things Take list Arrange in order from Column D (customer) A1 ='order-item-details (14)'!AV2 But A2 stays blank until it changes from the line above then insert new Column J1 Inv 2572 remain the same until Column A changes the J1 + 1 K = the range of orders in column c fo that customer example k5 this repeats until customer changes L= ='order-item-details (14)'!AV2 M=='order-item-details (14)'!AV2 +7 days P ='order-item-details (14)'!C2&" "&'order-item-details (14)'!BF2&" "&'order-item-details (14)'!BH2&" "&'order-item-details (14)'!BG2 =Q2 R='order-item-details (14)'!BJ2 T= “4021” U= “20%(VATon Income)” AB= “Invoice” Adding delivery to each order insert a delivery row using the info from the first line of that order number Every time column K changes insert line P= =='order-item-details (14)'!AE21 T = 4014 U= “20%(VATon Income)” AB= “Invoice”

Excel

Visual Basic

Visual Basic for Apps

Data Processing

VB.NET

Identyfikator projektu: 36615674

Informację o projekcie

60 ofert

Zdalny projekt

Aktywny rok temu

Szukasz sposobu na zarobienie pieniędzy?

Adres e-mail

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe

Otrzymuj wynagrodzenie za swoją pracę

Przedstaw swoją propozycję

Rejestracja i składanie ofert jest bezpłatne

Przyznano:

@umairnoor32

Hello Sir, I have read your instructions and I can do it efficiently. Please give me this project. i will never disappoint you regarding your work and I will give you unlimited revisions with 100% quality work. Thanks. Regards, UMAIR

£40 GBP w 1 dzień

5,0

(45 opinii)

4,0

60 freelancerzy składają oferty o średniej wysokości £131 GBP dla tej pracy

@schoudhary1553

Hello, my name is Sandeep and I am a Full-Stack developer with 7 years of experience in the industry. I specialize in web scraping, web automation, and coding useful scripts. I understand you are looking for a VBA expert to help you create an Excal VBA sheet that can perform automated calculations for your sales data. As a result of this project, you would like me to develop an Excal VBA sheet that can be used to perform automated calculations for your data. I am confident that my experience with VBA programming and data analysis make me the best fit for this job. Additionally, I guarantee 100% employer satisfaction as well as fast completion times with low speed guarantees (best speed guaranteed!). If you choose me for this project, you can rest assured that you will be receiving top quality work within the timeframe agreed upon at no additional cost.

£150 GBP w 2 dni

4,9

(588 opinii)

8,5

@P0L

Hello, I am an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Best regards.

£150 GBP w 3 dni

5,0

(507 opinii)

8,1

@maverick44000

Hello Sir, Being highly skilled in Excel, I can achieve the mentioned tasks within a few hours. Please share the sheet and invite for a chat. Thank you, Usman

£120 GBP w 1 dzień

5,0

(96 opinii)

7,1

@zebracaro

I can do it for you quickly and exactly .Please contact me for saving your time and your money .

£100 GBP w 3 dni

4,9

(136 opinii)

7,2

@nimiwebjuggler

Hi, I am an Excel Expert with Professional experience working with Excel. I believe I can do great work for you and ensure your quality. I have more than 5 years of experience with excel. Complete a lot of jobs on Freelancer with high satisfaction of the client.

£250 GBP w 2 dni

5,0

(136 opinii)

6,7

@Giovanni704

Hi there! As I have read, I see you need help creating VBA sheets and I could help you! I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front. I always meet delivery deadlines working until I get the desired results. I know all the most used softwares to do this project specifically, I could even give you some other options in case you think is better to use other tools. Send me a message so I can show you my previous work and we can discuss more. Best regards, Giovanni.

£20 GBP w 1 dzień

4,9

(57 opinii)

6,9

@SShtv

Hello, I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and macros.

£150 GBP w 3 dni

4,9

(131 opinii)

6,6

@liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. ..

£250 GBP w 4 dni

5,0

(11 opinii)

6,3

@Devrits

Hi! I am professional VBA computer programmer with skills including Visual Basic, Excel, Data Processing, Visual Basic for Apps and VB.NET. I am Database/VBA/SQL Developer Master of Computer Science with 25+ years experience. Database Development: Backend & Frontend, SQL, query profiling, VBA. MS Access, SQL Server, MySQL, PostgreSQL. Developing and supporting DB for Finance/Accountancy, DM, CRM, ERP, ETL etc. MS Office automation: Access/Exce/Word/Outlook. Macros, VBA, API integration. Google Docs automation. System administration tools for Linux using bash, ruby. Data syncing, encryption, automation. The key focus is to deliver time-saving, user friendly and easy to use applications. Please contact me to discuss more about this project. Thanks & regards

£120 GBP w 4 dni

4,9

(71 opinii)

6,3

@rabbiawebjuggler

Hi I am expert in excel having experiance in excel and work with 100% accuracy and quality.,,,,,,,,,,,,,,,,,,,,,,,,,,

£399 GBP w 3 dni

5,0

(77 opinii)

5,8

@vsprybhanu

Hi, I can develop Excel VBA Macro as per your requirements. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more detail. Thanks, Virendra

£45 GBP w 3 dni

4,8

(145 opinii)

6,2

@lkhelladi

Hello, Id be glad to develop the VBA macro for you. Looking forward to chatting with you soon for more details. Best regards.

£170 GBP w 2 dni

5,0

(22 opinii)

5,6

@saliba04

Hi there, With my extensive experience in Excel, I propose to create an Excel VBA sheet for automated calculations of sales data. I will utilize VBA programming and data analysis skills to move data, insert rows, and perform calculations based on specific criteria. By arranging and organizing the data according to your requirements, I will ensure accurate and efficient processing of the sales data. As an Excel expert, I am confident in delivering a functional and reliable solution for your automated calculations. Please chat to discuss further.

£135 GBP w 7 dni

4,8

(91 opinii)

6,0

@marfan080

Hi there! My name is JUNAID and I am a professional Excel VBA, Google Sheets, PDF and Data Entry expert. I understand that you are looking for a VBA expert to help you create an Excal VBA sheet that can perform automated calculations for your sales data. Specifically, we would like you to help us move data from a daily sheet into a new layout including inserting new rows and taking data from existing rows. I have 6 years of experience with MS Office and Adobe Illustrator data conversions so I am confident that I can deliver the solution you are looking for. My top skills include Excel with the advanced formula, Visual Basic, Excel Macros, Excel VBA and statistical data analysis along with correlation and regression analysis. I would be delighted to discuss this project further if given the chance and look forward to hearing from you soon!

£40 GBP w 1 dzień

5,0

(155 opinii)

5,7

@freelancerabdu34

Greetings, I am an Advanced Level Excel VBA & Macros expert and an Accountant. I am very confident to start your project and complete it with all efficiency you are looking for. I understand the requirements and am able to start this project right now. Let’s get started by initiating a chat box to make your project to the next level of automation.

£49 GBP w 2 dni

5,0

(70 opinii)

5,4

@carina0530

Hello, I'm fullstack expert, with over 13 years experience dealing with web, I can help create dashboard and database by excel macro. I've previously worked on the exact similar project for American Rudy employer. When do you need this finished by? I understand how annoying it is, and can finish this project for you quickly! Please send me message, so i can understand details for your project. Waiting for your reply. Best regards. Carina

£110 GBP w 7 dni

5,0

(8 opinii)

5,1

@yesubabu10203

Hello there myself yesu I am a vba developer I can do this you can contact me on this for further discussion thanks

£135 GBP w 4 dni

4,9

(40 opinii)

4,9

@vw1514518vw

Professional Excel VBA developer, Got all the skill set to develop the required functions as you described with guaranteed quality. Check my profile for portfolio of sample works completed and happy clients' reviews.

£100 GBP w 2 dni

5,0

(17 opinii)

4,7

@remisanonymous

Hello, I have a few years of experience in programming VBA Macros and importing, exporting, sorting, calculating, and manipulating data in Excel. I can develop VBA Macro for Automated Calculations. Best regards, Remis

£250 GBP w 14 dni

4,9

(22 opinii)

4,5

@surya2chandra

I have good experience in using VBA, power queries in excel to automate functionalities. I am interested to work on the project. Please let me know the detsils. Thanks.

£60 GBP w 2 dni