Hello,
Please can anyone help me.
I have a programme tab "programme" which has locations with their corresponding id numbers in the rows A5:A97
Along the columns i have the dates. If the job is happening i would colour the cells like a gant chart. I am trying to assign codes to the colour cell to populate the "Resource request" tab.
So i created various codes
EG
CODE LABOUR PLANT
C1.1 2X FM 2X3.5T
Is there a way i could populate this sheet on a week by week basis automatically. I have tried running pivot tables, but i cannot find a way to get around it. I am a beginner on excel and have watched over a 1000 youtube videos just to get it as it is now.
Example of how i want it to work:
A14 A14 J59Trimley/Kirtn slips rsf
C2508/01 22-Feb-N 23-Feb-D 23-Feb-N 24-Feb-D 24-Feb-N 25-Feb-D 25-Feb-N 26-Feb-D 26-Feb-N
C2 C1 C1 C1 C1
I would like i to populate the sheet as below:
Contract Number Code Start Date End date Vehicles Men
C2508/01 C2 22 Feb N 22 Feb N (lookup code C2 tab"codes" to return men and vehicles)
C2508/01 C1 23-Feb N 23-Feb N (lookup code C2 tab"codes" to return men and vehicles)[table="width: 500"]
[tr]
Bookmarks