Need a vBA help on sheet betw copy and paste various col and input values in some col

Hi experts

I have set of data Need vba code to copy data from one sheet to another end with input values in some column

i have 2 sheet one is GMEA (rawdata sheet) and Dragon_Rpt (working sheet)


Copy from Sheet GMEA to Paste into sheet Dragon_Rpt

Column Copy from sheet GMEA A&B To Sheet Dragon_Rpt B&C
Column Copy from sheetsheet GMEA AH To Sheet Dragon_Rpt D
Column Copy from sheetsheet GMEA AG To Sheet Dragon_Rpt J
Column Copy from sheetsheet GMEA W To Sheet Dragon_Rpt O:O
Column Copy from sheetsheet GMEA S&T To Sheet Dragon_Rpt T&U
Column Copy from sheetsheet GMEA AB To Sheet Dragon_Rpt AC

In sheet DragomRpt Make changes in column marked as

Column A:A Concatenate C2&Q2.

Column J:J Convert to text no '3849324838889890000
convert to number as 384932483888989 entire column

Column A:A Fill AA from Y column values Date with formula
=int(y2) entire column format as short date.

AD:AD =GMEA Approved entire column
AE:AE =2 Entire column

find the attachment Dragon_rpt is excepted result.

Are you sure about the column references in your description?

Please Login or Register  to view this content.

Yea brother i uploaded wrong reference sheet to sheet but i got solution from you code Thanks for your time and help. solved!!