RE: $$Excel-Macros$$ QUERRY

Hi Nimi, Please find your answer Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Nemi Gandhi Sent: Monday, January 31, 2011 4:05 PM To: excel-macros@googlegroups.com Subject: $$Excel

RE: $$Excel-Macros$$ Pivot table problem

Hi Deepak, Please find the reply to your queries. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deepak Rawat Sent: Tuesday, February 01, 2011 11:11 AM To: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ HOW TO CONVERT DATE IN TEXT WITH FOMULA

Simple way is create separate table where you will get months than do VLOOKUP... :) Like 1 = April, 2 = May, 3 = Juneetc. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of solomon raju

RE: $$Excel-Macros$$ HOW TO CONVERT DATE IN TEXT WITH FOMULA

Hi Aamir, Please see the difference in formatting of text. Mmmm will give you February Mmm will give you Feb Mm will give you 2 Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir

RE: $$Excel-Macros$$ Counting words or letters

Please use =LEN("Cell reference") it will count the words / letters of specific cell Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jorge Marques Sent: Friday, February 04, 2011

RE: $$Excel-Macros$$ Copying userform to new worksheet - Excel 2003

"I have created a complex spreadsheet... .. Can anyone point me in the right direction" Right Direction : Don't Create complex worksheet, keep life simple :-) Regards,    Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 -Original Me

RE: $$Excel-Macros$$ Button programming

It wont be possible as enabling or disabling of macro is depend up on the each computer security policy You can't do that If is one time efforts which you have to do in all computers Regards, Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroup

RE: $$Excel-Macros$$ Entry of more than 16 characters in a cell

;t tried any of them. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Khandelwal Sent: Saturday, February 26, 2011 1:31 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ E

RE: $$Excel-Macros$$ SubTotal and Insert Req

Another way, Do filter on database > select all visible cells (Alt + ;) then insert row, it will insert row before all Sub Total's lines Regards, Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On B

RE: $$Excel-Macros$$ Remove text from a string

Amazing Dave... very well answered... Could you please let us know how "~~" this is useful. Could you please explain or give me a link to understand this. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@google

RE: $$Excel-Macros$$ Re: hello all, its very urgent;;;

m/Utility/ClusterStackUtility.html> Regards, Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Sent: Wednesday, March 23, 2011 11:46 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros

$$Excel-Macros$$ Don't want GETPIVOTDATA formula

which I can save in personal.xlsx which will not give me formula "GETPIVOTDATA". I found it interesting... and your suggestions will help many users Please try this and give us soultions.. [cid:image001.png@01CBEB08.274C03F0] Thanks &

RE: $$Excel-Macros$$ Don't want GETPIVOTDATA formula

Amazing Daniel... You saved my lot of time... thanks once again Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Daniel Sent: Saturday, March 26, 2011 4:10 PM To: excel-macros

$$Excel-Macros$$ Chart formatting

,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http

$$Excel-Macros$$ Auto Refresh data in excel

Hi Expert, Some of my excel sheet has linked with Internet which requires live auto updation, by default I can do 1 min refresh... Could you help me with any VB code where I can do it on live basis and at background excel update the data. Thanks & Regards, Anil Bhange IP - 51

$$Excel-Macros$$ RE: Marquee in Excel

Hi Ashish, Thanks for sharing the file... but file is not opening... it takes lot of time to open... and it shows the data is downloading from different sources Could you please help in this. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: ashish koul [mailto:koul.ash

RE: $$Excel-Macros$$ Re: Marquee in Excel

Thanks Rajan, But is it possible.. while the text is moving can we able to work on that work book... Actually I want to use this in my Dashboard where I can show the highlights of the month as moving text... Something similar to BSE / NSE website. Regards,Anil Bhange IP Phone - 512320

RE: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011

& Paul Schreiner are fantastic player in this match :) Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Saturday, April 02, 2011 6:55 PM To: excel-macros Subject: $$Excel-Ma

$$Excel-Macros$$ Unable to break the links of worksheet

Hi All, Could you please help me many a times I wanted to break the links of my work sheet but I unable to do this... It also don't show any error but workbook still shows links. Thanks & Regards, Anil Bhange IP

$$Excel-Macros$$ Convert Excel Ranges to PDF

range only. Thanks & Regards, Anil Bhange IP - 512320 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN g

$$Excel-Macros$$ Auto Refresh Data

to be run at background and I should able to run on the files. Is there any way to do it.. Thanks & Regards, Anil Bhange IP - 512320 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips t

RE: $$Excel-Macros$$ Please help to make my project good.

Construction'!$I$2,0) And copy in all your gray cells Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of karan 1237 Sent: Wednesday, May 11, 2011 3:51 PM To: excel-macros@googlegroups.com S

RE: $$Excel-Macros$$ Calculate Due dates

I think Ashish is right use this, Still try with this "mmm'" Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mr excel Sent: Wednesday, May 11, 2011 8:37 PM T

RE: $$Excel-Macros$$ Re: Help with Budget - Formula

See if it helps... Regards,    Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Pradhan Sent: Wednesday, May 18, 2011 2:00 PM To: excel-macros@googlegroups.com Subject

RE: $$Excel-Macros$$ Help on Transpose Function based upon criteria

Check this one it will help you http://en.kioskea.net/forum/affich-132961-vlookup-find-value-3-4-5-etc Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Wednesday

RE: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

There is no array used.. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Thursday, May 19, 2011 7:25 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros

$$Excel-Macros$$ Excel File icon changed.. wanted to retrive

the internal data image... please help Thanks & Regards, Anil Bhange IP - 512320 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailyt

RE: $$Excel-Macros$$ Excel File icon changed.. wanted to retrive

Hi All, I am still facing problem, there is no Properties button in excel.. I am using Excel 2010... Please help me.. my all files preview shows internal data and not the default excel picture Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros

RE: $$Excel-Macros$$ Excel File icon changed.. wanted to retrive

not the internal data image... please help Thanks & Regards, Anil Bhange IP - 512320 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldail

RE: $$Excel-Macros$$ Formula to Calculate Hours Between Dates

Hi John, Noorain reply is awesome but to give you other solution, Format > Format cells > custom > instead of "hh:mm" put "hh.mm" i.e. instead of ":" use "." Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: e

$$Excel-Macros$$ Check this site to test your Excel Knowledge

http://www.skills-assessment.net/home/frmindex.aspx Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

$$Excel-Macros$$ VBA Code against VLOOKUP function

Report worksheet it should call the data from master worksheet and give me Group 1 and Group 2 Please help Regards, Anil Bhange -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and

RE: $$Excel-Macros$$ VBA Code against VLOOKUP function

Thanks Noorain, One more help please, If the GL code doesn't match can I able to color these cell in Red color Regards, Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: F

$$Excel-Macros$$ Reverse Vlookup

. Anil Bhange Business Planning & Management Reporting Financial Planning & Analysis, TATA Communications Ltd. 6th Floor, B Wing, Bandra Kurla Complex, Bandra (East), India ' Desk : + 91 22 6659 2320 | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 anil.bha...@tatacommunications.com<

RE: $$Excel-Macros$$ Reverse Vlookup

t the result Regards, Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of XLS S Sent: Thursday, July 28, 2011 05:44 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Reverse Vlookup Try

RE: $$Excel-Macros$$ Reverse Vlookup

Thanks Daniel, It's amazing and Finance people on this group will be grateful to you, just one more request to get this function inbuilt in excel, could you please share how and where to save the below macro. Because I tried but not getting answer and it shows Error. Regards, Anil B

$$Excel-Macros$$ Multiple Range Pivot Table

ding. Please let me know if any facility available in excel. Anil Bhange Business Planning & Management Reporting Financial Planning & Analysis, TATA Communications Ltd. 6th Floor, B Wing, Bandra Kurla Complex, Bandra (East), India ' Desk : + 91 22 6659 2320 | IP Phone : 51 23

RE: $$Excel-Macros$$ Multiple Range Pivot Table

Ctrl + Shift + P is not working in attached file Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Sunday, August 07, 2011 07:00 PM To: excel-macros@googlegroups.com Subject

RE: $$Excel-Macros$$ Multiple Range Pivot Table

Hi Venkat, Actually I need the facility where I could able to select multiple ranges as per my requirement, and able to generate the report based on all ranges columns. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros

RE: $$Excel-Macros$$ Re: Guruuuuuuuu URGENT HELP ME

change the formula and we have to delete all the formula and apply it again" So instead why can't we use normal formula and change it accordingly as per our requirement. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@

RE: $$Excel-Macros$$ Re: Guruuuuuuuu URGENT HELP ME

Oh that's great... thank you very much Regards, Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Monday, August 29, 2011 04:38 AM To: excel-macros@googlegroups.com Subjec

$$Excel-Macros$$ Pivot Table data extract

have to do "Convert to Range" Is there any shortcut where I don't get these details in Table format and will get in the normal data details. Anil Bhange Assistant Manager Financial Reporting & Compliance, TATA Communications Ltd. VSB, Fort, Mumbai - 400 001, India ' Desk :

RE: $$Excel-Macros$$ Pivot Table data extract

Sorry.. just to reframe the question... I wanted all the details but not in "Table" format, because there I again need to convert the table to Range I want the information in normal format without any formatting. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 F

$$Excel-Macros$$ Add to the Group

Hi Ayush, Can you please add my below Email ID to the Excel macros google group. Email ID : anil.bha...@tatacommunications.com<mailto:anil.bha...@tatacommunications.com> Regards, Anil Bhange -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

RE: $$Excel-Macros$$ Required Revenue started from Date..

and better. Regards, Anil Bhange IP Phone - 800105 | Mobile - +31 6 1192 3971 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Friday, August 31, 2012 03:10 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Reve

$$Excel-Macros$$ SAP FICO group

aware about such kind of groups can you please share their email ID. Regards,Anil Bhange IP Phone - 800105 | Mobile - +31 6 1192 3971 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use

FW: $$Excel-Macros$$ countdown macro needed.........

Hi Experts, I am also looking for this solution, can you please help. Regards,    Anil Bhange IP Phone - 800105 | Mobile - +31 6 1192 3971 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dhananjay Pinjan Sent: Wednesday

$$Excel-Macros$$ RE: SAP FICO group

aware about such kind of groups can you please share their email ID. Regards,Anil Bhange IP Phone - 800105 | Mobile - +31 6 1192 3971 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use

FW: $$Excel-Macros$$ Required Revenue started from Date..

and better. Regards, Anil Bhange IP Phone - 800105 | Mobile - +31 6 1192 3971 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Friday, August 31, 2012 03:10 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Reve

RE: $$Excel-Macros$$ Ctrl+End Command

Hi Aamir, After deleting the rows and column close the excel and re-open the file.. Then it will not got to the same address. Regards,Anil Bhange IP Phone - 800105 | Mobile - +31 6 1192 3971 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir

RE: $$Excel-Macros$$ Learn Array formula's

Try this http://www.cpearson.com/excel/ArrayFormulas.aspx Regards,Anil Bhange IP Phone - 800105 | Mobile - +31 6 1192 3971 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Muralidhar E Sent: Monday, October 15, 2012 01:39 PM To: excel-macros

RE: $$Excel-Macros$$ Learn Array formula's

ay formulas' Tag -- Chandoo http://chandoo.org/wp/tag/array-formulas/ Regards,Anil Bhange IP Phone - 800105 | Mobile - +31 6 1192 3971 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Muralidhar E Sent: Monday, October 15, 2012 01:39 PM

$$Excel-Macros$$ Numbers errors

What I understood is after 15 digit excel doesn't recognize the numbers and convert it to "0" I tried using Value formula & Text formula but still it doesn't work because at the time of copy paste it again converting to number format. And if I do F2 and enter it shows "0&q

$$Excel-Macros$$ Pivot Table data extract

have to do "Convert to Range" Is there any shortcut where I don't get these details in Table format and will get in the normal data details. Anil Bhange Assistant Manager Financial Reporting & Compliance, TATA Communications Ltd. VSB, Fort, Mumbai - 400 001, India ' Desk :

$$Excel-Macros$$ Formula needed to extract the text from string

/ 20110279 TRANSACTIEDATUM 10-10-2011 /ENTRY-10 OCT TRF/REF 6004ABS68300025023 /ORD/ U-WISS CONSULTANCY OUDAEN 26 LELYSTAD /BNF/ 20110295 TRANSACTIEDATUM 10-10-2011 Anil Bhange Assistant Manager Financial Reporting & Compliance, TATA Communications Ltd. VSB, Fort, Mumbai -

RE: $$Excel-Macros$$ Formula needed to extract the text from string

Amazing... Ms-Exl-learner... This is exactly what I wanted... I was pretty sure this forum only can help me with solution... Thanks once again.. this saves my lot of time... Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel

RE: $$Excel-Macros$$ Formula needed to extract the text from string

Hi Ms-EXl-learner and Noorain, Could you help me with another formula for attached mail. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anil Bhange Sent: Wednesday, October 12, 2011 04:14

RE: $$Excel-Macros$$ Urgent help needed

which need to select (single time) and sheets to be consolidate (as selection only once) Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Thursday, October 27, 2011 05:37 PM

RE: $$Excel-Macros$$ Urgent help needed... (apologies)

Thanks guys... For suggesting the same... will take care next time Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: Thursday, October 27, 2011 08:45 PM To: excel

RE: $$Excel-Macros$$ Macro for worksheet consolidation

Hi Don, I tried your macro, but still it doesn't solving my problem, I wanted worksheet name should appear in column A and for all the data which copied from that particular worksheet. Regards, Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroup

$$Excel-Macros$$ Negative Numbers in Excel

, Also I would like to keep this as default format for all the worksheet, can I able to do that?? Regards, Anil Bhange IP - 800105 -- 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 @

$$Excel-Macros$$ Date Picker macro

Hi Friends, Can you please share me the macro of Date picker or any sample file which I can use in excel to input the date. I seared on net but unfortunately I don't have the "Microsoft Monthview Control 6.0 (SP6)" on my VBA. Please help. Regards, Anil Bhange IP - 800105 -