Fertiggestellt

Excel VBA Master

The excel has 31 worksheets with daily report for everyday. I need someone to make a master sheet which gives summation of all 31 sheets in one Master sheet. I need a dropdown for date. After I select date from the dropdown, I should be able to get the sum of all sheets till that date.

Master sheet needs to have following columns:

Column A,B,C,D,E,F - picked up as it is

Column G- Sum

Column H- Count of yes

Column I- Count of Yes

Column J- Sum

Column K,L,M,N,O,P,Q,R,S,T,U- Sum

Column V- Not required

Column W- as on that date which has been selected.

Fähigkeiten: Datenverarbeitung, Excel

Mehr darüber excel modbus master vba, vba excel downsize selection, solidworks vba excel, excel, visual basic, microsoft excel, odbc data vba excel, view directory name files cells vba excel, vba excel delete column, vba excel column label, vba excel action opening workbook, cut paste vba excel

Über den Arbeitgeber:
( 2 Bewertungen ) Chandigarh, India

Projekt-ID: #10677985

Vergeben an:

lxqcad

Excel is my strong point. I've understood your task from the details you mentioned in the description which is quite clear and to the point. A couple of things need to be clarified which can be done through chat. I'll Mehr

₹1700 INR in 3 Tagen
(21 Bewertungen)
4.8

12 Freelancer bieten im Durchschnitt ₹6954 für diesen Job

P0L

₹5000 INR in 3 Tagen
(249 Bewertungen)
7.0
KavTan

Hi, I am an excel spreadsheet expert and I can complete your task effectively and efficiently in timely manner.

₹2500 INR in 3 Tagen
(38 Bewertungen)
5.4
aminbros

A proposal has not yet been provided

₹2700 INR in 3 Tagen
(10 Bewertungen)
5.0
andinasrul

Saya pernah bekerja sebagai Project Cordinator Surveyor/Research dengan Deskripsi Pekerjaan sbb : • Membuat estimasi anggaran biaya kebutuhan equipment kebutuhan project • Membuat timeline agar deadline berjalan Mehr

₹7777 INR in 10 Tagen
(0 Bewertungen)
0.0
taebahmed11

.........................................................................................................

₹12222 INR in 5 Tagen
(0 Bewertungen)
0.0
jigar9099

I have done this kind of things in past and I am really looking forward to work with you so waiting for your reply. you want to merge those all sheets into one so it become convenient for you to work on that. Mehr

₹8000 INR in 3 Tagen
(0 Bewertungen)
0.0
luisaguerra74

Hi, I like your project, We can do it a master sheet working with diferent files If you want we can make business I have worked for diferent companies, with Excel, Macros, VBA I hope your commets best Mehr

₹12444 INR in 10 Tagen
(0 Bewertungen)
0.0
joshuansanders

A proposal has not yet been provided

₹5556 INR in 3 Tagen
(0 Bewertungen)
0.0
₹7777 INR in 3 Tagen
(0 Bewertungen)
0.0
vw7496236vw

A proposal has not yet been provided

₹7777 INR in 3 Tagen
(0 Bewertungen)
0.0
aila6140

I would be able to fix your excel file fast. If you want, I can also throw in macros to allow updating of the excel file easier. I'm starting out here in freelancer and that alone would be motivation enough for me to d Mehr

₹10000 INR in 2 Tagen
(0 Bewertungen)
0.0