Vba or formula please

[srizki]

I have rows headings in column A, like Batch#, AFE#, Business Unit etc.</SPAN> one of the question is Child? In cell A7, If user types YES in B7, then the Next cell A8 has "parent#". Then user has to type Parent # in cell B8</SPAN> From A8, I used formual, If B7 has Yes than Parent # otherwise Item number,</SPAN> in A9 I wrote another formaula if A9 is Item number then Serial # otherwise Asset #</SPAN> and so on. </SPAN> I am sure there must be a better way, like, if the answer in B7 is Yes then A8 will be Parent # and the rest will move down by one cell, instead of using so many formulas.</SPAN> I know it could be done by VBA. But I do not know VBA.</SPAN> Thanks</SPAN> <TBODY> </TBODY> I have rows headings in column A, like Batch#, AFE#, Business Unit etc.</SPAN>

one of the question is Child? In cell A7, If user types YES in B7, then the Next cell A8 has Parent #. </SPAN>

Then user has to type Parent # in cell B8</SPAN>

From A8, I used formual, If B7 has Yes than Parent # otherwise Item number,</SPAN>

in A9 I wrote another formaula if A9 is Item number then Serial # otherwise Asset #</SPAN>

and so on. </SPAN>

I am sure there must be a better way, like, if the answer in B7 is Yes then A8 will be Parent # and the rest will move down by one cell, instead of using so many formulas.</SPAN>

I know it could be done by VBA. But I do not know VBA.</SPAN>

Thanks</SPAN>

<TBODY>
</TBODY>

BATCH #</SPAN>
AFE #</SPAN>
Business Unit</SPAN>
Branch Plant</SPAN>
Dr Obj Acct</SPAN>
Cr Obj Acct</SPAN>
Child?</SPAN>	YES</SPAN>
Parent #</SPAN>
Item Number</SPAN>
Serial Number</SPAN>
Asset Number</SPAN>
DPIS (Date Placed In Service)</SPAN>
Lease Expiry Date</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL></COLGROUP>