+ Reply to Thread
Results 1 to 1 of 1

Two Excel Programmes Driven by Different Logic

  1. #1
    Registered User
    Join Date
    09-25-2020
    Location
    United Kingdom
    MS-Off Ver
    365
    Posts
    4

    Two Excel Programmes Driven by Different Logic

    Hope you can help, though I am sure you can and apologies if this has been addressed in the past.

    I have two Excel spreadsheets populated with data from Primavera P6, ordinarily the fabricators would apply the same logic throughout so you can track activities by ID however by design or for another reason the progress programmes do not align. Activities have been jumbled, split up and I have no way of cross referencing the activities - bad practice!

    I'm trying to reconcile the planned with the as-built but in order to do so I need to populate the as-built with the planned. I have extracted the Primavera data into two spreadsheets, added a column where I have manually ran through the as-built allocating it to a line reference from the planned programme. I would need to extract the earliest date and the latest date from a range of associated activities.
    Attached Files Attached Files

+ 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. sudden slow start of Excel 2003 VBA macro programmes
    By donwb in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 10-27-2020, 01:37 PM
  2. Dynamic graph driven by input-driven named ranges
    By gwebb in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-24-2015, 09:22 AM
  3. Consolidation of 3 Lists in excel driven by custodian name
    By eeanil in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-29-2012, 06:37 PM
  4. [SOLVED] VBA between programmes
    By PaulW in forum Excel General
    Replies: 2
    Last Post: 05-04-2006, 05:25 AM
  5. [SOLVED] VBA for converting data into various CASES.-write such programmes in VBA
    By Philip in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-16-2005, 04:05 AM
  6. Using VB6.0, check if Excel / Specific Excel Programmes are open
    By Graham Masters in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2005, 11:05 AM
  7. ideas on programmes or software to organise my mobile hairdressin.
    By jupes in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 02-09-2005, 10:06 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