$$Excel-Macros$$ SLA format file

2008-12-14 Thread dev t
Hi Friends, I am in process of designing a SLA tracker for my process. I have SLA for each report for e.g. A report should be published on Mon, Wed, Fri every week. B Report should be published daily. C report should be published by 21st of every month and so on. Can anyone forward me a format or

$$Excel-Macros$$ Re: devide column values into two columns

2008-12-14 Thread dev t
Hi, I think you can also use the "Text to column" function by giving the separator as ",". It will split the column into two by useing , as a separator.. Hope this help.. Regards, Dev On Thu, Nov 20, 2008 at 8:44 PM, Tom Jeffries wrote: > The attached Workbook contains a macro(SplitCol) that

$$Excel-Macros$$ Macro to extract data from Access database

2008-09-14 Thread dev t
Hi All, Can any one please help me in below query... Let me tell you what I normally do :- 1. I take out 2 excel files from our online database. 2. I run a macro in MS Access to make 1 combined raw data file.(since these files are huge it can not be done in excel) 3. I extract the out put again