VBA to merge / unmerge identified rows when target is used

[Maatgie]

Hi,

In the attached excel I would want to be able to merge two rows for certain continuous columns / range of columns. Say for Columns A to AF, I need to merge 2 rows of each of the columns.

Can you pls help with the code, where it says,
'VENDOR PART PAYMENT STATUS ACTIONS?

that is the portion of the code for this question.

Regards
Maatangi

 

[Deepak]

Maatgie

We might not able to understand your requirements, Pls explain a bit more!

 

[Marc L]

Hi !

And avoid wild cross-posting : read this ‼

So without any link to others forums where you created same thread
we do not ever take a glance …
​

 

[Maatgie]

Hi Marc, I read through the cross posting info, and now, I can appreciate why it is not very advisable to cross post. I shall keep this in mind for my further posts.

@@Deepak, to explain the question in detail, it is based on the sample file I have attached.
I have several columns in the excel sheet. In one of the columns (Col AG) - Vendor Part Payment - , I am asking for user input as dropdown value "Yes" / "No". If the value is NO, I have a set of actions. However, if the value is "Yes", I need to create a new row with the same data and then merge the new row and the existing row for each of the columns from A to AF together.

Is this possible and if so, how can I achieve this?