Excel - combine rows with previous rows - conditionally

Hi,

I have attached a workbook stating my requirement with expected result.
Any help is greatly appreciated.

Thanks.
SB.

Try the below code

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

Please Login or Register  to view this content.

Hi, :) Sixthsense :)

me again - not your day of coding to my opninion.

You define r but use i. What will happen if User Cancels the question about any of the ranges? Leave the user with a run time error and inside the VBE?

Ciao,
Holger

@ Holger,

Yes you are right and lol

First I thought to go for For Each approach and after that I thought to go for cell count approach but again forgot to change the r to i and the type of variable

Then regarding your Input range Cancel question I always won't put much more effort while writing the code to cover A-Z because I wait for the OP to turnon on the suggested code and do the further developments based on the OP's reply.

Yes seems to be not my day in coding the reason is I have more works and doing it by side by side and answering here too which may be the root cause for this distraction

Thanks Sixthsense,

As per the code, user has to select the rows (child + parent) to combine them to one. i have n number of line items to combine, so is there a way that excel identifies the range of data (upto last updated row) and search row by row to combine child rows with parent rows leaving rows as it is which doesnt have child ?

Additional info: parent row always begins with the numeric.

Thanks
SB.

That is how the suggested code was written

thanks a lot, it works.

Thanks
SB.

Glad it helps you and thanks for the feedback and rep