+ Reply to Thread
Results 1 to 1 of 1

Help with taking information from a programme into a a table with a lookup

  1. #1
    Registered User
    Join Date
    02-21-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    2

    Help with taking information from a programme into a a table with a lookup

    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]
    Attached Files Attached Files
    Last edited by helen120; 02-23-2021 at 06:31 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 05-16-2019, 09:09 AM
  2. taking every value for lookup value from a table
    By Nidocaldo1984 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2019, 01:51 AM
  3. Lookup a table of information not just one cell.
    By Maxxem in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-07-2016, 01:31 PM
  4. Lookup Date in Table & Display Cell Information
    By jayjacko in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-02-2013, 04:54 PM
  5. lookup/process information from table
    By Ganelon in forum Excel General
    Replies: 2
    Last Post: 06-14-2010, 02:13 AM
  6. Taking information from a Database...
    By Sevendust24 in forum Excel General
    Replies: 2
    Last Post: 03-17-2009, 10:20 AM
  7. Taking information out of excel and making a table of responses in
    By stanger help in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-20-2005, 10:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1