$$Excel-Macros$$ Macro to send email automatically.

2011-05-06 Thread Jitheesh Vazhapully
Hello Experts, I'm looking for an macro to send an email on a specific date, We can run the macro daily and I want it to compare todays date with the deadline and in case it matches, the excel should shoot an email. I have mentioned the details in the excel sheet. Please advice if this is

$$Excel-Macros$$ Date format problem

2009-11-27 Thread Jitheesh Vazhapully
Good Evening Excel Gurus, I have a data in this format 01-01-01, however as soon as I enter them in the excel sheet,excel picks it up as date and stores it in date format, Is there any way I can prevent this from happening. Also how to convert this data back from date format 01/01/2001 to

$$Excel-Macros$$ Vlookup and If formula

2009-09-15 Thread Jitheesh Vazhapully
Hello Excel guru's, I want data in the main sheet into the format provided in sheets 510,511 and 512 besides the main sheet,I have been using autofilter option,by filtering period column and wages column and creating new sheets, then using vlookup formula to pull the data into my reports

$$Excel-Macros$$ Nested Formula

2009-09-13 Thread Jitheesh Vazhapully
I want these data in the format provided in sheets 510,511 and 512 and in the given format. I have been using autofilter option,by filtering period column and wages column and creating new sheets, then using vlookup formula to pull the data into my reports there any formula wherein I can pull the