Formula

[ekslit]

Hello guys,

I have this case below and my aim is to fill up column H for subtasks. Needed result is that all sub-tasks below story should have the same fix version value than their story.
Can you please share with me the right formula to achieve this?

Thanks in advance.

 

[Fluff]

Do you already have a formula in col H?

 

[ekslit]

Do you already have a formula in col H?

No i dont have any formula. The data in column H right now are coming from an export.

 

[Fluff]

Ok, in that case are you simply trying to copy the release level down into the blank cells below?

 

[ekslit]

Ok, in that case are you simply trying to copy the release level down into the blank cells below?

Yes from parent 'story' to their child 'sub-task' when sub-task release is empty.

 

[Fluff]

Ok, select col H, then press F5, Special, Blanks, With the blank cells still selected type = followed by the up arrow & then Ctrl Enter.

 

[ekslit]

Ok, select col H, then press F5, Special, Blanks, With the blank cells still selected type = followed by the up arrow & then Ctrl Enter.

It's working fine.
Thank you very much
but i m trying to automate this using vba and this is my code for this part. column H become in my code column P.
I tried this formula in the code but its working just for the first subtask below story and not all of them.

 

[Fluff]

If you wanted a VBA solution, why did you title the thread "Formula"?
If the manual process I suggested worked, then you can use

Sub ekslit()
   Range("H:H").SpecialCells(xlBlanks).FormulaR1C1 = "=r[-1]c"
End Sub

 

[ekslit]

If you wanted a VBA solution, why did you title the thread "Formula"?
If the manual process I suggested worked, then you can use

Sub ekslit()
   Range("H:H").SpecialCells(xlBlanks).FormulaR1C1 = "=r[-1]c"
End Sub

Sorry about the thread title. Will be more careful next time.
The formula is working perfectly.
Thank you very much for your help.

 

[Fluff]

You're welcome & thanks for the feedback.