<div>
Thank you for the immediate solution. I will try this and give you a feedback.
</div>


Thank you for the immediate solution. I will try this and give you a feedback.

<div>
Excellent! &nbsp;Glad it was what you were looking for.
</div>


Excellent!  Glad it was what you were looking for.

<div>
<div class="content wysiwyg-content">
I have worksheet exported from SAP BOM. The wrok sheet contains first assembly and followed by childs and again assembly followed by childs and so on.<br />
<br />
Now I have to fill the assembly items on the adjacent cells sothat I get assembly and child on one row.<br />
example<br />
<br />
before update<br />
COL A__COL B<br />
empty___assy1<br />
v1______child11<br />
v2______child12<br />
v3______child13<br />
empty___assy2<br />
v4______child21<br />
empty___assy3<br />
v5______child31<br />
v6______child32<br />
<br />
Now after updation, the result shold be<br />
COL A__COL B<br />
empty___assy1<br />
assy1______child11<br />
assy1______child12<br />
assy3______child13<br />
empty___assy2<br />
assy2______child21<br />
empty___assy3<br />
assy3______child31<br />
assy3______child32<br />
<br />
<br />
I need a macro to fill the assy values against the respective childs<br />
<br />
<br />
<br />
<br />

</div>
</div>


I have worksheet exported from SAP BOM. The wrok sheet contains first assembly and followed by childs and again assembly followed by childs and so on.

Now I have to fill the assembly items on the adjacent cells sothat I get assembly and child on one row.
example

before update
COL A__COL B
empty___assy1
v1______child11
v2______child12
v3______child13
empty___assy2
v4______child21
empty___assy3
v5______child31
v6______child32

Now after updation, the result shold be
COL A__COL B
empty___assy1
assy1______child11
assy1______child12
assy3______child13
empty___assy2
assy2______child21
empty___assy3
assy3______child31
assy3______child32


I need a macro to fill the assy values against the respective childs






excel macro to fill empty adjacent cells (SAP BOM report) with some condition

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.