Hello and Happy New Year everybody!
My name is Franco and this is my first thread, i already apologize myself as i am not a technician so my language may not be very specific, but i hope you will help me .
Every day an Excel analysis file run automatically. It reports a certain number of rows. Each rows represent an issue and is characterized by a unique code. Day by day the number of rows increases as new issues are generated. What is missing and i would like to add, is the date when this issue appears, in other words, if a certain code that is unique, was not present in previous days, and today it appears, i would like to have the today date applied to a specific field. Of course this date should not change, it should be kept as the date when that row with the unique code appeared in the file. The file overwrites every single day.
I have no clue how to do that.
Could you help me?
Thanks in advance
Franco
My name is Franco and this is my first thread, i already apologize myself as i am not a technician so my language may not be very specific, but i hope you will help me .
Every day an Excel analysis file run automatically. It reports a certain number of rows. Each rows represent an issue and is characterized by a unique code. Day by day the number of rows increases as new issues are generated. What is missing and i would like to add, is the date when this issue appears, in other words, if a certain code that is unique, was not present in previous days, and today it appears, i would like to have the today date applied to a specific field. Of course this date should not change, it should be kept as the date when that row with the unique code appeared in the file. The file overwrites every single day.
I have no clue how to do that.
Could you help me?
Thanks in advance
Franco