asked on

adding rows with new data

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

Dhiraj Mutha

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 Henson

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

wcody

ASKER

Yes assume the start date is 2006 for all students

wcody

ASKER

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 Henson

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

ASKER CERTIFIED SOLUTION

als315

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

wcody

ASKER

Awesome thanks a bunch!