VBA help for in my project after copy data formating

Hello
We are working to create a solution for my problem with help of VBA code almost we success with help of with this forum help
we enclosed my file with attachment
in This file we have 4 sheet
1 Bulkentry
2 Joint
3 reocrd
4 B_dta

in this Bulkentry sheet after entry my data when we press Y to Column V27 then transfer data as per my need (which one Copy from B_dta) to Joint and Record Sheet..

Currentry when we press first time Y in Column V27 then data copy as per my need in both sheet (i.e record and Joint) but after 1 time when we press to submit data again from Bulkentry column V27 then in Joint Sheet formating not copy as per my desired format..
Pls help me to solve this problem..

Thanks in Advance
Santosh

PS:- I m from India and My Data is Hindi font so i want to attach hindi font krutidev 010 but its not possbile bcoz ttf format show invalid files)

        Sheets("Joint").Range("R" & CStr(Application.Rows.Count)).End(xlUp).Offset(1, -17).PasteSpecial Paste:=xlPasteFormats, Transpose:=False

You have nothing in Column "R", so it goes all the way back to the first row, and pastes the formats in A1:Q201



You only need to copy the range once, then Paste the values and then the formats.

        Sheets("B_DTA").Range("A1:Q201").Copy    '*************COPY DATA TO JOINT SHEET
        '*********COPY VALUE IN JOINT SHEET*******
        With Sheets("Joint").Range("A" & CStr(Application.Rows.Count)).End(xlUp).Offset(1, 0)
            .PasteSpecial Paste:=xlPasteValues, Transpose:=False
            .PasteSpecial Paste:=xlPasteFormats, Transpose:=False
            Application.CutCopyMode = False
        End With

get rid of all your merged cells.