"GANT CHART" WITH EXCEL (not graph)

Hello !!!
I have a problem withh excel,but i can't solve it alone.
I would really appreciate any help:) .
I have searched on the internet but I couldn't find a solution.

I have an excel file (you will find attached a small example(jpg as i was unable to upload the xls file) of what it looks like (in a simplified version)).

According to the start date that I have in cells B12-B17 i want excel to find (in table 1) and copy (to table 3) the standard duration of each task in table 3 at the correct collumn that corresponds to the week of the begining of the task(we consider that the maximum duration is 4 weeks and the workload is given in cells B4-E7.
What I need looks a lot like a Gantt diagram, but i need into the appropriate cells the values that correspond to each week's workload.

I don't know if something like that can be solved using formulas or visual basic (i think VB is more secure, as formulas can be erased by users,and the protection causes problems on filtering etc).

Thank you in advance for your help

Hi PARIEL and welcome to XVBT! :)

Please be sure to read the posting guidelines (http://www.xtremevbtalk.com/faq.php?faq=evbf_faq#faq_evbf_rules).

I've had a look at the diagram you attached.
You can easily achieve the layout in table 3 by using formulas: in this situation I recommend using formulas instead of VBA.

The main two worksheet functions you will have to familiarise yourself with are INDEX and MATCH. Check them out in the helpfile and have a go.

If you get stuck then post back with what you've tried and we'll give you further assistance.

Good luck.
Colin