$$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 -- Are you =EXP

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

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

-- 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 To: excel-macros

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

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 Revenue

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

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 Revenue

$$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$$ 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.commailto:anil.bha...@tatacommunications.com Regards, Anil Bhange -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

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@googlegroups.com

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

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

-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 - 400 001, India ' Desk : + 91 22 6659 2320

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

$$Excel-Macros$$ Pivot Table data extract

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 : + 91 22 6659 2320 | IP Phone : 51 2320

$$Excel-Macros$$ Numbers errors

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 after 15 digit. Anil Bhange Assistant Manager

$$Excel-Macros$$ Pivot Table data extract

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 : + 91 22 6659 2320 | IP Phone : 51 2320

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 From: excel

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

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@googlegroups.com

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 Subject: Re

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

$$Excel-Macros$$ Multiple Range Pivot Table

. 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 2320 | Mobile :+ 91 90290

$$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.commailto:anil.bha

RE: $$Excel-Macros$$ Reverse Vlookup

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 Bhange

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

in 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

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

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

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: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com

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

and 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/exceldailytip 2

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

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

and 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/exceldailytip 2

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

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$$ Please help to make my project good.

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 Subject: $$Excel-Macros$$ Please help to make my project good

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 To: excel-macros

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

$$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 group @ http

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

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

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

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

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$$ Don't want GETPIVOTDATA formula

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 Regards, Anil Bhange IP - 512320

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

/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$$ Re: hello all

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@googlegroups.com

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

. 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$$ Entry of more than 16

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 Behalf

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@googlegroups.com

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 Message- From: excel

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 1:17 AM

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