Macro to copy data from Col B to Col A based on certain criiteria

[Howardc1001]

I would like a macro to copy dat from Col B to Col A from row 2 onwards based on the following criteria

1) Where the number in Col B does not match the number in Col A, then copy this number using paste value special
2) Where #N/A appears or Item on promotion in Col A then ignore i.e. do not copy to Col B


I have attached sample data


Your assistance is most appreciated

[vba_php]

welcome back Howard. this is pretty simple. have you given it a try yet?

[Howardc1001]

Thanks for the reply. It may be simple for you, but don't know how to tackle this one

It would be appreciated if you could kindly assist me

[vba_php]

for some reason i am getting a popup today telling me that files I download (only some) are corrupted or that there is some content in them that is bad. not sure what that is. can't read your file howard.

[Howardc1001]

I have attached another workbook

Hopefully this one is fine. It opens fine on my side, without any errors

[Marc L]

Hi,

same issue on my side since yesterday from several threads …

[Marc L]

Same issue again with post #5 attachment, that's weird …

[AliGW]

It’s a known issue - sorry. The tech team is aware, but so far no fix. There have been several threads about it.

[vba_php]

thanks Ali.

[Howardc1001]

Thanks for letting us know

Does the forum rules allow one to use Dropbox ? I could not find anything, but want to make certain

[vba_php]

you can include any links you want, I believe. however, their malicious code detector blocks actual HTML code. if it is written properly, that is.

[Howardc1001]

I have copy the file on to dropbox-see link below


https://www.dropbox.com/s/9mjp91yuvz...tion.xlsx?dl=0