I have data in sheet1 range (A2:BM65),
Search criteria in sheet1 A column. Basis search criteria, if found. Need to copy corresponding values in the row of matched criteria from sheet1 range (Column E&matched row to column BM&matched row)
Paste in sheet2 B2 spliting the copied data in 5 columns&12 rows.
Require in VBA
Search criteria in sheet1 A column. Basis search criteria, if found. Need to copy corresponding values in the row of matched criteria from sheet1 range (Column E&matched row to column BM&matched row)
Paste in sheet2 B2 spliting the copied data in 5 columns&12 rows.
Require in VBA