Search by date and paste to a second sheet.

[Trueblue862]

Hi, I'm trying to figure out how to do this. I need a macro to search column A of sheet1 for a date which the user will enter into textboxA. When it finds the date in column A I then need it to transfer the values across that row to Sheet2, after row 2 (two row header). The what I'm really struggling with is on sheet2 the data needs to be in a different order and not all of it is used. The columns are as follows. Sheet 1 column B needs to go to sheet 2 column A, Sheet 1 column c needs to go to sheet 2 column b, Sheet 1 column c needs to go to sheet 2 column g. If anyone can help with this it would be fantastic.

 

[WarPigl3t]

SOLVED

 

[Trueblue862]

Yep, it was a typical pebkac error.