$$Excel-Macros$$ How to convert Pivot

2016-05-26 Thread jayendra gaurav
Dear Expert, I want a macro to convert data from pivot form to normal form. -- J.Gaurav Call-7838594954 -- 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 official Facebook page of this forum @ https://www.facebook.com/discussexcel FOR

Re: $$Excel-Macros$$ Macro Require

2016-03-06 Thread jayendra gaurav
please support me. On Mon, Feb 29, 2016 at 6:19 PM, jayendra gaurav wrote: > Dear All, > > > I have 1150 separate files of part list Variant wise. and other hand I > have part list can you please suggest way that how can I search part usage > quantity of each part no a

$$Excel-Macros$$ WANT TO open FILE frequently

2015-05-26 Thread jayendra gaurav
Team, I want to open some file frequently. is any option available in excel 2013 to create a symbol in menu bar .when ever I open excel same symbol appear on menu bar and when I clicked on the symbol .my file get open. [image: Inline image 1] -- J.Gaurav Call-7838594954 -- Are you =EXP(E:RT)

Re: $$Excel-Macros$$ Re: HOW COMPARE LIST OF FILE WITH EXCEL SHEET

2015-04-16 Thread jayendra gaurav
thanks Mandeep. it is perfectly working. On Thu, Apr 16, 2015 at 6:15 PM, Mandeep Baluja wrote: > chk dis out. > > Regards, > Mandeep Baluja > > On Thursday, April 16, 2015 at 5:52:30 PM UTC+5:30, sonu wrote: >> >> Experts, >> >> I want to convert file name in Excel . >> >> for example I have 1

$$Excel-Macros$$ HOW COMPARE LIST OF FILE WITH EXCEL SHEET

2015-04-16 Thread jayendra gaurav
Experts, I want to convert file name in Excel . for example I have 100 files in folder and I want to convert all file name in excel. please support. -- J.Gaurav Call-7838594954 -- 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 official

$$Excel-Macros$$ kindly UNLOCK MY EXCEL FILE

2014-08-22 Thread jayendra gaurav
TEAM, I have forgotten my password.kindly unlock the same . its very urgent . -- J.Gaurav Call-7838594954 -- 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 official Facebook page of this forum @ https://www.facebook.com/discussexcel FO

$$Excel-Macros$$ Fwd: FW:

2014-08-11 Thread jayendra gaurav
Team, I have two excel file attached here which are password protected .but i have forget the password . kindly support me and any one help me to open this file . thanks regards Gaurav -- Forwarded message -- From: GAURAV Jayendra (CNH Industrial) Date: Mon, Aug 11, 2014 at 2

Re: $$Excel-Macros$$ Support -

2013-03-13 Thread jayendra gaurav
how can i do it On Wed, Mar 13, 2013 at 7:37 PM, Sam Mathai Chacko wrote: > Why don't you just create a shortcut pointing to your file? > > > On Wed, Mar 13, 2013 at 7:34 PM, jayendra gaurav < > jayendra.gau...@gmail.com> wrote: > >> Dear All, >> >

$$Excel-Macros$$ Support -

2013-03-13 Thread jayendra gaurav
Dear All, I need to open one exel file frequently .I require one icon on my tool bar where if I clicked then my file need to open. this feature was available in exel 2003. kindly support me. -- J.Gaurav Call-7838594954 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? I

$$Excel-Macros$$ Re: support

2012-08-12 Thread jayendra gaurav
pls support me On Tue, Aug 7, 2012 at 5:36 PM, jayendra gaurav wrote: > Team, > > I am using excel 2007. > > I have one file .i need one icon for all excel work book where i click > and that file need to open. > > > > > -- > J.Gaurav > Call-78385

$$Excel-Macros$$ support

2012-08-07 Thread jayendra gaurav
Team, I am using excel 2007. I have one file .i need one icon for all excel work book where i click and that file need to open. -- J.Gaurav Call-7838594954 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for

$$Excel-Macros$$ support - pivot table log.

2012-08-07 Thread jayendra gaurav
Team, I wan to maintain a log for pivot table. example - when I click on refresh button that time old data save in log file. -- J.Gaurav Call-7838594954 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for viola

$$Excel-Macros$$ How to count

2012-07-24 Thread jayendra gaurav
Team, How to count a cell based on color . file is attached for your's reference. -- J.Gaurav Call-7838594954 -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, C

$$Excel-Macros$$ unhide all sheet

2012-06-05 Thread jayendra gaurav
Dear Team, I required your support to unhide 20 sheets in single go. kindly support me . -- J.Gaurav Call-7838594954 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

$$Excel-Macros$$ kindly suggest me how can I Unhide all the hide sheet in a single go.

2011-08-24 Thread jayendra gaurav
Team, I have hide 50 sheet in a work book kindly suggest me how can I Unhide all the hidden sheet in a single go. -- J.Gaurav Cell - 9327348097 -- -- Some important links for excel users: 1. Follow us on TWITTER

$$Excel-Macros$$ difference time calculation

2011-08-19 Thread jayendra gaurav
Dear team, Kindly help me in this regards -- J.Gaurav Operation Manager -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join o

$$Excel-Macros$$ down load data from BSE/NSE

2011-04-18 Thread jayendra gaurav
Dear Group. I want to basically fetch historical data of stock markets - derivatives - from the website of NSEINDIA.COM , please help me -- J.Gaurav -- -- Some important links for excel u

Re: $$Excel-Macros$$ Conditional formating help

2011-04-18 Thread jayendra gaurav
dlearn.co.uk/excel2007/excel2007s6p2.html > On Fri, Apr 15, 2011 at 9:54 AM, jayendra gaurav < > jayendra.gau...@gmail.com> wrote: > >> >> >> >> Dear all , >> >> >> >> please find herewith attached file .I want some help about condition

$$Excel-Macros$$ Conditional formating help

2011-04-15 Thread jayendra gaurav
Dear all , please find herewith attached file .I want some help about conditional formating. Matter is urgent. -- J.Gaurav Cell - 9327348097 -- -- Some important links for excel users: 1. Follow us on TWITTER

$$Excel-Macros$$ Re: test mail

2009-05-06 Thread jayendra gaurav
pls help me. On Sat, May 2, 2009 at 9:46 AM, jayendra gaurav wrote: > > Dear all > Pls help me for below point.in attached file > > > 1. When chage the calender year the data reamins same on that day. 2. > Required daily task( TO DO) to be cary forward next day if

$$Excel-Macros$$ Re: Fwd: mACRO HELP

2009-04-13 Thread jayendra gaurav
> Dear All, > > Can you please help me write a macro to simplify finding the packing list. > The required files are attached for your reference. The tedious job that we > do is as under: > > >- Fin`ding the container number PONU7259344 from the daily vehicle >entry file an excel file >-

$$Excel-Macros$$ Re: Fwd: mACRO HELP

2009-04-09 Thread jayendra gaurav
Dear Ashis , U helps to all member ,pls help me also.Mateer is most urgent > > > >> Dear All, >> >> Can you please help me write a macro to simplify finding the packing list. >> The required files are attached for your reference. The tedious job that we >> do is as under: >> >> >>- Fin`ding

$$Excel-Macros$$ Re: Fwd: mACRO HELP

2009-04-08 Thread jayendra gaurav
Still I am waiting ..Pls Help me in this regards.matter is most urgent. > Dear All, > > Can you please help me write a macro to simplify finding the packing list. > The required files are attached for your reference. The tedious job that we > do is as under: > > >- Fin`ding the co

$$Excel-Macros$$ Fwd: mACRO HELP

2009-04-08 Thread jayendra gaurav
Dear All, Can you please help me write a macro to simplify finding the packing list. The required files are attached for your reference. The tedious job that we do is as under: - Fin`ding the container number PONU7259344 from the daily vehicle entry file an excel file - based on the con

$$Excel-Macros$$ Re: Help required Colour on Rows and Column

2009-03-25 Thread jayendra gaurav
U can use conditional foramating. On Wed, Mar 25, 2009 at 4:17 PM, Sachin Shukla wrote: > Dear All, > > Please help me on said subjects . I attached sheet for same problem. > > Thanks in Advance > > > Sachin Shukla > Business Analyst > New Delhi > > > > -- J.Gaurav Asst. Manager Mahindra logi

$$Excel-Macros$$ Re: Calling all Wizard - Help needed in attached file

2009-03-23 Thread jayendra gaurav
Where is sc file ??. On Wed, Feb 25, 2009 at 6:25 AM, Tom Jeffries wrote: > Take a look at the attached workbook and see if it does what you want. I > placed buttons on the "SC" worksheet for each function you describe. I > wasn't sure how you wanted to export the SC worksheet as text so I exp

$$Excel-Macros$$ Re: problem deleting last cell in a specific row

2009-02-25 Thread jayendra gaurav
U can also use filter option rgd Gaurav On Wed, Feb 25, 2009 at 11:23 AM, Lavprasad Kori wrote: > Hi Dear, > > Attached herewith the file of solution of your question. In that the > solution is in column E. You have to copy Column E & paste special it in > Column D. > > Regards, > > Lavprasad Ko

$$Excel-Macros$$ Re: Help-Excel files formula

2009-02-04 Thread jayendra gaurav
pls go through pivote table. On Tue, Feb 3, 2009 at 8:09 PM, Rabindra Thapa wrote: > > Please help me on attach files. > -- > > Regards, > Rabindra Thapa > ¨`·.·´¨) Always > `·.¸(¨`·.·´¨) Keep > (¨`·.·´¨)¸.·´ Smiling! > `·.¸.·´ > (¨`·.·´¨) (¨`·.·´¨) > `·.¸(¨`·.·´¨)¸.·´ > `·.¸.·«*:·. > .·:* > *:·.