Re: $$Excel-Macros$$ Re: Once IF is met it is not looping

2017-02-21 Thread Emamuddin Shah
Dear Paul, hope you have got change to go through the attached files. ---Emam On Monday, February 6, 2017 at 10:01:43 AM UTC+5:30, Emamuddin Shah wrote: > > Hi Paul, > > Hope you have received my email. > > Regards > Emam > > On Wednesday, February 1, 2017 at 12:5

Re: $$Excel-Macros$$ Re: Once IF is met it is not looping

2017-02-05 Thread Emamuddin Shah
Hi Paul, Hope you have received my email. Regards Emam On Wednesday, February 1, 2017 at 12:52:28 PM UTC+5:30, Emamuddin Shah wrote: > > Dear Paul, > > i will share my both excel sheets, so that you can check where iam wrong > and correct it, since the document is confidenti

Re: $$Excel-Macros$$ Re: Once IF is met it is not looping

2017-01-31 Thread Emamuddin Shah
of cells(1,3) > You're less likely to confuse the row/column. > > Of course, this doesn't apply when you're referring to the array index. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you ca

Re: $$Excel-Macros$$ Re: Once IF is met it is not looping

2016-10-19 Thread Emamuddin Shah
on. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.”

$$Excel-Macros$$ Re: Once IF is met it is not looping

2016-10-18 Thread Emamuddin Shah
ITS NOT UPDATED ALL 50 STRINGS ROW DETAILS. IT IS UPDATING ONLY FIRST MATCHED STRING ROW. On Tuesday, October 18, 2016 at 6:13:56 PM UTC+5:30, Emamuddin Shah wrote: > > Hello > > Iam trying to Loop so that it matched a string and then fills cells in > that row. > say

$$Excel-Macros$$ Re: Once IF is met it is not looping

2016-10-18 Thread Emamuddin Shah
ster Tracker.xlsx").Close savechanges:=True Application.ScreenUpdating = True End Sub On Tuesday, October 18, 2016 at 6:13:56 PM UTC+5:30, Emamuddin Shah wrote: > > Hello > > Iam trying to Loop so that it matched a string and then fills cells in > that row. > say i have 50 strings

$$Excel-Macros$$ Once IF is met it is not looping

2016-10-18 Thread Emamuddin Shah
Hello Iam trying to Loop so that it matched a string and then fills cells in that row. say i have 50 strings to be matched and then update date on that row, data i have stored in ARRAY here is my part of code where I am struck ++= cm = 1 For i = 2 To lri If Cells(i, 7) =

Re: $$Excel-Macros$$ Fetching Data from excel based on current date

2016-08-26 Thread Emamuddin Shah
ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Thursday, August 4, 2016 5:45 AM, Emamuddin Shah <emt...@gmail.com > > wrote: > > &g

Re: $$Excel-Macros$$ Click Button on URL using VBA

2016-08-25 Thread Emamuddin Shah
t;gb_70").Click > End With > End Sub > > On Thu, Aug 25, 2016 at 7:28 AM, Emamuddin Shah <emt...@gmail.com > > wrote: > >> Thanks Gaurav, but I don't want to navigate I want it to click that >> button. >> On Aug 25, 2016 6:40 PM, "Gaurav De

Re: $$Excel-Macros$$ Click Button on URL using VBA

2016-08-25 Thread Emamuddin Shah
viceLogin?hl=en= > true=https://www.google.co.in/%3Fgfe_rd%3Dcr% > 26ei%3Dvuy-V726B9GL8Qf9qYW4CQ%26gws_rd%3Dssl" >End With > End Sub > > On Thu, Aug 25, 2016 at 6:48 AM, Emamuddin Shah <emt...@gmail.com> wrote: > >> Please suggest solutions... I just started vb

Re: $$Excel-Macros$$ Click Button on URL using VBA

2016-08-25 Thread Emamuddin Shah
Please suggest solutions... I just started vba crawling On Aug 25, 2016 6:17 PM, "Gaurav Devrani" <gauravdev1...@gmail.com> wrote: > Please disregard my email. > > On Thu, Aug 25, 2016 at 6:05 AM, Emamuddin Shah <emt...@gmail.com> wrote: > >> >&

$$Excel-Macros$$ Click Button on URL using VBA

2016-08-25 Thread Emamuddin Shah
Dear Friends, iam trying to click an button on url, please help my error CODE- Sub click1() Dim ie As InternetExplorerMedium Dim url As String Set ie = New InternetExplorerMedium '### BUILD THE FULL URL url = "www.google.com"

$$Excel-Macros$$ Fetching Data from excel based on current date

2016-08-04 Thread Emamuddin Shah
Hello All, iam an intermediate user of VBA i love to automate, iam struck in on of my code when iam using to fetch data from my excel sheet based on todays date and same thing copied after last rows. it is working but in last all copied cells goes empty.. here is my code please suggest.

$$Excel-Macros$$ purchase sales in excel

2015-12-29 Thread hemal shah
HI All genius, In one sheet I have put purchases and in second sheet there is sales against purchase. In both sheets *RG* is unique id. In need sales data against Purchases. How to execute this function.? Please guide me in this -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ How to makeing a check box

2015-04-13 Thread Dhaval Shah
if i tick then wanna Yes and no tick then No Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Mon, Apr 13, 2015 at 12:07 PM, Dhaval Shah todhavals...@gmail.com wrote: pls go through the attechment i put a checkbox in my file but i cant

Re: $$Excel-Macros$$ Re: How to makeing a check box

2015-04-13 Thread Dhaval Shah
Thanks Dear :) Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Mon, Apr 13, 2015 at 1:49 PM, TAWHID tawhid.ha...@gmail.com wrote: Hi Dhaval Shah, See the attached file. I Have put few of them . You can copy paste and rename as you

$$Excel-Macros$$ Formula required

2015-03-31 Thread Dhaval Shah
PFA Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* -- 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

Re: $$Excel-Macros$$ Re: Help Needed

2015-03-02 Thread Dhaval Shah
ANY OTHER WAY TO USE OPTION OF PIVOT TABLE ?? Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Mon, Mar 2, 2015 at 3:52 PM, Dhaval Shah todhavals...@gmail.com wrote: THANKS DEAR FOR U R EFFORTS BUT ITS NOT USE FULL TO ME BECAUSE WHILE I

Re: $$Excel-Macros$$ Re: Help Needed

2015-03-02 Thread Dhaval Shah
THANKS DEAR FOR U R EFFORTS BUT ITS NOT USE FULL TO ME BECAUSE WHILE I UPDATE ITS PASTE WRONGLY Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Mon, Mar 2, 2015 at 12:24 AM, michael vinoth michaelvino...@gmail.com wrote: Hi Dhaval Shah

$$Excel-Macros$$ Help Needed

2015-02-28 Thread Dhaval Shah
, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* -- 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

$$Excel-Macros$$ Recover excel file opening passowrd

2014-08-25 Thread hemal shah
Dear Expert I have forget the passowrd of my old excel file .is there anyway to recover the password. ? Please help it is urgent -- 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 @

Re: $$Excel-Macros$$ is it any easy way to import DAT file to Excel

2014-07-15 Thread Dhaval Shah
thanks vaibhav :) Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Tue, Jul 15, 2014 at 7:43 PM, Vaibhav Joshi v...@vabs.in wrote: check this too... http://www.marketcalls.in/spreadsheet/how-to-extract-data-from-nseinda-com-using

Re: $$Excel-Macros$$ Help Needed

2014-06-17 Thread Dhaval Shah
fyi Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Tue, Jun 17, 2014 at 12:51 PM, Rakesh kumar rakesh.apt...@gmail.com wrote: Hi Guys, I want to use formula on pivot table data. Kindly help me. -- Thanks £ Regards Rakesh Kumar

$$Excel-Macros$$ inserting missing date in data

2014-04-16 Thread shailesh Shah
i have found a macro from the internet to add missing date in the data. its not working in excel 2010. it is giving type mismatch error. would appreciate if i get guided. Option Explicit Sub AddMissingDates() 'JBeaucaire (12/13/2009) Dim LR As Long, i As Long Application.ScreenUpdating =

Re: $$Excel-Macros$$ inserting missing date in data

2014-04-16 Thread shailesh Shah
Dear Paul, thanks for your response. the line which is giving the error is If Cells(i, A) Cells(i + 1, A) - 1 Then the date format is 01/01/2001 i tried to run the macro as you suggested. it is giving me the same error. i think the date format is a problem then. appreciate your help shah

Re: $$Excel-Macros$$ wanna halp in conditional icon set

2014-01-20 Thread Dhaval Shah
*To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ wanna halp in conditional icon set PFA On Fri, Jan 17, 2014 at 10:04 PM, Dhaval Shah ( Ahd ) todhavals...@gmail.com wrote: Hello friends I want help in conditional icon set … pls refer attached sheet

RE: $$Excel-Macros$$ how to reduce file size

2014-01-13 Thread Dhaval Shah ( Ahd )
formatting merging. See the file where size is half now. Thanks. On Tue, Jan 14, 2014 at 7:44 AM, Dhaval Shah todhavals...@gmail.com wrote: Friends i have a file with v limited data in file automatic my file size rise to 7.3 mb from 689 kb any suggestions ?? -- Are you =EXP(E:RT

Re: $$Excel-Macros$$ need chart help

2014-01-07 Thread Dhaval Shah
Thanks Waseem :) On Mon, Jan 6, 2014 at 8:33 PM, Waseem Saifi waseemsa...@gmail.com wrote: Perhaps you are looking for this. see attachment. regards, Waseem Saifi On 1/6/14, Dhaval Shah ( Ahd ) todhavals...@gmail.com wrote: Guys I need chart help Pls refer attached sheet

RE: $$Excel-Macros$$ NEED FORMULA HELP

2013-12-24 Thread Dhaval Shah ( Ahd )
, Cartik On Tue, Dec 24, 2013 at 10:57 AM, Dhaval Shah todhavals...@gmail.com wrote: hello, i want a formula help for my here with attached file pls refer my sheet thanks Dhaval Shah -- 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

$$Excel-Macros$$ Need formula help

2013-11-28 Thread Dhaval Shah ( Ahd )
Want to choss Day only from date pls refer attachment Thanks Dhaval Shah -- 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

RE: $$Excel-Macros$$ Need formula help

2013-11-28 Thread Dhaval Shah ( Ahd )
@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dhaval Shah ( Ahd ) Sent: Thursday, November 28, 2013 5:44 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need formula help Want to choss Day only from date pls refer attachment Thanks Dhaval Shah

Re: $$Excel-Macros$$ Data validation - Need help to prevent Duplicate Entry

2013-10-18 Thread Siddharth Shah
On Wed, Oct 16, 2013 at 8:29 PM, Secret Shot secrets...@gmail.com wrote: Dear Exterts, I am stuck in my project and need your expert advice that ho can i prevent duplicate data entry in any colom, but i have to use list validation too at the same time So for example my source range is

$$Excel-Macros$$ want open first sheet while open sheet

2013-08-01 Thread hemal shah
I have 3 sheets in my excel book. First sheet is Menu sheet. I want that, Menu sheet is to be open every time when I open excel file. -- 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 @

Re: $$Excel-Macros$$ want open first sheet while open sheet

2013-08-01 Thread hemal shah
Hi Priti, it is not working On Thu, Aug 1, 2013 at 3:05 PM, priti verma pritiverma1...@gmail.comwrote: you can use workbook open event to active worksheet Private Sub Workbook_Open() Worksheets(Menu).Activate End Sub On Thu, Aug 1, 2013 at 2:23 AM, hemal shah hemali...@gmail.com

Re: $$Excel-Macros$$ want open first sheet while open sheet

2013-08-01 Thread hemal shah
Thanks. On Thursday, 1 August 2013 16:04:01 UTC+5:30, suman kumar wrote: Hi You should use below code in ThisWorkbook in OPEN event. Please find the attached file now its working as well. *Suman Kumar* On Thu, Aug 1, 2013 at 3:53 PM, hemal shah hema

Re: $$Excel-Macros$$ month wise seq in pivot

2013-08-01 Thread hemal shah
how to create custom list On Friday, 2 August 2013 11:03:32 UTC+5:30, vijay wrote: Respected Hemal, Create a custom List and sort moths according to that custom list. Regards, Vijaykumar On Fri, Aug 2, 2013 at 10:33 AM, hemal shah hema...@gmail.comjavascript: wrote: in this file

Re: $$Excel-Macros$$ Need help

2013-07-22 Thread Dhaval Shah
Thanks Ravinder :) On Mon, Jul 22, 2013 at 4:05 PM, ravinder negi ravi_colw...@yahoo.comwrote: PFA.. -- *From:* Dhaval Shah todhavals...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Monday, July 22, 2013 3:46 PM *Subject:* $$Excel-Macros$$ Need

Re: $$Excel-Macros$$ use full link to learn Excel

2013-06-04 Thread Nikhil Shah
Thanks.. Nikhil On Mon, Jun 3, 2013 at 7:42 PM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear Frndz, Use full link to learn Excel. please find attached link!!! http://www.excel-pratique.com/en/index.php Thanks Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

$$Excel-Macros$$ New Approach to Learn MS Excel Shortcuts at Job

2013-05-23 Thread Richa Shah
1. Need to Speed up Excel Tasks at Job? 2. Hard time remembering Excel Shortcuts? 3. Spending extra hours learning it? Now, Learn Excel MS Shortcuts while you work at - http://www.excelgoodies.com/exceltools/excelshortcuttutor/ Happy Excelling :) - Team Excelgoodies -- Are

$$Excel-Macros$$ time wages calculation

2013-04-19 Thread hemal shah
Hi all expert see my attached file. I want to make excel sheet for time wages calculation. ..i want stored a time,when a check box is clicked in front respective date. as it is clicked,it should be locked. i used now function but it is updated continous basis... plz help -- Are you

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

2013-04-03 Thread Dhaval Shah
Lalit Sir didt work can u send me the sample file Thanks Dhaval Shah 079 - 40055253 On Wed, Apr 3, 2013 at 12:25 PM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: Hi Dhaval, Copy below formula at cell address C11 and confirm it with CSE *=MAX(($B$2:$B$68=$S$10)*($A$2:$A$68 = FUTSTK

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

2013-04-03 Thread Dhaval Shah
workbook and its working. On Wednesday, 3 April 2013 12:39:39 UTC+5:30, Dhaval Shah wrote: Lalit Sir didt work can u send me the sample file Thanks Dhaval Shah 079 - 40055253 On Wed, Apr 3, 2013 at 12:25 PM, Lalit Mohan Pandey mohan.p...@gmail.com wrote: Hi Dhaval, Copy below formula

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

2013-04-02 Thread Dhaval Shah
Dear Thanks for u r prompt reply but out put is not as per my requirement pls check the reference sheet On Tue, Apr 2, 2013 at 10:49 AM, xlstime xlst...@gmail.com wrote: Hi Dhaval, dhaval shah (1).xlsxhttps://docs.google.com/file/d/0B4LBSzxr1QTiVjZoYkRneFFUY1k/edit?usp=drive_web PFA

$$Excel-Macros$$ Re: Need expert advise for multipal Selection

2013-04-01 Thread Dhaval Shah
Hello all experts any solution for my query On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah todhavals...@gmail.com wrote: Dear Experts I want to make out multipul selection for my project pls refer my sheet Thanks Dhaval Shah -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

2013-04-01 Thread Dhaval Shah
cmp is current market price ( CLOSE PRICE ) On Tue, Apr 2, 2013 at 10:18 AM, xlstime xlst...@gmail.com wrote: what is CMP ?... you can use sumifs or sumproduct . Enjoy Team XLS On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah todhavals...@gmail.comwrote: Hello

$$Excel-Macros$$ Not able to do SUM

2013-03-18 Thread Dhaval Shah
Dear Friends me downlaod daily file from my back office pls refer NEt.xls i m not able to do sum at the end of the amount -- 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 @

Re: $$Excel-Macros$$ Not able to do SUM

2013-03-18 Thread Dhaval Shah
.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Mon, Mar 18, 2013 at 5:41 PM, Dhaval Shah todhavals...@gmail.comwrote: Dear Friends me downlaod daily file from

Re: $$Excel-Macros$$ Not able to do SUM

2013-03-18 Thread Dhaval Shah
can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* Dhaval Shah todhavals...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Mon, March 18, 2013 8:12:24

$$Excel-Macros$$ I want to merge two text cell

2013-03-06 Thread Dhaval Shah
dear friends i want to merge two text cell in one pls refer the sheet thanks dhaval -- 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

Re: $$Excel-Macros$$ Query collation of data ignoring #n/a

2013-02-15 Thread Dhaval Shah
pls chk On Fri, Feb 15, 2013 at 3:03 PM, vatspoojav...@gmail.com wrote: Hi All, I seek your guidance in the attached sheet, wherein, currently I am updating manually the column: I Correct Cost Centre Contracts.I am updating this from the data available in corresponding columns: D,E,F G.

Re: $$Excel-Macros$$ Need formula Solution

2013-02-15 Thread Dhaval Shah
Thanks Dear On Tue, Feb 12, 2013 at 10:04 PM, Excel Beginner excelbegin...@gmail.com wrote: Hi Dhaval, Find the attachment. -- *Regards,* * * *Excel Beginner* On Tue, Feb 12, 2013 at 1:42 PM, Dhaval Shah todhavals...@gmail.comwrote: Dear Friends pls refer my sheet

Re: $$Excel-Macros$$ How to order data in rows into distinct column sets

2013-01-31 Thread Alpesh Shah
find attached Sheet for Your REf. is i sOK? Warm Regards, Gawli Anil On Thu, Jan 31, 2013 at 3:12 AM, Alpesh Shah alpes...@gmail.com wrote: Dear Excel Masters, I have raw data that is in the following form: 1 name abc 2 address 234 john lane 3 company inc, co 4 website http

$$Excel-Macros$$ How to order data in rows into distinct column sets

2013-01-30 Thread Alpesh Shah
Dear Excel Masters, I have raw data that is in the following form: 1 name abc 2 address 234 john lane 3 company inc, co 4 website http://website.com 5 description company abc is abc What I would like to do is have this information look like this, where the data is taken from rows and

$$Excel-Macros$$ how to lock worksheet

2013-01-04 Thread Dhaval Shah
Dear friends i am lookking for solution 4 Lock work sheet if i am lock work sheet then i m not able to use filter actually i want to hide my formula's only is it any way to hide formula ??? Thanks Dhaval Shah -- Join official Facebook page of this forum @ https

Re: $$Excel-Macros$$ query for getting external data from a website

2012-12-30 Thread Dhaval Shah
Kenil pls click the below mention link to download data of any eq series stocks www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012 *TCS*EQN.csv www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012RELIANCE **EQN.csv just u have to change the

Re: $$Excel-Macros$$ HIGH LOW QUERY

2012-12-24 Thread Dhaval Shah
Thanks Dear For LOW ( Min ) ?? On Mon, Dec 24, 2012 at 5:17 PM, The Viper viper@gmail.com wrote: =INDEX($C$2:$C$3000,MATCH(F2MAX(IF($A$2:$A$3000=F2,$B$2:$B$3000,0)),$A$2:$A$3000$B$2:$B$3000,0)) -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ HIGH LOW QUERY

2012-12-23 Thread Dhaval Shah
Suppos i m change the data in Sintex manual then formula works On Mon, Dec 24, 2012 at 10:41 AM, Dhaval Shah todhavals...@gmail.comwrote: Hello Prince , Wish u merry Christmas i m facing some problem to find out High Low value Date in u r Formula pls see the attech file there is two

Re: $$Excel-Macros$$ Re: HTTP Request differences....

2012-12-21 Thread Dhaval Shah
Me Also Facing the same problem i m view below mention link in any browser but while i m try to import table in excel is not working http://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm?cat=N is it any other way to import Table in Excel Sheet On Wed, Dec 19,

Re: $$Excel-Macros$$ HIGH LOW QUERY

2012-12-13 Thread Dhaval Shah
Need Data Range upto 99000 in this sheet data Range upto only 2000 me try to change Data Range but its dosent work Pls do need full Thanks Dhaval Shah 98240 35253 On Wed, Dec 12, 2012 at 10:43 PM, Prince prince141...@gmail.com wrote: Hi Dhaval , Pls find Attached. Regards Prince

Re: $$Excel-Macros$$ HIGH LOW QUERY

2012-12-12 Thread Dhaval Shah
Already change data range but not working On Wed, Dec 12, 2012 at 6:24 PM, Satendra kumar satendrakuma...@gmail.comwrote: Hi, change data range than apply i hope this is working... thankx satendra On Wed, Dec 12, 2012 at 6:19 PM, Dhaval Shah todhavals...@gmail.comwrote: FRIENDS

Re: $$Excel-Macros$$ High low Query

2012-12-12 Thread Dhaval Shah
, Dhaval Shah todhav...@gmail.comjavascript: wrote: Friends, pls go through the attached excel sheet in main sheet there is raw data of differenet date for different product now suppose product x trade for 5 days and 5 days close value is also different need to know the which date

$$Excel-Macros$$ HOW TO IMPORT LIVE WEB PAGE TO EXCEL

2012-12-10 Thread Dhaval Shah
I M TRYIN TO IMPORT BELOW MENTION LINK http://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm?cat=N ACTUALLY RECENTLY NSE INDIA DONE SOME MODIFICATION WITH WEB SITE AFTER UPDATATION I M ENALBE TO IMPORT DATA FROM ABOVE LINK IS IT ANY OTHER WAY TO IMPORT TO EXCEL

$$Excel-Macros$$ NEED HELP

2012-12-09 Thread Dhaval Shah
-- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be

Re: $$Excel-Macros$$ NEED HELP

2012-12-09 Thread Dhaval Shah
, Dec 10, 2012 at 10:28 AM, Anoop K Sharma aks.sharm...@gmail.comwrote: Hi Dhaval, PFA... Regards, Anoop Sr. Developer On Mon, Dec 10, 2012 at 9:12 AM, Dhaval Shah todhavals...@gmail.comwrote: -- Join official Facebook page of this forum @ https://www.facebook.com

Re: $$Excel-Macros$$ Re: High low Query

2012-12-05 Thread Dhaval Shah
, Dhaval Shah wrote: Friends, pls go through the attached excel sheet in main sheet there is raw data of differenet date for different product now suppose product x trade for 5 days and 5 days close value is also different need to know the which date product x close on highest and lowest

Re: $$Excel-Macros$$ High low Query

2012-12-05 Thread Dhaval Shah
Thanks a Lot Brother On Wed, Dec 5, 2012 at 11:14 PM, Excel Beginner excelbegin...@gmail.com wrote: Hi Dhaval, Please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Wed, Dec 5, 2012 at 12:26 PM, Dhaval Shah todhavals...@gmail.comwrote: Friends

Re: $$Excel-Macros$$ Combo [ Formula + Macro Bible] - [Prince 9953872217]

2012-10-13 Thread Nikhil Shah
Hi Thanks for sending excellent file, (1). Prince Formula Bible (Updated Version) (2). Updated Lets Learn Together ( Macro Bible ) Can you send all files in excel 2003.. Nikhil On Sat, Oct 13, 2012 at 10:02 PM, Prince Sethi prince.seth...@gmail.comwrote: -- Regards [image:

Re: $$Excel-Macros$$ Re: Rajan Verma - Most Helpful Member September 2012

2012-10-13 Thread Nikhil Shah
Dear Members, Congratulations Rajan Nikhil On Sat, Oct 13, 2012 at 8:55 PM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: Many Congratulations RajanOnce Again...bhai On Tuesday, 2 October 2012 21:04:33 UTC+5:30, Ayush Jain wrote: Dear members, Rajan Verma has been selected

$$Excel-Macros$$ Fwd: Need help on a formula

2012-08-25 Thread hemant shah
Dear Experts, I haven't yet received solution for my query below. Please help. Regards, -- Forwarded message -- From: hemant shah hemanthin...@gmail.com Date: Sun, Aug 19, 2012 at 12:56 PM Subject: Need help on a formula To: excel-macros excel-macros@googlegroups.com Dear

$$Excel-Macros$$ Need help on a formula

2012-08-19 Thread hemant shah
Dear Experts, I am stuck up which my work in an excel. I need a help on a formula in the attached sheet. I have given a complete details explanation in the attached sheet. Need your help to come out of this situation. For any question or details please revert back. Thanks in advance.

$$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells

2012-08-04 Thread Alpesh Shah
Dear Excel Experts, I am working with a string as follows: | ABC:2013| ABCD| EFGH|2IJK | 3243| 9s9s| afjkdf| There are a total of 8 pipes | . My issue is that I am trying to Split this based on the pipes, and output the words in between into cells. I have been trying to solve this for a long

$$Excel-Macros$$ Excel 2010: Review each cell in a spreadsheet, Parse it, Rejoin it in Spreadsheet

2012-07-20 Thread Alpesh Shah
Dear Excel Experts, I have attached a spreadsheet with dummy data. The first tab shows the dummy information and the second tab shows what I would like it to look like. As I have over 100 of rows of data to do this for, I am looking to develop some vba code to help accelerate the work. Each row

Re: $$Excel-Macros$$ Clock Chart (Excellent)

2012-06-06 Thread Nikhil Shah
Hi Noorain , Thanks for sending excellent Chart File.. Nikhil On Thu, Jun 7, 2012 at 12:00 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Group, Please find attached Clock Chart. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com --

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)

2012-06-03 Thread Nikhil Shah
Congratulation Rajan Nikhil Shah On Mon, Jun 4, 2012 at 11:02 AM, Maries talk2mar...@gmail.com wrote: *Congrats Brother.* On Sun, Jun 3, 2012 at 9:36 PM, Anil Gawli gawlianil8...@gmail.comwrote: congrats Mr Rajan. Gawli Anil On Mon, Jun 4, 2012 at 9:23 AM, NOORAIN ANSARI

$$Excel-Macros$$ Re: Copy selected grouped object to newslides

2012-05-22 Thread Shah
I have attached a sample file to show what i mean. I have managed to copy the grouped objects from a single slide. However the complication arrises when I have to copy and collate the objects when they are on different slides. i.e. if i want to copy object 1 and 2 from slide 1 and 9 and 10

Re: $$Excel-Macros$$ Re: Quarter Classification

2012-04-16 Thread Nikhil Shah
Hi Haseeb, Nice Formula.. Thanks Nikhil On Mon, Apr 16, 2012 at 11:36 AM, Haseeb A haseeb.avarak...@gmail.comwrote: Nikhil, One way: Assume date is in A2. So In B2 for the Curr Quarter. =TEXT(LOOKUP(MONTH(A2),{1,4,7,10})*29,) Then in C2 =TEXT((1B2)+99,) Copy across to E2.

Re: $$Excel-Macros$$ Re: Quarter Classification

2012-04-15 Thread Nikhil Shah
Hi Haseeb, Sorry , answer is wrong. i.e. Dt.01/05/2010 ( DD/MM/ ) ,then Next Quarter should be July , here it's display april.. Nikhil On Sun, Apr 15, 2012 at 2:57 PM, Haseeb A haseeb.avarak...@gmail.comwrote: Hello Nikhil, This will give the current quarter.

Re: $$Excel-Macros$$ Quarter Classification

2012-04-15 Thread Nikhil Shah
Hi sam, super Idea Nikhil Shah On Sun, Apr 15, 2012 at 7:01 PM, Sam Mathai Chacko samde...@gmail.comwrote: A shorter one =CHOOSE(CEILING(MONTH(A1)/3,1),April,July,October,January) Regards, Sam On Sat, Apr 14, 2012 at 6:19 PM, Nikhil Shah nikhil201...@gmail.comwrote: Hi Maries

Re: $$Excel-Macros$$ Re: Quarter Classification

2012-04-15 Thread Nikhil Shah
Hi Hasseb, Now answer is right , i.e. Date 01/05/2010 ( DD/MM/ ) Format , Currently it's showing Curr.Qtr = April ; Next Qtr = July ..it is ok After July , Now I want Next Qtr = October ; Next Qtr = January Nikhil On Sun, Apr 15, 2012 at 11:07 PM, Haseeb A

$$Excel-Macros$$ Quarter Classification

2012-04-14 Thread Nikhil Shah
) Quarter will be - October and the print will be January, April,July and october I am using Excel 2003. I do want any Macro , I want Only Formula Awaiting Reply Nikhil Shah -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ Quarter Classification

2012-04-14 Thread Nikhil Shah
Hi Maries, Thanks for solving my problem. Nikhil On Sat, Apr 14, 2012 at 6:15 PM, dguillett1 dguille...@gmail.com wrote: You need to provide a file. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Nikhil Shah nikhil201...@gmail.com *Sent:* Saturday

Re: $$Excel-Macros$$ Excel - Useful Web Links

2012-04-06 Thread Nikhil Shah
Dear Maries, Thanks for sending excel links , it will very useful to me.. Nikhil Shah On Sat, Apr 7, 2012 at 3:09 AM, Maries talk2mar...@gmail.com wrote: Dear Friends, I have accumulate the my collection for Excel. Please update, If you anything more. I hope these links are very useful

$$Excel-Macros$$ Re: Hi everyone,

2012-02-08 Thread hemal shah
HI following link will solve your issue http://ubitmenu.en.softonic.com/ Take care self and other Regards Hemal -- 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, Code

Re: $$Excel-Macros$$ Excel test file Basic Advance

2012-02-07 Thread Nikhil Shah
Hi Maries, Thanks..Excellent Tools.. Regards Nikhil Shah On Tue, Feb 7, 2012 at 4:08 PM, Maries talk2mar...@gmail.com wrote: *Find the attached Excel File * On Tue, Feb 7, 2012 at 11:43 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: PFA On Tue, Feb 7, 2012 at 12:42 PM, Amit

Re: $$Excel-Macros$$ sheet reference from cell

2012-02-03 Thread hemal shah
https://lh6.googleusercontent.com/-GIfFnIL63cw/TyujJI-qg1I/AaI/4g3EdOBK34Q/s1600/Photo-0433.jpg Thanks for your kind support and solutions. flower to you all,, made by me -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles.

Re: $$Excel-Macros$$ sheet reference from cell

2012-02-02 Thread hemal shah
=VLOOKUP(MAX('*EN8 BRIGHT DIA 28* '!$D$2:$D$11),Indirect(A2,!$D$1:$G$11),4,0) I dont want to EN8 Bright DIA 28. I just want to use cell reference instead . Thanks for your reply -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

$$Excel-Macros$$ Re: sheet reference from cell

2012-02-02 Thread hemal shah
#N/A ERROR... -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post

$$Excel-Macros$$ Re: sheet reference from cell

2012-02-02 Thread hemal shah
KINDLY USE MY ATTACHED FILE AND HELP ME OUT THIS... THANKS -- 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, Code Problem, and Need Advice will not get quick

$$Excel-Macros$$ Re: sheet reference from cell

2012-02-02 Thread hemal shah
# ref error... -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a

Re: $$Excel-Macros$$ return value with two look ups

2012-01-25 Thread hemal shah
thanks it is working.. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2)

$$Excel-Macros$$ return value with two look ups

2012-01-24 Thread hemal shah
hi all masters I have work on fifo in very simple way in excel. now in summary sheet i require , while i type GRN, i should get latest balance . I have attached file for your reference. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ return value with two look ups

2012-01-24 Thread hemal shah
Hi Sam Thanks for the solution but I want something different. Please see my attached file, which give you more idea regarding my query -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

Re: $$Excel-Macros$$ Formula correction needed in FD calculation

2012-01-21 Thread Nikhil Shah
Hi sam, Can you post in Excel 2003 ? ..I am using excel 2003 Regards Nikhil Shah On Sat, Jan 21, 2012 at 10:56 PM, Sam Mathai Chacko samde...@gmail.comwrote: =IFERROR(ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7=Months,(F7/12),IF(E7=Years,F7,F7/365))),2),) Regards, Sam Mathai Chacko On Sat

Re: $$Excel-Macros$$ convert numbers into words

2012-01-17 Thread Nikhil Shah
Dear Noorain Excellent Tips.. Thanks Nikhil Shah On Tue, Jan 17, 2012 at 6:45 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Updated Sheet On Tue, Jan 17, 2012 at 6:06 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Noorain It converts with Rupees and i want only for words E.g. I

Re: $$Excel-Macros$$ Help

2011-12-30 Thread Nikhil Shah
Hi Kris, you right..it is very complex with formula..I have to use Pivot table.itwill very easy.. Thanks Nikhil Shah On Fri, Dec 30, 2011 at 1:18 PM, Kris krishnak...@gmail.com wrote: Hi, With the help of a helper column, a Pivot table would do the trick. PFA. Kris -- FORUM RULES

Re: $$Excel-Macros$$ Help

2011-12-29 Thread Nikhil Shah
-macros@googlegroups.com] *On Behalf Of *Maries *Sent:* Dec/Thu/2011 12:14 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help ** ** Find the attachment On Wed, Dec 28, 2011 at 9:23 PM, Nikhil Shah nikhil201...@gmail.com wrote: Dear Friend

Re: $$Excel-Macros$$ Help

2011-12-29 Thread Nikhil Shah
] *On Behalf Of *Nikhil Shah *Sent:* Dec/Fri/2011 12:37 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help ** ** Dear Rajan ** ** Opps..Sorry..Answer is wrong.. ** ** Again I am sending fresh excel sheet.. ** ** Pl help ** ** Nikhil

$$Excel-Macros$$ Help

2011-12-28 Thread Nikhil Shah
Dear Friend, I want to find out Consecutive Negative Return (%) in Times Number Years : Answer is : 2 Times 2 Years Now i want EXCEL Formula..Pl help me .. *Year* *Return* *Year* *Return* 1980 28.86% 1996 4.24% 1981 49.56% 1997 13.31% 1982 3.56% 1998 -17.17% 1983 7.20%

$$Excel-Macros$$ Help

2011-12-28 Thread Nikhil Shah
Dear Friend, I want to find out Consecutive Negative Return (%) in Times Number Years : Answer is : 2 Times 2 Years Now i want EXCEL Formula..I am using EXCEL 2003 ..No VBA Code...Pl help me .. *Year* *Return* *Year* *Return* 1980 28.86% 1996 4.24% 1981 49.56% 1997 13.31%

Re: $$Excel-Macros$$ Help

2011-12-28 Thread Nikhil Shah
: What if three Consecutive year have negative % then what output you want..? ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Nikhil Shah *Sent:* Dec/Wed/2011 10:14 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Help

  1   2   3   >