i have 3 xls files to make estimates (3 are almost same)
right now i enter the estimate number manually but i need it now to be generated automatically and saved to same folder with continuous numbers.
field for estimate number is same in all 3 excel files.
second part of the job is on a second xls file which i use for reminder and i want to get email alerts on a date i type in one field
the email has to be sent to a specific email according to the type of client it is (4 types of client total)
for example in field A i put SX it means that email 1 has to be sent to but if i put FC in field A the mail has to be send to email 2
the date of alert will put clearly specified in the file