Kapalı

Excel Macro / query

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

Beceriler: PHP, Yazılım Mimarisi

Daha fazlasını görün: macro combine multiple columns single column excel, excel query macro, running excel web query macro, excel vba web query macro, excel website query macro, excel vba paste cells column, excel web query macro, excel sum multiple cell column vba, query macro query excel, vba excel search value row column, web query macro excel, web query macro, excel vba paste last column, query macro excel

İşveren Hakkında:
( 0 değerlendirme ) United Kingdom

Proje NO: #14684742

22 freelancer bu iş için ortalamada 63$ teklif veriyor

A2Design

Hi, this looks like something we could help you with. Our team is Russian-Canadian. We specialise in: PHP & PHP frameworks, WordPress & Woocommerce, Opencart, Magento, API development, HTML5, CSS, JavaScript, Bootstra Daha fazlası

in 3 gün içinde350$ USD
(96 Değerlendirme)
8.4
mak94pk

A proposal has not yet been provided

in 2 gün içinde55$ USD
(35 Değerlendirme)
5.8
Webxpert4u

Hello, I am ready to calculate the total value of all the orders in the excel sheets. Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net for Applications (vba) i Daha fazlası

in 2 gün içinde150$ USD
(17 Değerlendirme)
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 Daha fazlası

in 0 gün içinde34$ USD
(33 Değerlendirme)
5.3
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 experien Daha fazlası

in 0 gün içinde30$ USD
(30 Değerlendirme)
5.3
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 e Daha fazlası

1 gün içinde 50$ USD
(24 Değerlendirme)
5.4
1 gün içinde 55$ USD
(5 Değerlendirme)
4.9
in 3 gün içinde30$ USD
(52 Değerlendirme)
4.2
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 Daha fazlası

1 gün içinde 15$ USD
(12 Değerlendirme)
4.0
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 function Daha fazlası

in 5 gün içinde45$ USD
(7 Değerlendirme)
3.7
1 gün içinde 15$ USD
(18 Değerlendirme)
3.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 :)

in 3 gün içinde30$ USD
(4 Değerlendirme)
3.4
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 Daha fazlası

1 gün içinde 66$ USD
(7 Değerlendirme)
3.0
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 a Daha fazlası

in 2 gün içinde83$ USD
(1 Değerlendirme)
2.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 Experi Daha fazlası

in 3 gün içinde166$ USD
(0 Değerlendirme)
0.0
1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
rahmaddanis

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

1 gün içinde 32$ USD
(0 Değerlendirme)
0.0
apolloinfo

Hi, I am individual developer. I have completed my B.E Computer Science. I have 11 years experience in software development. My skills are Excel VBA, MVC, ASP.NET,VB.NET,C# and MS SQL Server. Relevant Skills and Exper Daha fazlası

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
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

1 gün içinde 15$ USD
(0 Değerlendirme)
0.0