Hello.
I really need your help in somthing, I will try to explain myself as good as I can.
I have a table, that I fill out every day. the table is to keep data about my jobs (date, how meny houres, salary per hour, extra hours and the sum of the money I earned that day).
so far so good.
My problem with this table is that it is too big. A year of data is not comfortable to work with. so I wrote a code so every first of the month, all the prev data will be stored in an array that will be orgenized by date and a number between 1 to 4 to repersent the type of data that is stored (1 = hours, 2=salary, 3=extra hours...). that way I can exccess the data easly. if I want to know how meny hours I worked on the 1st of may 13 I will check for array(5,1,13,1), if I want to know if I worked extra hours that day I will check array(5,1,13,3).

my problem is that the data entered to the array is deleted when exiting excel.

is there a way to keep that data? can I use the data that I entered the array last time I used the program?

thanks!