this is a intermediate reply
see the attached xlsm(this is excel 2007 macro enable file). I hope you know how to deal with macro enable files (.xlsm)
I kept the original yoyo sheet as "yoyo original" and copied columns A to F to another sheet yoyo.
now see sheet 'yoyo".it is after running the macro "test" below.
for retesting first run the macro "undo" and then run "test"
and see what happens.in column G.
I suppose this is what you want for column G
the logic is
1.first find first trajectory
2.define range from one cell below "trajectory" till the end of that set that is from
B2 to B16 and calculate the formula for each of the Bs in the set and park it in the corresponding cell in column G
3. then find next "trajectory" and do the same thing
4. till you get the last trajectory.
go through the macro you can understand the full logic.
can you write other subs on the same line for other columns on the same basis and collate all the macros together in a finalmacro.
the macros are (which is also in the vb editor of the file)
I shall be busy next week as I am relocating. so if there is any bug or doubt you have to wait for a week. or so. sorry for this.
Bookmarks