adding rows with new data

wcody
wcody used Ask the Experts™
on
Currently i am going through this sheet and inserting rows for however many years are between the year in Column c and the exit year.  Every row in orange is what I have manually added to this sheet for each ID.  I am hoping there is a script or something that can be written so I don't have to add all these rows and years, you should be able to see what I am trying to accomplish by looking at the orange rows i stopped doing the manual inserts at row 144.
Book11a.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dhiraj MuthaLevel D

Commented:
You just need to pull out the year from column B and put that in Column C, correct me if I am wroing?

In that scenrio you can use this formula:

=YEAR(B6)
Rob HensonFinance Analyst

Commented:
Based on previous question, you did not answer the question posed as to identify the start year for each student.

With the sample data, do we assume for all students the start date was 2006?

If so it is possible to identify how many additional rows are required and populate them accordingly.

Thanks
Rob H
wcodyInformation Systems Specialist

Author

Commented:
Yes assume the start date is 2006 for all students
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

wcodyInformation Systems Specialist

Author

Commented:
I really have no idea how to identify how many additional rows need to be added outside of continuing to plug along inserting them manually
Rob HensonFinance Analyst

Commented:
Finish Year less 2006 (+1) will give number of rows in total required.

EG if finish year is 2009:
  2009 - 2006 + 1 = 4 (2009,08,07,06)

Will also need comparison for subsequent rows where change of program to ensure don't add multiple rows for multiple programs. Likewise check for missing years between programs if that is possible.

I will take another look later.

Thanks
Rob H
Try this sampe (enable macros and press Go button). Filling will take some time
Book11a.xlsm
wcodyInformation Systems Specialist

Author

Commented:
Awesome thanks a bunch!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial