RE: $$Excel-Macros$$ Help with formula in vba

2013-12-07 Thread gargee singh
x27;C:\Users\User\Desktop\Reports\[Reason Codes.xlsx]Rail'!$A$1:$B$62,2,FALSE))" Thanks and Regards, Gargee Singh From: garge...@hotmail.com To: excel-macros@googlegroups.com CC: quote.ex...@gmail.com Subject: RE: $$Excel-Macros$$ Help with formula in vba Date: Sat, 7 Dec 2013 15

RE: $$Excel-Macros$$ Help with formula in vba

2013-12-07 Thread gargee singh
Hi Ravinder, thanks a lot, yes this is very helpful. exactly what i needed . :) Thanks and Regards, Gargee Singh From: ravinderexcelgr...@gmail.com To: excel-macros@googlegroups.com CC: quote.ex...@gmail.com Subject: RE: $$Excel-Macros$$ Help with formula in vba Date: Sat, 7 Dec 2013 12

Re: $$Excel-Macros$$ Help with Formula Destination

2012-08-09 Thread Prince Dubey
Thanks Sam , it is useful for me also. prince On Monday, August 6, 2012 10:08:09 PM UTC+5:30, Sam Mathai Chacko wrote: > > =HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1) > > Regards > > Sam Mathai Chacko > > On Mon, Aug 6, 2012 at 9:41 PM, ashish koul > > wrote: > >> =HYPERLINK("#'"&SUBSTITU

Re: $$Excel-Macros$$ Help with Formula Destination

2012-08-09 Thread Ashish Pradhan
Dear Kantilal, Sam & Ashish All your options work and are helpful. Appreciate your help and thanks a lot (Couldn't respond earlier as I was away) Thanks Ashish Pradhan On 07-08-2012 10:56, Kantilal Badale wrote: Try CTRL+[ ] from formula cell CA Kantilal Badale E-Hall, First Floor, B. J. M

Re: $$Excel-Macros$$ Help with Formula Destination

2012-08-07 Thread dguillett1
r(.Formula, "!") + 1, 256) Application.Goto reference:=Sheets(ms).Range(mc) End With End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kantilal Badale Sent: Tuesday, August 07, 2012 12:26 AM To: excel-macros@googlegroups.com Subject: Re: $$Exce

Re: $$Excel-Macros$$ Help with Formula Destination

2012-08-06 Thread Kantilal Badale
Try CTRL+[ ] from formula cell CA Kantilal Badale E-Hall, First Floor, B. J. Market, Jalgaon.(Maharashtra) 9822250393 On Mon, Aug 6, 2012 at 10:08 PM, Sam Mathai Chacko wrote: > =HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1) > > Regards > > Sam Mathai Chacko > > > On Mon, Aug 6, 2012 at

Re: $$Excel-Macros$$ Help with Formula Destination

2012-08-06 Thread Sam Mathai Chacko
=HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1) Regards Sam Mathai Chacko On Mon, Aug 6, 2012 at 9:41 PM, ashish koul wrote: > =HYPERLINK("#'"&SUBSTITUTE(CELL("address",Sheet2!A3),"!","'!"),Sheet2!A3) > > > > > On Mon, Aug 6, 2012 at 7:09 PM, Ashish Pradhan wrote: > >> >> Hello >> >> I hav

Re: $$Excel-Macros$$ Help with Formula Destination

2012-08-06 Thread ashish koul
=HYPERLINK("#'"&SUBSTITUTE(CELL("address",Sheet2!A3),"!","'!"),Sheet2!A3) On Mon, Aug 6, 2012 at 7:09 PM, Ashish Pradhan wrote: > > Hello > > I have many cells with formulae in them in Sheet "Main" > > For Example: > > ='Staff Bonus'!E67 > > Is there a simpler way to go to the Sheet "Staff Bon

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

2011-08-20 Thread dguillett1
A simple vlookup formula such as this to lookup the item in the IS sheet when you know the column should do it. You can then use edit/replace to change the formulas. A one click macro could do it all. =VLOOKUP(J9,'2011 Actual'!B2:AG331,10,0) From: Steve Weaver Sent: Friday, August 19,

Re: RE: RE: $$Excel-Macros$$ Help with formula

2011-07-11 Thread Bob
oops sorry, 291log -- -- 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://www.linkedin.com/groups?gid=1871

RE: RE: $$Excel-Macros$$ Help with formula

2011-07-11 Thread Daniel
Can you mail the sheet password back ? De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Bob Envoyé : dimanche 10 juillet 2011 20:57 À : excel-macros@googlegroups.com Objet : Re: RE: $$Excel-Macros$$ Help with formula Here is the file. On the Quote

RE: $$Excel-Macros$$ Help with formula

2011-07-10 Thread Rajan_Verma
Please attached Some Data with More Specification.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bob Sent: Sunday, July 10, 2011 6:28 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help with formula =IF(A30="","",SUM(C3:C25)*ROUNDUP

RE: $$Excel-Macros$$ Help with formula

2011-05-03 Thread Dave Bonallack
Hi, One way to do it would be: -Find the last cell in your data (eg A1000) -Multiply that cell's row number by 2 (eg 2000) -Paste that cell's data into the cell with the doubled row number (eg A2000) -Clear that cell (ie A1000) -Decrement the row by 1 (ie A999) -Loop to step 2 Regards - Dave.