Excel Macro / query

$10-30 USD

Imefungwa

Imechapishwa

almost 7 years ago

$10-30 USD

Kulipwa wakati wa kufikishwa

I have multiple Excel files in a folder. I would like to calculate the total sum of one column in all of the Excel files. More detail: To be precise I have a few hundred files which contain eBay sales and a few hundred files which contain Amazon sales going back two years. Each file has daily sales. Each file has multiple lines. One of the columns in each file contains the total value of each order. I would like to be able to calculate The total value of all the orders in the excel sheets contained in a given folder. Without doing it manually. So I would like the total value of column Z in all the eBay files, and Column x in all the amazon files. It would be nice to have an interface where I could put details of which column I would like to calculate so that I can customise it in the event that the column place changes in the future. Also I would like to have one command or button to calculate Amazon and one to comand calculate eBay

PHP

Software Architecture

Kitambulisho cha mradi: 14684742

Kuhusu mradi

21 mapendekezo

Mradi wa mbali

Inatumika 7 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

21 wafanyakazi huru wana zabuni kwa wastani $65 USD kwa kazi hii

@mak94pk

A proposal has not yet been provided

$55 USD ndani ya siku 2

5.0

(46 hakiki)

6.1

@schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this Task as per your requirement. Relevant Skills and Experience I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project Proposed Milestones $50 USD - payment once project delivered

$50 USD ndani ya siku 1

5.0

(34 hakiki)

5.7

@cgullapalli

Hi, I am good at Excel and vba. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra Relevant Skills and Experience Excel vba Proposed Milestones $34 USD - Milestone Please provide samples of amazon and ebay files

$34 USD ndani ya siku 0

5.0

(48 hakiki)

5.5

@paris2785

I've read your brief and can see that you'd like to have an Excel spreadsheet to calculate the total sum of one column in all of the Excel files within a folder. Relevant Skills and Experience I have 7 years experience in designing and developing Excel spreadsheets filled with formulas and VBA code. Proposed Milestones $30 USD - I would approach your project by creating a draft spreadsheet and send it to you for review. When can we chat or talk? I am online from 8 am to 11 pm (GMT+3).

$30 USD ndani ya siku 0

4.9

(40 hakiki)

5.7

@abedin94

Hi, I'm Sid, a Software Engineer working. I have extensive skills with c++, Php, java, Android and Python of four years. Knock me up if you need it ASAP !!! Relevant Skills and Experience PHP, Software Architecture Proposed Milestones $15 USD - .....................

$15 USD ndani ya siku 1

5.0

(19 hakiki)

5.0

@guptavinayjss08

$55 USD ndani ya siku 1

5.0

(5 hakiki)

4.9

@UEmanuel

Hello, I would suggest a little programm which solves this problem. I would write it in C#. You'll get a user interface with your requirements Relevant Skills and Experience I've already automised some Excel functions. One was a whole technical Datasheet with formatting and data input. I would write this little programm in C#-net Proposed Milestones $45 USD - Write the software with the given requirements If I get the project I need a testfile and criterion how to differ between ebay and amazon files.

$45 USD ndani ya siku 5

5.0

(10 hakiki)

4.5

@tech1967

Hello,, I am an expert in AutoIT language, I can write a little script with a nice GUI to calculate the sum of the given columns. Please check my profile for my past work, thank you :)

$30 USD ndani ya siku 3

5.0

(6 hakiki)

3.9

@sorinacho88

Hello, I can create a macro that will pick up the values from all the files in the folder. You will choose the column and press the button. If you are interested please open a chat with me. Thank you Relevant Skills and Experience VBA / Excel Attention to details Quality oriented After sale free support Proposed Milestones $66 USD - Full payment after you are happy with the result. Nothing upfront

$66 USD ndani ya siku 1

5.0

(11 hakiki)

3.4

@narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 7 years of IT experience. I have successfully completed few projects for US clients Relevant Skills and Experience Ms-Excel(Advanced) Macros Proposed Milestones $83 USD - This task will be completed within schedule

$83 USD ndani ya siku 2

5.0

(1 hakiki)

2.0

@rlopezing

Hello, nice to greet ?, To achieve this you have to standardize the books, let's talk a little more about the project. Relevant Skills and Experience Macros Excel, Visual Basic 6. Proposed Milestones $60 USD - Macros Excel, Visual Basic 6.

$60 USD ndani ya siku 5

4.0

(1 hakiki)

1.2

@davidsalah

hello i have experiences of excel i can do all of formula you need with best skills and i do at time as total and if you want to do all of better for you low prize few time regad salah

$15 USD ndani ya siku 1

0.0

(0 hakiki)

0.0

@rahmaddanis

I can utilize Excel VBA to achieve this. Relevant Skills and Experience Excel VBA Proposed Milestones $32 USD - Completed App

$32 USD ndani ya siku 1

0.0

(0 hakiki)

0.0

@ArnoHanekom1

Create an app to calculate the total of a specific column for multiple files in a specific location. Create a location setup, add app, column setup, calculate section to allow flexibility. Relevant Skills and Experience I have more than 10 years software development experience and over 4 years Database Architect and Engineering experience. I bring the best to the table. Proposed Milestones $25 USD - Initial Development Commitment Deposit $30 USD - Project Delivery How would you like to save/display the output of the calculated value?

$166 USD ndani ya siku 3