Excel_Macro
Hello,
Need your help regarding excel formula. I have one excel data. In Column "D" I have dates. I want to write a macro which can put some kind of word say as "Yes" in Column "E" if below criteria fulfils. 1. Say if I am pulling report on 08/06/2009 & day of this date is Monday so I want data for 04/06/2009 (Thursday) & 05/06/2009 (Friday). 2. Say if I am pulling report in 09/06/2009 & day of this date is Tuesday so I will require data only for 08/06/2009..this should continue until Friday... Please let me know if you want a Demo file so I can arrange the same. Kam. |
All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com