Read this : Taking information from a programme and analysing the data to return values based on a lookup

By | February 23, 2021
Share this

Hi, Please can anyone help me. I have a program tab “programme” which has locations using their corresponding id numbers in the series A5: A97 ​ ​ ​ Along the columns i have the particular dates (These are not formatted because dates as i needed to differentiate among night and day (hence D + N). If the job is happening i would color the cells like a gant chart. We are trying to assign codes to the color cell to populate the “Resource request” tab. So i created different codes EG CODE LABOUR GROW C1 – 1x crew 1x IPV + 1×3. 5t ​ Is there a way i could fill this sheet on a week simply by week basis automatically. I have attempted running pivot tables, but i am unable to find a way to get around it. We are a beginner on excel and also have watched over a 1000 youtube video clips just to get it as it is now. Sort of how i want it to work: ​ Any help or guidance will be fantastic. Thanks ever so much
posted by /u/hmr120
[link] [comments]Read More
The post you just read was originally posted on social media, you can click on the above “Read More” button to see the original post .

Thanks for visiting, you can leave a reply or comments below at the comment box.