how to substract merging cells

Dear Everyone,

I have below general query, i have some merged numerice values in ColumnK & ColumnO and i want to substract columnO - ColumnK = ColumnP merged output should be comes in columnP, kindly suggest me vba code.

Please find attached for better understanding the query.

and thankyou for lookin

and also pls find below link of cross-posting, as my sir is not working with merged cells, hence if anyone working with merged cell pls help me out for finding results.
https://www.mrexcel.com/board/thread...3#post-5608010

Thankyou

Dear AliGW,

i am not merging it. The data which we are receiving on daily basis that data columns comes in merged cells hence we have to making report also based on that merged cells and obvious output also displayed as merged cells. For not doing that daily repetitive activity i am concerning to VBA.

Thanks.

Hi, Aziz
Try this:

Please Login or Register  to view this content.

Here is hint, after substracting first values we are getting "0" until 2nd value in unmerged columnP , if we do remove the duplicates of only "0" then we will get blank cells after every substracted first value then i think we could do merge easily with using "" blank function. it was just suggestion for our last code to making easier.

thankyou pls correct me if i am thinking wrong.

Thankyou but we need one more extra code that output of ColoumnP is not merged we need to set one more code that out put also should comes with along with merge cells. i know that in my sample file i had already merged columnP but that was just for understanding purpose as output result.

Thankyou so much.

here is another hint, if we just make code of formatting column of ColumnO or ColoumK in ColumnP so our columnP will get merged as per the coloumnO or ColumnK if then we would run that above offset substract coding then it would might be work. it was just suggestion,

thankyou and pls correct me if i am wrong.

You need to manually put a number, say 1, in the cell col O, right below the last merge cells area, in this case cell O17, then run this code:

Please Login or Register  to view this content.

I just tried below code first formatted the columnP and then tried your code, that's working fine.

thankyou so much, for everyone.

Please Login or Register  to view this content.

wow you made it very easy thankyou so much...problem solved.

Done, mark as solved. it's feeling like i have achieved or find something real. LOL...

well thanks everyone and so much respects for every developer.

Have a good day !!!

Any way
Since you asked me
This my contribution

Please Login or Register  to view this content.

Might be faster

Thankyou so much mohadin, it helps me to grow and learning fast and also in my working era.

have a good day sir !!!

You are well come
And Thank you