• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Shift of data based on Month using VBA

A

Amit Punia

Member
Need a VBA which shifts the data based on month. There are two phases in the file i.e. PHASE I & PHASE II. In dates tab, start date for the project is mentioned (For Phase I & Phase II). In dates tab, For Phase II - Construction start date is beginning in "Dec-18" and in the "Cost" tab data is starting from E10 cell.
If we change the month in the "Dates" tab from "Dec-18" to "Feb-19", all the figures for PHASE II should shift accordingly. So the number 330 should start from cell E12 and go on till E15. Similarly, the figures for column G should also shift and start from G16 instead of G14. For column I, the figures should shift and start from I18. All the figures for PHASE II should shift 2 cells down as per the date mentioned in "Date" tab - cell D8.
So whenever anybody changes the date in Cell D8 in Date Tab, all the figures for PHASE II should shift accordingly.

File is attached.

Thanks in advance :)
 

Attachments

  • Model Schedule.xlsx
    80.7 KB · Views: 7
Hi ,

What you want done is not possible in the same sheet.

We can have a separate sheet called say RevisedCost , which will correctly reflect the data on the Cost tab , based on the dates entered in the Dates tab.

Is this acceptable ?

Narayan
 
Hi ,

See if this is OK. Note that the Phase II start date cannot be earlier than December 2018 , since the formula has not been written to take care of this situation.

Narayan
 

Attachments

  • Data.xlsx
    113.5 KB · Views: 5
You must log in or register to reply here.
Back
Top