hello
i have this code works so well but the problem is when i write in f2 based on d it copy old data repeatedly so what i want when i write in f2 jap it copy only the a new data with ignore old data also when i search another in f2 "thi " it copy data under earlier data in sheet 2 with considering copy updating data
HTML Code:
Are you wanting to overwrite the data all the time...?
Last edited by sintek; 07-23-2020 at 09:16 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
hi, sintek any search in f2 supposes copy from sheet1 to sheet2 and if the data already exist in sheet2 then ignore copy and if in sheet2 has data and i search a new data in f2 in sheet1 then copy data under earlier data in sheet2 don't overwrite already existed data in sheet2 when search a new data
Please Login or Register to view this content.
hi, sintek the code works but it miss some thing when add a new data in sheet1 it doesn't copy to sheet2
Think there is a misunderstanding...Are you wanting to do the following...
If jap exists in sheet2 then overwrite jap in sheets 2 with new jap? same for thi, indo, etc
If so then try this...
Please Login or Register to view this content.
Last edited by sintek; 07-23-2020 at 10:37 AM.
yes, sintek this exactly what i want great codes thanks so much
K cool...tx for rep +
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks