$$Excel-Macros$$ Break Internal Links with in a Workbook-Excel

2014-05-23 Thread Sandeep Kumar Chhajer
Dear Excel Gurus, I have a workbook with multiple Tabs which are interlinked. I want to break all the link at once. Is it possible with any shortcut / key stroke or Tricks ? Please help me out. Thanks in advance. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R

Re: $$Excel-Macros$$ Compare two worksheet Trial Balance

2014-04-05 Thread Sandeep Kumar Chhajer
Dear Excel gurus, Kindly check the trailing mail. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -Original Message- From: Sandeep Kumar Chhajer chhajersand...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 5 Apr 2014 04:21:56

$$Excel-Macros$$ Compare two worksheet Trial Balance

2014-04-04 Thread Sandeep Kumar Chhajer
with you all. I hope you all understand) If any one can help me out to automate the report I will be highly grateful. Thanks in advance. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Average Graph

2014-03-15 Thread Sandeep Kumar Chhajer
Hi Praful, This happens everyday in stock market!! I think you should use moving average let's say average of every 5 days and plot everyday's moving average into graph! Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -Original Message- From

Re: $$Excel-Macros$$ calculate previous month dates using the given date

2014-02-11 Thread Sandeep Kumar Chhajer
Can you give another example so that the logic get clear! Like what do you want if given date is 25th December 2013. 24th November to 23rd December? Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -Original Message- From: Sundarvelan N nsund

$$Excel-Macros$$ C002AB8CF

2014-02-02 Thread Sandeep Kumar Chhajer
Those who are using BBM Channel check out this channel. Channel Pin C002AB8CF. :) Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -- 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

Re: $$Excel-Macros$$ material Stock Inventory in Excel

2013-12-19 Thread Sandeep Kumar Chhajer
Hi Jockey, Please specify your requirement. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -Original Message- From: Jocky Beta jocky6...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 20 Dec 2013 12:49:38 To: excel-macros

Re: $$Excel-Macros$$ material Stock Inventory in Excel

2013-12-19 Thread Sandeep Kumar Chhajer
Rupesh, Please use new thread for new queries, don't send new queries on others thread. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -Original Message- From: Rupesh Patil patil.rupesh1...@gmail.com Sender: excel-macros@googlegroups.com Date

Re: $$Excel-Macros$$ MS Excel

2013-12-11 Thread Sandeep Kumar Chhajer
I possible please share a sample file. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -Original Message- From: Soni.Rajender soni.rajen...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 10 Dec 2013 23:25:40 To: excel-macros

$$Excel-Macros$$ Power Pivot

2013-11-28 Thread Sandeep Kumar Chhajer
Dear All, I have excel 2013, I want to know what enhanced feature it has from 2010 and I also want to know about power pivot and its uses. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

$$Excel-Macros$$ Pivot Table queries

2013-10-29 Thread Sandeep Kumar Chhajer
Hi, Excel gurus, I want to get a column in a pivot table which is comprising of division of two data-source column. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2

Re: $$Excel-Macros$$ Pivot Table queries

2013-10-29 Thread Sandeep Kumar Chhajer
and other being count, now I want to work with this two column i.e. Sum column / count column with in pivot table, Is it possible? Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -Original Message- From: Anoop K Sharma aks.sharm...@gmail.com Sender

$$Excel-Macros$$ Re: Recognizing Number format

2013-10-08 Thread Sandeep Kumar Chhajer
Thanks in advance. Thank you Regards Sandeep Kumar Chhajer. -- 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 FORUM RULES 1) Use concise

Re: $$Excel-Macros$$ Identifying Excel number format

2013-10-05 Thread Sandeep Kumar Chhajer
. Thanks in advance. -- Regards, Sandeep Kumar Chhajer. -- 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 FORUM RULES 1) Use concise, accurate thread titles

Re: $$Excel-Macros$$ Identifying Excel number format

2013-10-05 Thread Sandeep Kumar Chhajer
file. Hope it will work. On 5 October 2013 13:00, ashish koul koul.ash...@gmail.com wrote: i can't see custom format On Sat, Oct 5, 2013 at 12:59 PM, Sandeep Kumar Chhajer chhajersand...@gmail.com wrote: ** Dear Ashish, This is only original file, I have just cut down the number

Re: $$Excel-Macros$$ EX-QUERY

2013-09-09 Thread Sandeep Kumar Chhajer
Dear sridhar, I did not get you how leap year or non leap year affecting your result. Can you send us example. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: sridher sharma sridher.sha...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 9 Sep