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

2014-05-22 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 BlackBer

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" Sender: excel-macros@googlegroups.com Date: Sat, 5 Apr 2014 04:21:56 To: Exce

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

2014-04-04 Thread Sandeep Kumar Chhajer
file 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? A

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

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: Sundarvel

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

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 Sender: excel-macros@googlegroups.com Date: Fri, 20 Dec 2

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 Sender: excel-macros@googlegroups.com Date: Fri, 20 Dec 2013 12:49:38 To: Reply-To: excel-macros@googlegroups

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" Sender: excel-macros@googlegroups.com Date: Tue, 10 Dec 2013 23:25:40 To: Reply-To: excel-macros@go

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

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

2013-10-29 Thread Sandeep Kumar Chhajer
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 Sender: excel-ma

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

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

2013-10-08 Thread Sandeep Kumar Chhajer
End If Loop Until ActiveCell.Offset(0, -4).Value = "" End Sub 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

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

2013-10-05 Thread Sandeep Kumar Chhajer
, ashish koul 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 of entri

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

2013-10-05 Thread Sandeep Kumar Chhajer
0, 1).Select > ActiveCell.Formula = ActiveCell.Offset(0, -1) * 1 > ActiveCell.Offset(0, -1).Select > End If > Loop Until ActiveCell.Offset(0, -4).Value = "" > End Sub > * > * > Please Help me out. > > Thanks in advance. > > > -- > Regards, > S

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 Sender: excel-macros@googlegroups.com Date: Mon, 9 Sep 2013 16:22:16 To: Reply