Copying entire row depending on variable value entered

[papasmurfuo9]

Hi

I have two sheets, Sheet1 and Sheet.

In Sheet1 i am using columns A : AZ (A1:AZ1 being headers)
A2:AZ2 being a line of data
lines is entered on a daily basis

in Sheet2 i have a drop down (in C2) that looks at Sheet 1 B2:B65000 which is the reference for the line

Id like when a reference (from dropdown in C2) in sheet2 is selected, it copies the relevant line in sheet1 where that reference is and paste it (transpose) into D3:D54 off sheet2

*i have a filter on sheet1 that could be used in the code if needed

thanks in advance

[TMS]

suggest you upload a sample workbook with some typical data and instructions on how to meet your requirements.

Regards, TMS