copy not existing cells from one sheet to another

**rana_shaker** · 12-14-2012, 11:57 AM

hi ..
I have "stoke" sheet with a code names in column B ..

and I have another sheet "sat" .. whith code names in column B starting from B2

I want a code to check if all codes in "sat" sheet exists in "stoke" sheet and if that code not exists I want to add it to the bottom of "stoke" sheet

I found this code in the forum from AB33 .. but when I tried it and checked the result ,, I found that some codes not copied ..
I don't know why ??

Please Login or Register  to view this content.

hope that I can find the answer

**AB33** · 12-14-2012, 12:05 PM

Rana,
No, you have found the code, but I wrote it for you when you had requested for it. It was then worked.

**rana_shaker** · 12-14-2012, 12:08 PM

yes ... thanks to you really ..
it is working ,,, but when I check it manually I fount that it did not take all the not existing cells .. thats it
can you please help me ??

**rana_shaker** · 12-14-2012, 12:11 PM

I asked u for the code using Al sheet but I changed the sheet only .. instead of Al I used sat ...
it is working well with Al sheet but with sat some of not existing cells not copied to stoke sheet

**AB33** · 12-14-2012, 12:17 PM

Please attach your workbook

**rana_shaker** · 12-14-2012, 01:07 PM

the file is 2 MB .. larg

**rana_shaker** · 12-14-2012, 04:25 PM

here is a sample file ..
test2.zip

copy not existing cells from one sheet to another

LinkBack

Thread Tools

Rate This Thread

Display

copy not existing cells from one sheet to another

Re: copy not existing cells from one sheet to another

Re: copy not existing cells from one sheet to another

Re: copy not existing cells from one sheet to another

Re: copy not existing cells from one sheet to another

Re: copy not existing cells from one sheet to another

Re: copy not existing cells from one sheet to another

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions