ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Check value and add to list (https://www.excelbanter.com/excel-programming/356329-check-value-add-list.html)

[email protected]

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!



All times are GMT +1. The time now is 12:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com