split data based on month and move the final balance from month to another

[Ali-M]

Hi experts
I have many data for customer . each the customer contain data from JAN to DEC so what I want split data into multiple sheets which contain data for 12 month individually as in sheet JAN, FEB should split based on column A is month when move to the next month as in sheet FEB . it should copy the last value in lastrow in column G as highlighted from month JAN into month FEB in first row and add the date and client and word " opening" as is added in first row in month FEB so when finish the month and move the next should add the last balance from precede month to next month into first row . and every time change the data in sheet MAIN then should update in others sheets(JAN,FEB,......) with dosen't show the formula when split .
thanks

[DJunqueira]

I surprised no body did it before me...

Please Login or Register  to view this content.

[Ali-M]

did you see what I want?
absolutely this is not what I want

[jindon]

did you see what I want?

That's why I didn't want to post here.
Look at the opening balance in JAN.
You need to explain why it is 12,000.00.

[Ali-M]

jindon sorry about this . this doesn't happen deliberately . thanks for inform me about this . there is value 500 in column credit in sheet main . it should not be existed .
I edited my file .

[jindon]

For the workbook uploaded.

Please Login or Register  to view this content.

[Ali-M]

jindon thanks for your code , but just I have last thing and I'm sorry I don't mentioned . this case is rare . somtimes the last balance in specific month it can be by minus value then when move to next month in the opening it should be in credit column .it should not be in debit column becuase the value is minus
thanks for your assistance again

[jindon]

change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Ali-M]

perfect ! I appreciate for your time & assistance .
many thanks for your help

[DJunqueira]

did you see what I want?
absolutely this is not what I want

I repeated exactly what you posted in your exemple sheet.