<div>
Hi Tom, before I start on this, did you have a preference for this question I posed in the previous thread?<br />

<blockquote>
<b>Tom: </b>Could I ask you to make one modification -- add cell C1 and H1 &nbsp;to each output row? <br />
<b>Simon: </b>Note the cell C1 value is blank. You may want A1 or a part of its value?
</blockquote>
And...<br />
In the case you mentioned:<br />

<blockquote>
I just noticed the the script skipped the value of 25 in cell BQ10, perhaps because BP10 was empty, or because the top row used merged cells. 
</blockquote>
It was skipped because BP10 was empty. Do you still want a separate line for this in the result sheet (so that you have a matching pair of 'in' and 'out' lines?
</div>


Hi Tom, before I start on this, did you have a preference for this question I posed in the previous thread?


> Tom: Could I ask you to make one modification -- add cell C1 and H1  to each output row?
> Simon: Note the cell C1 value is blank. You may want A1 or a part of its value?

And...
In the case you mentioned:


> I just noticed the the script skipped the value of 25 in cell BQ10, perhaps because BP10 was empty, or because the top row used merged cells.

It was skipped because BP10 was empty. Do you still want a separate line for this in the result sheet (so that you have a matching pair of 'in' and 'out' lines?

<div>
Simon, thanks for doing this so quickly. Worked fine. Cheers!
</div>


Simon, thanks for doing this so quickly. Worked fine. Cheers!

<div>
<div class="content wysiwyg-content">
This is a follow up question to: <br />
<a href="https://www.experts-exchange.com/questions/28606695/Excel-VBA-script-to-populate-a-new-sheet.html" rel="ugc">https://www.experts-exchange.com/questions/28606695/Excel-VBA-script-to-populate-a-new-sheet.html</a><br />
<br />
I'd like to modify the script so that it puts the &quot;in&quot; and &quot;out&quot; into individual rows, rather than treating them as pairs. <br />
<br />
Thanks!
</div>
</div>


This is a follow up question to: 
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28606695.html

I'd like to modify the script so that it puts the "in" and "out" into individual rows, rather than treating them as pairs. 

Thanks!

Follow up question to Q_28606695.html

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

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.