copy data from sheet to another based on name by inputbox

[ABDELFATTA]

hell
i have this code and i try updating data to sheet2 from sheet1 by choose the name if the data of name is already existed should update in sheet2 if not then copy a new data to bottom

[nankw83]

Hi ABDELFATTA,

I am confused about what you're trying to do. What should be entered in the Inputbox ? A name or year ? If found in Sheet2, it should update all cells of the same row & if not found add a new record at the bottom ?

[ABDELFATTA]

hi nankw83 it should enter the name into inputbox as for this

Hi ABDELFATTA,

If found in Sheet2, it should update all cells of the same row ?

yes i would this but forget copy to the bottom if name is not existed should show message not data found

[nankw83]

Try below code ...

Please Login or Register  to view this content.

[ABDELFATTA]

thanks nank the code works as what i want but if is possible i would to be letters of name are sensitive so , how i can use function lcase and ucase?

[nankw83]

In order for the search to be case sensitive, add the below to the above code red syntax

Please Login or Register  to view this content.

[ABDELFATTA]

brilliant ! i would sorry about not add reputation for you indeed you've solved many thread honestly, i thought in earlier time i have ever added to you sorry about it
many thanks buddy

[nankw83]

Glad to help & thanks for the added Rep