Re: $$Excel-Macros$$ Need a help in Pivot

2014-06-28 Thread Ganesh N
Hi, Thank. But there is any way to get the details without changing the structural ? Because the initial one is the format which use to have. Thanks Ganesh N On Sat, Jun 28, 2014 at 6:17 PM, Bé Trần Văn wrote: > Structural change, then use the AutoFilter to select PivotTable OFF. > > 2014-0

$$Excel-Macros$$ html to excel sheet

2014-06-28 Thread Shankar Bheema
I am attaching the html page and excel workbook. I need help from the members that the data entered into the html page shall be generated the excel sheet after pressing the button on webpage. Kindly guide me in this regard. regards shankar sb -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ Re: fill in the missing data for highlighted rows - macro request

2014-06-28 Thread Vaibhav Joshi
Ok. I got that.. will try tomo morning India Time. Cheers & Good Night. On Sat, Jun 28, 2014 at 11:49 PM, jun a wrote: > Hi, > > Thank you for your reply. Apology for not making my statement clear > enough. > > I have attached a example below, for further reference to this issue. > When I r

Re: $$Excel-Macros$$ Re: fill in the missing data for highlighted rows - macro request

2014-06-28 Thread Vaibhav Joshi
file which you sent doesnt have duplicated value for *lbmt 2007-c3 ajfl* On Sat, Jun 28, 2014 at 9:46 PM, jun a wrote: > Hi, > > Thanks a lot for your help and your time into this solution, i am sorry to > inform, as the logic is slightly incorrect. if i run the id2 macro, it > fills row 21 (p

Re: $$Excel-Macros$$ How to remove vb code after you make a copy

2014-06-28 Thread ashish koul
try this link http://www.ozgrid.com/VBA/delete-sheet-code.htm On Fri, Jun 27, 2014 at 3:03 AM, Rob Flott wrote: > My application allows the user to make a copy of a worksheet so it can be > viewed outside of the application. The problem I have with this is the > code written to that specific

Re: $$Excel-Macros$$ Excel table view to xml format

2014-06-28 Thread yogananda muthaiah
No, Any solution found yet . Did anyone try this. On Sat, Jun 28, 2014 at 11:25 AM, Vaibhav Joshi wrote: > Did this got resolved at your end or do you need help on this? > > > On Tue, Jun 24, 2014 at 10:39 PM, yogananda muthaiah < > yogananda.mutha...@gmail.com> wrote: > >> Hello Cham

$$Excel-Macros$$ Re: fill in the missing data for highlighted rows - macro request

2014-06-28 Thread jun a
Hi, Thanks a lot for your help and your time into this solution, i am sorry to inform, as the logic is slightly incorrect. if i run the id2 macro, it fills row 21 (please the example file above) id2 with value, where it should only have id1 value. if its not much trouble, to combine the ma

$$Excel-Macros$$ Need a help in Pivot

2014-06-28 Thread Ganesh N
Hi Team, I have the shift details. I want only the shift count excluding OFF days but when i try pivot i have dayend count including OFF's. Can any one help me out with the Pivot how to do it ? PFA Thanks & Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna b