View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] awilhite@cableone.net is offline
external usenet poster
 
Posts: 3
Default Check value and add to list

Hello,

I am having problems figuring out how to take two text lists, compare
the new list to the master, and update the master if it is missing and
time stamp it in a sub routine.

Code Snippets
This is a cell value that i assinged where I check the new list against
the master.
=IF(ISERROR(MATCH(F6,Data!A:A,0)),"New","Old")

Anyone have any suggestions to building this out into a subroutine that
updates the master list as well define whether it is a new data point?




Thanks in Advance!