VBA help for in my project after copy data formating

[santosh226001]

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)

[davesexcel]

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

[torachan]

get rid of all your merged cells.

[santosh226001]

davesexce sir its work thanks a lot for valuable help