$$Excel-Macros$$ Transpose Horizontal Table and get the Pivot Table

2016-07-14 Thread Edo Hanggoro
Dear All, I got the VBA script for transpose the horizontal excel table (Sheet "Data") into table in sheet "Table & PT". That is awesome VBA script to convert from the "horizontal" data table into the "vertical" data table also the pivot table is nice. I try to do with the same way to convert

$$Excel-Macros$$ Re: Introduce Yourself !!

2016-07-14 Thread Edo Hanggoro
Hi. I'm Edo, working in fields of data and accountant for consumer goods product. Looking forward to interact with everyone here. Regards Edo On Saturday, June 9, 2012 at 2:21:59 AM UTC+7, Ayush Jain wrote: > > Hey all new and current posters, > > Welcome to excel group,one of the largest

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2016-07-14 Thread Naveen Kumar M N
Dear All, I am Naveenkumar from Bangalore, currently I am working as MIS executive in IT company. Keen to learn more about Excel macros and vb code. Thanks Naveenkumar On Jul 13, 2016 9:10 PM, "DINESH SHETTY" wrote: Hi, I'm Dinesh Shetty, working on Data analysis and

Re: $$Excel-Macros$$ How do I arrange formula in Microsoft Excel

2016-07-14 Thread Paul Schreiner
In this case, in cell C5 you could use a calculation like:=(Q35 -1) * 10  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you

$$Excel-Macros$$ Looking for MS SQL Resources - Bangalore Location

2016-07-14 Thread yogananda muthaiah
Hi All, Kindly send your resume to below given id : ananda...@exidelife.in for MS SQL opening and having more than 1year experience -- Regards Yogananda Muthaiah Ph : 9343 666 888 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join

$$Excel-Macros$$ VBA code to send multiple PDF to multiple e mail receipients from outlook

2016-07-14 Thread Rajarajan Venkatachalam
Dear Friends, I have some 150 pdf (payslips) which has to be sent to employees respective mail id.as attachments. Presently I use mail merge to send the payslip html format. Can anyone assist me with VBA code. Rajarajan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

$$Excel-Macros$$ How do I arrange formula in Microsoft Excel

2016-07-14 Thread David Jones
Hi, Can any one please help me to arrange a formula, so that if the number in a selected cell increases, the corresponding answer in another cell will increase accordingly. How do i arrange the formula in Excel, so that if Q35(cell number)=1, the answer (in cell C5) is 0;