Insert Blank row for each duplicated DATE an populate value from the other sheet

Hello
I want inserting blank row for each duplicates date in SH sheet and sum for column C,D in TOTAL row after inserting and populate the value in column F in last cell in last row contains duplicate date from MM sheet after matching DATE based on column A . when brings the value from MM should be for the last row contains duplicate date (before TOTAL row) in last cell for last duplicated date for column F from MM sheet to SH sheet in last cell for last duplicated date in column F .

so I put the result how should be in SH sheet . the macro should not insert TOTAL row repeatedly when every time run the macro , every time I will add new data in SH sheet and I will change date in MM sheet then will search the new date in SH enter and do the same thing .

thanks

Maybe you could achieve it with Subtotals and a formula?

Hi
but I wanted to keep the value brought from MM sheet when add new value for new date
example for 15/06/2023 will brings 2000 but if I add 2500 for 17/06/203 then will keep 2000 for 15/06/2023 without delete it .
thanks

Please Login or Register  to view this content.

@kvsrinivasamurthy
thanks , but there are two things :
first , don't insert TOTAL row continuously . just search for duplicates dates don't contain TOTAL row then should insert .
second , what about value? should brings from MM sheet when match duplicates dates with SH sheet in column F , did you see it in EXPECTED sheet?

@jindon
thanks ,but I don't want inserting Total row for duplicates dates have already inserting , I wanted to keep the value brought from MM sheet when add new value for new date
example for 15/06/2023 will brings 2000 but if I add 2500 for 17/06/203 then will keep 2000 for 15/06/2023 without delete it .

Then I don't think I understand what you are asking.

I want inserting blank row for each duplicates date in SH sheet and sum for column C,D in TOTAL row after inserting and populate the value in column F in last cell in last row contains duplicate date from MM sheet after matching DATE based on column A .

ok
but still inserting TOTAL row repeatedly when run the macro every time , also if I change value and change date will clear all of values in column F for SH.
so when add new value and new date then will keep previous value like this (see the MM sheet. EXPECTED sheet)

When you add data in mm sheet, col.F in sh sheet will be automatically updated from the last row of same date in mm sheet.

I meant the previous value brought from MM sheet should keep it without delete previous value has ever added in SH sheet.
this what I try to inform you in post#10 . you can note the 2000 value keep it when change duplicates date and change value . currently the code will delete previous value when change value for new date from column F . every time change date or value in MM sheet should keep the previous value for previous date in SH sheet without delete it as the code does it.

Ref Post#10.
After the first run you have only sh and mm sheets.

I'm not sure what you try to say me!

Code in post #12 has been updated.

awesome!
this is exactly what I wanted ,jindon.
thank you so much .

@kvsrinivasamurthy
second macro doesn't brings the value at all, still inserting TOTAL row repeatedly when run the macro every time based on first macro .
anyway thank you for come back for me.

Hi jindon again
I've found if I change the value for the same duplicates date doesn't change in SH sheet
example :if I added 2000 to date 15/06/2023 in MM sheet then will sow in SH , but if I change value for the same date like this 2200 to date 15/06/2023 then should change the value from 2000 to 2200 .
is there any way to fix it,please?

You need to explain how you are adding new dates in mm sheet.

Are you replacing old data with new data?
If so, what you are asking is IMPOSSIBLE.

Are you replacing old data with new data?

for just the value for the same duplicates DATES
when change to different value in MM sheet for duplicates date has ever added before in SH sheet then just replace with new value for the same duplicate date has ever added before in SH sheet.
still IMPOSSIBLE?

You have run 1st macro only once. once the "TOTAL" rows are inserted don't run that macro.

but I will add new duplicates dates in SH sheet as I said

every time I will add new data in SH sheet

then I need run the macro every time to insert TOTAL row for new duplicate date doesn't contain TOTAL row!

ok jindon see what I try to say you
before file and highlighted red for cell F22 in SH sheet after file

Not really clear though.
1) to a standard code module

Please Login or Register  to view this content.

2) to sh sheet code module

Please Login or Register  to view this content.

yes jindon .
it's great !
thank you so much again.