+ Reply to Thread
Results 1 to 4 of 4

Team and dates updation using VBA .. Urgent help needed

  1. #1
    Registered User
    Join Date
    05-01-2017
    Location
    India
    MS-Off Ver
    2013
    Posts
    2

    Team and dates updation using VBA .. Urgent help needed

    Hi I have multiple app iD's in 1st column, in 2nd column I have Java and Windows applications. In 3rd column I need to update the Java teams as J1 - J8 , and windows team as W1, W2. In 4th column I have number of sprints , where 1 sprint = 2 weeks ( i.e. 10 workdays). In 5th column I have Start date and in 6th column I need to calculate the end dates , where end dates = sprints * Start date . The start date for 1st occurence of the Teams J1 - J8 I know.

    The problem is that if 1st Java application starts on 04/03/2017 , then I need to assign it as J1 through code and also calculate end date and update in the respective colums. Similar for J2- J8. But if J1 completes before start date of J2, suppose it finishes on 04/27/2017, then before J2 starts on 5/1/2017 , we need to assign another app to J1 from 04/28/2017. Similarly it goes for other teams. Everything I need to do through code.
    Please help me as I need to submit it by tomorrow.

    The 1st Start dates are given as follows in mm/dd/yyyy format:-

    Start Date J1 = 4/3/2017
    Start Date J2 = 5/1/2017
    Start Date J3 = 5/1/2017
    Start Date J4 = 6/5/2017
    Start Date J5 = 6/5/2017
    Start Date J6 = 6/5/2017
    Start Date J7 = 9/4/2017
    Start Date J8 = 9/4/2017

    Start Date W1 = 4/3/2017
    Start Date W2 = 5/1/2017
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Team and dates updation using VBA .. Urgent help needed

    It would be nice if you stayed on line when asking for urgent help.

    Your explanation is unclear.

    Good Luck.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Team and dates updation using VBA .. Urgent help needed

    I concur with mehmetcik!
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  4. #4
    Registered User
    Join Date
    05-01-2017
    Location
    India
    MS-Off Ver
    2013
    Posts
    2

    Re: Team and dates updation using VBA .. Urgent help needed

    Thanks

    I have attached the excel sheet, where I need to update teams for Java as J1 to J8, along with their respective start dates and end date calculation. The first time start dates for the teams are given. But once a team completes the task , it needs to be assigned another task, starting from one day after its end date.

+ 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. Pasting data in every other rows
    By sathmaha in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-14-2017, 04:27 PM
  2. [SOLVED] VBA Help needed to create separate sheets for each team by year
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 03-05-2014, 12:42 PM
  3. [SOLVED] Random Team Generator formula needed
    By zboy365 in forum Excel General
    Replies: 6
    Last Post: 08-24-2012, 01:46 PM
  4. Urgent Help needed
    By vibhor_sharma100 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2011, 05:13 PM
  5. Help Needed populating team info
    By m_789 in forum Excel General
    Replies: 0
    Last Post: 01-10-2011, 06:13 AM
  6. Urgent Help Needed!
    By littlejof in forum Excel General
    Replies: 1
    Last Post: 11-23-2008, 06:28 AM
  7. Help Needed Urgent
    By BiggieD in forum Excel General
    Replies: 7
    Last Post: 04-19-2006, 12:04 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