Taking information from from a programme and adding to another sheet performing a look up

helenmryan11

New Member
Joined
Feb 23, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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

1614076841602.png


Along the columns i have the dates (These are not formatted as dates as i needed to differentiate between night and day (hence D + N) . 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
1614076894259.png



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:

1614077414509.png


Any help or guidance would be fantastic.

Thanks ever so much

Helen
 

Attachments

  • 1614076955306.png
    1614076955306.png
    33.3 KB · Views: 0

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Forum statistics

Threads
1,148,011
Messages
5,744,334
Members
423,863
Latest member
teehexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top