$$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

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 <jayendra.gau...@gmail.com> 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 &g

$$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)

$$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

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 rockerna...@gmail.com 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

$$Excel-Macros$$ Fwd: FW:

2014-08-12 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) jayendra.gau...@cnhind.com

$$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?

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 samde...@gmail.comwrote: 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, I need to open one exel file frequently .I

$$Excel-Macros$$ Re: support

2012-08-13 Thread jayendra gaurav
pls support me On Tue, Aug 7, 2012 at 5:36 PM, jayendra gaurav jayendra.gau...@gmail.comwrote: 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 -- J.Gaurav Call

$$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

$$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$$ 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,

$$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

$$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

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

2011-04-18 Thread jayendra gaurav
://www.homeandlearn.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 conditional formating. Matter is urgent. -- J.Gaurav Cell - 9327348097

$$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 http://nseindia.com/, please help me -- J.Gaurav -- -- Some important links for excel

$$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 jayendra.gau...@gmail.comwrote: 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

$$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 - based on

$$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 the container

$$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

$$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 container

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

2009-03-26 Thread jayendra gaurav
U can use conditional foramating. On Wed, Mar 25, 2009 at 4:17 PM, Sachin Shukla sachina...@gmail.com 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

$$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 tjeff...@gmail.com 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

$$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 rabinthapa2...@gmail.comwrote: Please help me on attach files. -- Regards, Rabindra Thapa ¨`·.·´¨) Always `·.¸(¨`·.·´¨) Keep (¨`·.·´¨)¸.·´ Smiling! `·.¸.·´ (¨`·.·´¨) (¨`·.·´¨) `·.¸(¨`·.·´¨)¸.·´ `·.¸.·«*:·.