sedang Berlangsung

Basic Excel Macro to calculate date diferences

Hi

I have an Excel file attached with 4 sheets (Plan, PlanXSubPlan, Code list and Worksheet).

+ The sheet Plan and PlanXSubPlan will be always feed by me/human!

+ The sheet Code list has 4 columns, 3 of them (Code, Start, end) will always be feed by me/human too. The column PLAN (ID1) must identify which plan each row belongs by using the Start and End as reference, going to the PlanXSubPlan sheet (trough the first"Start" date and the last "End Date" per Plan ID, consequently finding out the Plan Id1. Maybe you need a macro here.

+ The sheet Worksheet has 5 columns, 4 of them (Code, Period, Start, end) will always be feed by me/human too. The column "Total days - days in P" is the main goal (that´s what i really need to have).

+ There you can calculate the "Total days - days in P" = "Start" - "End", but it´s necessary to know, trough the Code, which plan belongs to this code, then go to the PlanXSubPlan and not count the period where Type starts with "P" (P1, P2, P3, P4, P5). Maybe you need a macro here too.

I would like to have basically 2 Excel macros (maybe 1 or many, you decide) according my logic. But you are free to solve it as you wish. I just need the final result ready. Remember the sheet will be constantly updated, so maybe a button would be better to have or you can just make it real time. You decide it!

So, I hope you can help me doing this task.

Thank you and fell free to ask me questions.

Cheers

Keahlian Pemrosesan Data, Excel, Visual Basic

Lihat lebih lanjut: free excel help, ask excel, what is macro in excel, go data feed, Visual Basic Excel, p4, fell free, macros excel basic, excel row column, excel macro row, sheet excel visual basic, 2013 excel visual basic, excel count, excel column row, excel 2013 visual, excel 2013 macro, excel file columns, excel macro reference, excel file type list, column row excel, visual basic 2013, visual basic excel 2013, time sheets excel, type excel sheet, real time count

Tentang Pemberi kerja:
( 14 ulasan ) Copenhagen, Denmark

ID Proyek: #4646949

Diberikan kepada:

Infomedia2000

Please check the PMB.

$144 USD dalam 3 hari
(0 Ulasan)
0.0

16 freelancer menawar pada rata-rata $113 untuk pekerjaan ini

pkcyber

Hi, I will give u a simple application which will take the excel file as input and give u output excel file as you require. It will be fast and accurate way of doing this. If u are willing i can deliver you appli Lagi

$111 USD dalam 1 hari
(22 Ulasan)
5.4
northwolves

Ready to [url removed, login to view] please.

$100 USD dalam 1 hari
(55 Ulasan)
5.1
LIMEXS

Hello Sir, Iet me do this, need your response.

$120 USD dalam 3 hari
(9 Ulasan)
4.0
toxicman

Hello, I can do it. Check p.m.

$100 USD dalam 2 hari
(12 Ulasan)
3.7
vikashgadia

ready to start ur project now

$100 USD dalam 2 hari
(15 Ulasan)
3.6
rbbahia

HI, I can do it,, please check pm message.

$100 USD dalam 0 hari
(7 Ulasan)
3.2
caabdul

Hello sir, I think it can be done without macros, please see PM

$100 USD dalam 1 hari
(4 Ulasan)
3.1
BadihBarakat

+10 years experience in Excel & VBA at your service... You will receive your excel file in one day...

$100 USD dalam 1 hari
(2 Ulasan)
2.6
vinaygarg1

Ready to start. Excel macro expert here. Regards

$100 USD dalam 3 hari
(2 Ulasan)
0.3
tomianabidpk

i can do this.

$100 USD dalam 3 hari
(0 Ulasan)
0.0
Pharoa

Very strong Excel VBA and VB skills. I am available and ready to begin.

$111 USD dalam 3 hari
(1 Ulasan)
3.0
thusharagt

i will do this

$133 USD dalam 3 hari
(0 Ulasan)
0.0
Bagheraa

Hi Gefuso, Bagheraa is ready to help you. Although I'm new, I'm an expert in this field. I can provide an outstanding outcome from this project. If yu choose Bagheraa, you won't be disappointed. Please give me a chanc Lagi

$110 USD dalam 3 hari
(0 Ulasan)
0.0
VUSOLS

Sir, can do this.

$120 USD dalam 3 hari
(0 Ulasan)
0.0
Cygnusinfomedia

Please see the PMB. Many Thanks,

$136 USD dalam 3 hari
(0 Ulasan)
0.0
sabadeeb

Hi... i understand what you want to attempt.. it can be achieved easily, i have done these macros previously so i can efficiently do this for you.

$138 USD dalam 3 hari
(0 Ulasan)
0.0
XWebHunter

I love EXCEL ^^

$100 USD dalam 3 hari
(0 Ulasan)
0.0