Trueblue862
Board Regular
- Joined
- May 24, 2020
- Messages
- 160
- Office Version
- 365
- Platform
- Windows
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.