Re: $$Excel-Macros$$ Horizontal to Vertical in One colume

2013-06-21 Thread priti verma
Yes you can do it with macro, See pfa On Fri, Jun 21, 2013 at 11:29 AM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear Madam, Thanks a lot ... Can we make it from macro ... Regards, Prafull Jadhav. On Fri, Jun 21, 2013 at 11:24 AM, priti verma pritiverma1...@gmail.comwrote: Hi

Re: $$Excel-Macros$$ Horizontal to Vertical in One colume

2013-06-21 Thread Prafull Jadhav
Thanks once again.Madam On Fri, Jun 21, 2013 at 11:48 AM, priti verma pritiverma1...@gmail.comwrote: Yes you can do it with macro, See pfa On Fri, Jun 21, 2013 at 11:29 AM, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear Madam, Thanks a lot ... Can we make it from macro ...

Re: $$Excel-Macros$$ Horizontal to Vertical in One colume

2013-06-21 Thread Prabhu Pinky
hi priti..this is really nice work...if you dont mind..can you gimme training in macro..pls..i can follow your classes as you teach me... On Jun 21, 2013 11:48 AM, priti verma pritiverma1...@gmail.com wrote: Yes you can do it with macro, See pfa On Fri, Jun 21, 2013 at 11:29 AM, Prafull

$$Excel-Macros$$ Need code for extracting report from CMS Avaya

2013-06-21 Thread Arundatti M
Hi Team, I need help in extracting report from CMS Avaya CRM application to excel. If there is any scripts, please help experts. Any script which links cms historical reports to excel? Regards, Arundatti -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ macro for parsing a column by 5 rows

2013-06-21 Thread Seba
Hi, thank you for your help. This is the final version of my code: Sub copy_transpose_chunks() Dim count, target, coordS, coordF As Integer coordS = 1 coordF = 5 target = 1 For count = 1 To 15 Range(A coordS, A coordF).Select Selection.Copy Range(C

Re: $$Excel-Macros$$ Need code for extracting report from CMS Avaya

2013-06-21 Thread VBA VABZ
hey FYI http://fracta.net/fracta/index.php/forum/2-excel-vba-forum/15-excel-vba-macro-to-automate-avaya-cms-supervisor-reports Thanks On Fri, Jun 21, 2013 at 4:13 PM, Arundatti M arundatt...@gmail.com wrote: Hi Team, I need help in extracting report from CMS Avaya CRM application to

Re: $$Excel-Macros$$ macro for parsing a column by 5 rows

2013-06-21 Thread VBA VABZ
Superb!! I assume you need to increment target by 5 too, coz u r copying 5 rows. Thanks On Fri, Jun 21, 2013 at 4:38 PM, Seba sebastjan.hri...@gmail.com wrote: Hi, thank you for your help. This is the final version of my code: Sub copy_transpose_chunks() Dim count, target, coordS,

Re: $$Excel-Macros$$ macro for parsing a column by 5 rows

2013-06-21 Thread Seba
Actually no, because I want the copied values in a list w/o blanks. regards seba Dne petek, 21. junij 2013 13:15:16 UTC+2 je oseba Vabz napisala: Superb!! I assume you need to increment target by 5 too, coz u r copying 5 rows. Thanks On Fri, Jun 21, 2013 at 4:38 PM, Seba

$$Excel-Macros$$ Start and Stop Time - Macro

2013-06-21 Thread Bill Q
I have various macros that perform different tasks daily. All of these have to be manually started and stopped at a certain time. That time is never the same as it has to be obviously initiated manually. I have read various examples on the web (for starting only), but have had no success so

Re: $$Excel-Macros$$ Start and Stop Time - Macro

2013-06-21 Thread VBA VABZ
Hi To run this macro, just make sure that you replace *Name_of_Macro* with the name of the macro inside of your Excel workbook that you want to run. Also, replace *09:30:00* with the time that you want your macro to run. Private Sub Workbook_Open() 'Runs a macro at 9:30 AM Application.OnTime

$$Excel-Macros$$ Urgent Requirement

2013-06-21 Thread Gagan
Please respond to *ga...@hmgamerica.com* *Position: VMWare Admin* *​Location: ​* *Burbank, CA* *​ Duration: ​* *6+ month s​ * *​Description: ​* * * A highly motivated System Administrator with *8+ years of experience*should have the following skills:  Expert applied knowledge of Intel

Re: $$Excel-Macros$$ How to get the Month end date from a list of dates

2013-06-21 Thread VBA VABZ
try edate formula.. Thanks On Sat, Jun 22, 2013 at 1:13 AM, Hilary Lomotey resp...@gmail.com wrote: Hello Experts, In the attached sheet, i have a list of dates in col A and index number in Col B. What i am trying to achieve is that in Sheet two, i have written a formula to give me index

Re: $$Excel-Macros$$ Start and Stop Time - Macro

2013-06-21 Thread Bill Q
Sounds good Vabz Half way there. What about the end time ? Where would that go ? On Friday, June 21, 2013 9:03:26 AM UTC-4, Vabz wrote: Hi To run this macro, just make sure that you replace *Name_of_Macro* with the name of the macro inside of your Excel workbook that you want to run.