Copying formats from sheets workings (template) to consolidation data sheet in same range as per code is ok.as below

However how to paste specials format only from RANGE (h2:v2) to last data row in sheet consolidation data

there is data from g1 still to last data row 





Sub format_inte_pastespecialformat()



'Sheets("WORKINGS").Range("H2:V2").copy

'Sheets("consolidation DATA").Range("H2:V2").PasteSpecial Paste:=xlPasteFormats

End Sub