View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dangerd dangerd is offline
external usenet poster
 
Posts: 15
Default Script that automatically writes

Hi there,

I have a very specific requirement but poor vba knowledge.

Basically I am looking for a script that will look a all the strings
contained within a range, compare it with data in another range and,
if there is data missing, append the missing data at the end of the
second range.

So it will go a little like this:

1- XL looks at all the data in colum A
2- Data in column A is then compared to that in column B
3- Is there are any difference, missing data is appended to column B

Has anyone got any ideas?

THx

D