i want to automate a time table in excel, time table has many merged fields some, it is difficult to paste every value in database, or excel row by row. I am searcing a last character of value in excel sheet, e.g. (UCA017 P) I am searching a P excel search it , then I want to copy this value, and three values under this value in another sheet in a b c d e column and additonally i want to copy the header and rowid. How to do it by vba or excel please help
Solved by S. F. in 30 mins