Hello all,
I'm in the process of developing a spreadsheet that will calculate the number of days between the date a pensioner death was opened and the current date. A major problem I've run into is that the .txt file is generated automatically each day, so, for example, if there is was a pensioner death opened on Monday, Tuesday's .txt file would show it as one day old, but if it isn't closed, Wednesday's .txt file will show it as two days old, leading to multiple entries of the same person in the spreadsheet when I copy and paste the lists.
Is there a function/macro that can search a column for an SSN and remove any previous occurences if found (it would have to remove the entire row, not just the SSN)? Does anyone have any other suggestions? Any input is appreciated. Thanks!
I'm in the process of developing a spreadsheet that will calculate the number of days between the date a pensioner death was opened and the current date. A major problem I've run into is that the .txt file is generated automatically each day, so, for example, if there is was a pensioner death opened on Monday, Tuesday's .txt file would show it as one day old, but if it isn't closed, Wednesday's .txt file will show it as two days old, leading to multiple entries of the same person in the spreadsheet when I copy and paste the lists.
Is there a function/macro that can search a column for an SSN and remove any previous occurences if found (it would have to remove the entire row, not just the SSN)? Does anyone have any other suggestions? Any input is appreciated. Thanks!
