Re: $$Excel-Macros$$ speedometer in excel

Hi , http://gautamg.wordpress.com/2013/03/30/creating-a-speedometer-in-excel/?goback=%2Egde_82527_member_227695807 On Tue, Apr 2, 2013 at 12:27 AM, vijayajith VA wrote: > Hi, > > You can try below link/ > > http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Speedo

Re: $$Excel-Macros$$ speedometer in excel

Hi, You can try below link/ http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Speedometer_Chart.htm On Tue, Apr 2, 2013 at 12:22 AM, Midhun Thampan wrote: > hi anyone have an idea of how to use a sppeometer in excel. > kindly provide me some details and how to use in excel. > > > -- >

Re: $$Excel-Macros$$ What is Ylookup in Excel...

he environment. Please don't print this e-mail unless > you really need to.* > > On Sat, Feb 16, 2013 at 12:48 PM, vijayajith VA > wrote: > >> Hi Kuldeep, >> >> Where did you got ths information. pls share. i dont have idea. >> >> Thr is no

Re: $$Excel-Macros$$ What is Ylookup in Excel...

Hi Kuldeep, Where did you got ths information. pls share. i dont have idea. Thr is no Ylookup in excel..thanks On Sat, Feb 16, 2013 at 12:00 PM, Kuldeep Singh wrote: > > Hi Experts, > > What is *Ylookup in Excel*. I know only Vlookup, Hlookup & Lookup. If you > know,

Re: $$Excel-Macros$$ Query

Hi Chauan, Use ths UDF.. Function RevStr(Rng As Range) RevStr = StrReverse(Rng.Text) End Function On Fri, Feb 15, 2013 at 4:23 PM, neeraj chauhan wrote: > Dear Experts, > > kindly find the attached sheet and send the formula in excel for reverse > value > > -- > Are you =EXP(E:RT) or =NOT(EXP(E

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

> Pooja > Sent from BlackBerry® on Airtel > ------ > *From: * vijayajith VA > *Sender: * excel-macros@googlegroups.com > *Date: *Fri, 15 Feb 2013 15:08:39 +0530 > *To: * > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ Query collation of dat

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

Hi =IFERROR(VLOOKUP(A2,'Cost Center1'!$A$2:$A$21,1,0)," ") .if you want blank in place of N/A On Fri, Feb 15, 2013 at 2:20 PM, 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 > upda

Re: $$Excel-Macros$$ VBA Code for Home tab

Hi, Right click on Home Image. Click on Assign macro .. Sheets("Home").select... end sub same thing for exit & arrows.. On Sat, Feb 9, 2013 at 1:00 PM, amar takale wrote: > Dear All Champs, > I want to VBA Code for Home tab & I put detail in attached sheet > > Amar > > -- > Are

Re: $$Excel-Macros$$ Match a Word in a cell using Macros

HI Santhuash, =IFERROR(IF(FIND(" ",A2)-1 > 1,VLOOKUP(LEFT(A2,FIND(" ",A2)-1)&"*",Database!A:A,1,0),""),"") Try this. hope it helps you, Thanks On Wed, Feb 6, 2013 at 7:39 PM, Santhosh Kumar M K wrote: > Hi Friends, > > Need a help to create macro in a "Data" tab where it can recongnize a word

Re: $$Excel-Macros$$ Match a Word in a cell using Macros

Hi, Instead of Macro, you can try using match or search function. , On Wed, Feb 6, 2013 at 7:39 PM, Santhosh Kumar M K wrote: > Hi Friends, > > Need a help to create macro in a "Data" tab where it can recongnize a word > either by first/middle/last name if not with full name. > > for ex - "SHANG

Re: $$Excel-Macros$$ Macro - To split each spreadsheets as a new workbook

Hi Sandhosh. Sub Splitsht() ChDir "C:\Documents and Settings\user\Desktop\folder" Dim wrksht As Worksheet For Each wrksht In ThisWorkbook.Worksheets wrksht.Select wrksht.Copy ActiveWorkbook.SaveAs Filename:=wrksht.Name & ".xlsx" ActiveWindow.Close Next End Sub Thanks

Re: $$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

xample File.Pls see it.I used Excel 2003. > I thinking VBA code is making as I change table range only & paste it > word (with formatting) bcos if I used it diffrent table in Excel. > Regards > Amar > > On Sat, Jan 19, 2013 at 11:39 AM, vijayajith VA > wrote: > >

Re: $$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

Chage yourworksheet name .. as per your worksheet On Sat, Jan 19, 2013 at 11:38 AM, vijayajith VA wrote: > HI Amar, > use below code..or Could you just share your workbook.. > > Sub method1() > Application.ScreenUpdating = False > Application.Calculation = xlCalculationMa

Re: $$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

HI Amar, use below code..or Could you just share your workbook.. Sub method1() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Dim wb As Workbook Dim ws As Worksheet Set wb = ThisWorkbook Set ws = wb.Worksheets("Feuil") Dim rng As Range Dim wdApp As New Word.A

Re: $$Excel-Macros$$ Formula

For text use inverted commas.. On Sat, Jan 12, 2013 at 2:36 PM, Shiva Prasad wrote: > dear vijay, > > this is wrong if b2=na (b2-a2)=value recived on eroor ineed that one also > > > On Sat, Jan 12, 2013 at 2:00 PM, vijayajith VA wrote: > >> Hi Shiva, >> >>

Re: $$Excel-Macros$$ Formula

Hi Shiva, Use below forumula. Just change numbers how ever you want,,, =IF(C2=1,"Tat Complete ",IF(C2=5,"Above Tat",IF(C2=2," In Progress not completed",IF(C2=7,"Above tat in progess,not complete",IF(C2=0,"NA") On Sat, Jan 12, 2013 at 12:02 PM, Shiva Prasad wrote: > > Dear Champs, > > plea

Re: $$Excel-Macros$$ Need a Macros to Split spreadsheets

:="Account Reciveable " & wrksht.Name & ".xlsx" ActiveWindow.Close Next End Sub Thanks Regards. Vijay M On Wed, Nov 28, 2012 at 7:27 PM, vijayajith VA wrote: > Hi santhosa, > > Press Alt +11 > Use below --code.. > > Change accordingly.. > Sub

Re: $$Excel-Macros$$ Need a Macros to Split spreadsheets

Hi santhosa, Press Alt +11 Use below --code.. Change accordingly.. Sub Macro1() ChDir "Your Path" Dim wrksht As Worksheet For Each wrksht In ThisWorkbook.Worksheets wrksht.Select wrksht.Copy ActiveWorkbook.SaveAs Filename:= "your path" & wrksht.Name & ".xlsx" ActiveWindow.C

Re: $$Excel-Macros$$ Formula Quiz

Hi Rajan, I have question here.. Just wanted to know..what is the use of ROW(A1) A2 a3..etc etcc... HERE.. =IFERROR(IFERROR(INDEX($C$2:$J$2,0,ROW(A1)),INDEX($C$3:$J$3,0,ROW(A1)-COUNTA($C$2:$J$2))),INDEX($C$4:$J$4,0,ROW(A1)-COUNTA($C$2:$J$3))) On Fri, Nov 23, 2012 at 11:53 PM, >>Excel Begin

Re: $$Excel-Macros$$ discussexcel formula quiz 1

done On Sat, Nov 10, 2012 at 12:43 PM, Pravin Gunjal wrote: > Done. > > On Sat, Nov 10, 2012 at 11:40 AM, Ayush Jain wrote: > >> Dear group, >> >> I have created a small formula quiz to test your formula knowledge. This >> quiz has 10 questions related to excel formulas only. >> Formula quiz

Re: $$Excel-Macros$$ Number to Text

hi Sujit, I think you are trying to use ..UDF .First check the program in module ..its written or not... Thanks On Sat, Sep 8, 2012 at 3:27 PM, wrote: > Dear Excel Gurus, > > Greetings!!! > > Can you pls tell me know how to convert numbers to text ? Eg: '23' to > 'Twenty Three'. > > I tri

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Congrats noorain Brother.. On Sun, Sep 2, 2012 at 11:22 AM, rao wrote: > Congrats, u are the live wire of this group.please do continue the same. > > Cheers, > Prabhakar > > > On Sun, Sep 2, 2012 at 10:44 AM, wrote: > >> ** >> Congrats Noorain.. >> >> Rgds >> Vaibhav >>

Re: $$Excel-Macros$$ Need help

Hi Noorain, Isna(vlookup) On Fri, Aug 31, 2012 at 1:16 PM, NOORAIN ANSARI wrote: > Dear Group, > > If any have more example except it please share, we have to make it for 50 > types. > > Please share if any one have examples... > > > > On Fri, Aug 31, 2012 at 1:07 PM,

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Hi Zibrean,, Please use below formula =TRIM(RIGHT(SUBSTITUTE(LEFT(A4,FIND(" ",A4&" ",FIND("@",A4))-1)," ",REPT(" ",99)),99)) On Tue, Aug 28, 2012 at 2:50 PM, Zibraan wrote: > > Hi Team, > > I am looking for a formula to separate Company's name and email address > from IDs. > > Please refer the

Re: $$Excel-Macros$$ VBA Code

t; If you attach a file (good) then fully explain with examples > If you want a macro send a macro enabled file (xlsM) > > You don’t say how you want your macro to fire. Why not just filter > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gma

$$Excel-Macros$$ VBA Code

Hi all, Please help me on attached file. Thanks -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formu

Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet

hi, Try below Ashish code... Sub m() Dim i, j, k, s As Long s = Sheets.Count For i = 1 To s Sheets(i).Select 'change upper row here in this case it will start copying from second row j = 2 ' it will copy till last used row automatically k = ActiveSheet.UsedRange.Rows.Count Rows(j & ":" & k).Cop

Re: $$Excel-Macros$$ Re: Cell show blank but in it show formula

HI Prince,,, To avoid 0 s & na please use below formula =IF(VLOOKUP(F4,B4:D9,2,0)=0,"",VLOOKUP(F4,B4:D9,2,0)) On Thu, Aug 16, 2012 at 10:52 PM, Prince Dubey wrote: > Please see the attachment > > > regards > prince > > On Thursday, August 16, 2012 3:39:08 PM UTC+5:30, amar takale wrote: >> >> >

Re: $$Excel-Macros$$ Hightlight the text for day Fridays only.....

vbCyan End If Next cell End Sub On Wed, Aug 15, 2012 at 12:07 PM, vijayajith VA wrote: > HI Muneer,,, > > I think Few days back noorain & rajan had answered for same questions > > > On Wed, Aug 15, 2012 at 11:28 AM, Mohammed Muneer wrote: > >> ** >> Dear G

Re: $$Excel-Macros$$ Hightlight the text for day Fridays only.....

HI Muneer,,, I think Few days back noorain & rajan had answered for same questions On Wed, Aug 15, 2012 at 11:28 AM, Mohammed Muneer wrote: > ** > Dear Group, > > Please highlight the text in column B based on Friday. > > > Regards, > Muneer, > CC > > -- > Join official facebook page of thi

Re: $$Excel-Macros$$ query for finding maximum and minimum values

Hi kenil, Pls change accordg to your data. =MAX(IF(B1:B7>0,B1:B7)) =MIN(IF(A1:A7>0,A1:A7)) On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala wrote: > hi all, > > i have a query for finding maximum and minimum values. > i have written my query in the excel sheet attached. pls help me solve my > query

Re: $$Excel-Macros$$ regarding public const

StrAppName as string =”MyApplication”* > > * * > > *It means strAppName would be available to entire VBProject and its value > can’t be changed. * > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* exc

Re: $$Excel-Macros$$ Help for formula (which formula give me exact numbers when I change month)

Hi ,, Use Ctrl Shift enter for Priti_Verma s formula... Thanks On Sat, Aug 4, 2012 at 1:17 PM, amar takale wrote: > Pls help me all experts.I attached file. > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like P

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

Congratulations Noorain bayya!! On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain wrote: > Dear members, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > July'12. He has posted 143 posts in July 2012 and helped many forum members > through his excel expertise. >

Re: $$Excel-Macros$$ How to calculate Days and Time.

Please ignore.. showing wrong answer On Wed, Aug 1, 2012 at 11:15 AM, vijayajith VA wrote: > Hi kumar, > > Try this.. > > =DATEDIF(A3,E3,"md") > =TEXT(B3+F3,"[HH]:MM") > > > On Tue, Jul 31, 2012 at 11:48 PM, xlstime wrote: > >> PFA THE A

Re: $$Excel-Macros$$ How to calculate Days and Time.

Hi kumar, Try this.. =DATEDIF(A3,E3,"md") =TEXT(B3+F3,"[HH]:MM") On Tue, Jul 31, 2012 at 11:48 PM, xlstime wrote: > PFA THE ATTACHED MAY BE SOLUTION > > > > On Tue, Jul 31, 2012 at 11:35 PM, Ashish kumar > wrote: > >> Dear Champs, >> >> I need to consider the time difference between both the

$$Excel-Macros$$ regarding public const

Hi Gurus, Please could you explain what is the use of Public & public const in vba macros. could you provide me one simple example... Thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Ne

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

CongratsASHISH *DILIP... On Mon, Jul 2, 2012 at 9:18 PM, wrote: > ** > Congratulation Ashish and Dilip. > > Sandeep Chhajer. > Sent on my BlackBerry® from Vodafone > -- > *From: * Sam Mathai Chacko > *Sender: * excel-macros@googlegroups.com > *Date: *Mon,

Re: $$Excel-Macros$$ How to add combo box in a sheet.....Need Help.....

Ban Her. On Fri, Jun 8, 2012 at 5:13 PM, Mangesh Dayne wrote: > Such people should be ban for lifetime from this group. And I request you > to please do needful. > > Thanks. > > > Mangesh > > > On Fri, Jun 8, 2012 at 5:08 PM, NOORAIN ANSARI > wrote: > >> Dear Ayush, >> >> Please ban belo

Re: $$Excel-Macros$$ Lookup Item No. from Stock.xls in Order.xls

hanks. > But it is showing "Yes" for Blanks also. > I wish to show Blank for Blanks. > > On Saturday, June 2, 2012 12:12:39 PM UTC+4, vijayajith VA wrote: > >> Hi Rashid >> As you requested.. Please find ...attached file...Thanks >> >> >> On Sat,

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

Congrats ..Rajan ... On Mon, Jun 4, 2012 at 9:00 AM, Lalit_Mohan wrote: > Congratulation Rajanonce again you rock... > > Regards, > Lalit Mohan > > On Sunday, 3 June 2012 23:12:31 UTC+5:30, Ayush Jain wrote: > >> Hello Everyone, >> >> Rajan Verma has been selected as '

$$Excel-Macros$$ test Mail //

-- 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 question in the thre

Re: $$Excel-Macros$$ Multiple Challenging Excel Needs...

HI.. Please share sample file.. Thnks On Fri, Jun 1, 2012 at 2:12 AM, Dan Brimley wrote: > I have been asked to help with a bunch of Excel functions and programming. > There are a few that are beyond my level. I didn't come up with these > ideas, just trying to help the person who did, so the

Re: $$Excel-Macros$$ Dynamic Worksheet Reference

Hi ... Please attach sample file. Thanks On Sat, Jun 2, 2012 at 1:02 AM, Babak H wrote: > Hello, > > I am new to this group and I am unsure if this topic was covered in the > past so I apologize in advance. > > *Problem*: I have external worksheets that i get on a montly basis > (Naming co

Re: $$Excel-Macros$$ doubt

as in the > attached file. > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* vijayajith VA > *Sent:* Saturday, May 26, 2012 5:44 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ doubt > > Hi al

Re: $$Excel-Macros$$ doubt

; *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *vijayajith VA > *Sent:* 26 May 2012 4:15 > *To:* excel-macros@googlegroups.com > *Subjec

$$Excel-Macros$$ doubt

Hi all, Please find the attached query..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 attention or may not be

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

Hi Try ths =VLOOKUP(E3,Sheet1!E3:G20,3,FALSE) On Wed, May 23, 2012 at 5:16 PM, Amit Gandhi wrote: > Hi Experts >> >> >> VLOOKUP is not working in attached file, can anyone help me why its not >> working and what will be right formula? >> >> Pls help me here. >> >> Regards >> >> Amit >> >> -- >>

$$Excel-Macros$$ Name Manager

Hi, I want to know about Name Manager.. .. what is the use of Name manager.how to use it.. Can any one explain me with examples...or any nice links ..Thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please H

Re: $$Excel-Macros$$ Getting last column value via Vlookup in excel

Please share sample sheet On Fri, May 11, 2012 at 5:45 PM, Shekhar Sharma wrote: > Hey guys, > First of all thanks so much for helping me with resolutions. > > I have two sheets within an excel spreadsheet and I need to lookup a name > from the first sheet and pull data through from the second sh

Re: $$Excel-Macros$$ Running text in excel

Hi Loki Please try below..code try to edit.. how you want... ---(code is From Rajan verma) Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Sub Start() Dim St As String Dim Cell As Range Set Cell = Range("L5") St = Cell.Value St = Trim(St) St = St & "

Re: $$Excel-Macros$$ Re: pls help for dis

Please share your sample sheet.. Thanks On Tue, May 8, 2012 at 8:59 AM, rohit patel wrote: > > > On Thu, Apr 16, 2009 at 10:46 AM, rohit patel wrote: > >> i just want to link dis 1 sheet (Vendor April .09 demo) to Receiving >> status(supplier)mar.09 demo, i just want dat if we entered the data

Re: $$Excel-Macros$$ Office stock consumption - formula needed to solve the attached.

HI Please try below one =IFERROR(VLOOKUP(D2,'Utilization and Closing stock'!A2:C19,3,FALSE)," ") On Sun, May 6, 2012 at 2:38 PM, Smitha S R wrote: > > On Sun, May 6, 2012 at 2:37 PM, Smitha S R wrote: > >> Hi, >> >> >> >> Any one please help: >> >> >> >> PFA the attachment of office stock.

Re: $$Excel-Macros$$ c++ developer

Are you in bangalore ... On Sat, Apr 21, 2012 at 8:18 PM, Airen wrote: > Hi All, > > I am planning to build a forecasting & network optimization product. > Currently I am working in a company & this is my personal part time > project. Any one interested in this project can contact me. Currently,

$$Excel-Macros$$ Control c & v

HI All, Is thr any other short cut key for COPY & Paste (except ctrl c & v).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

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

DON ROCKS...!CONGRATS. On Sat, Apr 14, 2012 at 2:06 PM, Ayush Jain wrote: > Dear members, > > Don Guillett has been selected as 'Most Helpful Member' for the month of > March'12 > He has been helping forum members from long time consistently and we are > proud to have him

Re: $$Excel-Macros$$ need excel dyanmic web query macro

HI asa,, Nice links thanks Is this possible to record macro --webquery..." http://www.techrepublic.com/article/pull-data-into-microsoft-excel-with-web-queries/6115870 " On Sat, Apr 7, 2012 at 2:21 AM, Asa Rossoff wrote: > I get some kind of SQL server error from that tracking URL (perhaps > be

Re: $$Excel-Macros$$ Access..

o: > excel-macros@googlegroups.com] *On Behalf Of *vijayajith VA > *Sent:* Apr/Sun/2012 06:23 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Access.. > > ** ** > > Hi All, > > ** ** > > Can you provide me MS ACCESS. LINKS(WEBSITES).Thank

Re: $$Excel-Macros$$ Order by Rank

Hi Can yu pls attached sample worksheet ? On Sat, Apr 7, 2012 at 10:55 PM, wrote: > Hi, > > I want to reorder products by rank in a particular order. It works fine > when the rank is unique. But when there are two products of same rank then > it does not. Please help. > > I reorder using index

$$Excel-Macros$$ add in

Hi All.. I have created few macros.i need to add it in Add in...Can you please tell me how to do it ? 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 Pro

Re: $$Excel-Macros$$ to remove time

mycell.Value = VBA.Left(mycell, VBA.InStr(1, mycell, " ") - 1) > Selection.NumberFormat = "m/d/" > endif > Next > End Sub > > > > > > On Thu, Apr 5, 2012 at 9:24 PM, vijayajith VA wrote: > >> Hi , >> >> 12/2/2001 1

$$Excel-Macros$$ to remove time

Hi , 12/2/2001 12:00 PM --- How to remove time ? i need only date .. is thr any formula ..Thanks in advance -- 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$$ Need assistance in finding formula to substitute the values to dates.

awesome !! Great !!!11 On Wed, Apr 4, 2012 at 10:20 AM, Maries wrote: > Hi, > > PFA. Use below Array formula, > > > =IFERROR(INDEX($B$4:$E$4,MATCH(B$9,OFFSET($A$4,MATCH($A10,$A$5:$A$7,0),1,1,4),0)),"") > > Regards, > > MARIES. > > On Wed, Apr 4, 2012 at 7:16 AM, rekha siri wrote: > >> Hi I

Re: $$Excel-Macros$$ Inserting blank row

Hi Cayne, Sub rowinsertcola() Dim i, j, k, z, h As Long j = 1 z = 1 Range("a65356").Select Selection.End(xlUp).Select k = ActiveCell.Row For i = 5 To k + z Step 1 If (i Mod j = 0) Then ActiveSheet.Cells(i + z, 1).Select Selection.EntireRow.Insert z = z + 1 End

Re: $$Excel-Macros$$ help

Cells(i, 1) = Cells(1, 1) Then Rows(i).Delete > Next i > End Sub > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* vijayajith VA > *Sent:* Friday, March 02, 2012 12:44 AM > *To:* excel-macros@googlegroups.com > *S

Re: $$Excel-Macros$$ help

t, Mar 31, 2012 at 11:11 PM, vijayajith VA > wrote: > >> >> Thanks sam >> >> means same range suppose a1(blank cell) will search for a1 in other >> workbook & get filled rite... >> >> >> On Sat, Mar 31, 2012 at 10:43 PM, Sam Math

Re: $$Excel-Macros$$ help

ds, > Sam Mathai Chacko > > > On Sat, Mar 31, 2012 at 10:38 PM, vijayajith VA > wrote: > >> Hi, >> >> Set sourcerange = Columns("D").SpecialCells(xlCellTypeBlanks) >> >> Can any one explain above code? >> what does it mean? >> &

Re: $$Excel-Macros$$ Create range and select it

HI , Can you pls attach sample file..& send it to us..Thanks On Fri, Mar 16, 2012 at 11:21 PM, Brian wrote: > I am using Excel 2007 > Depending on the squad number I select in a worksheet I have set up some > formulas so I can find the reference for the first cell and last cell in > the range

Re: $$Excel-Macros$$ need help for automatic email

HI ranjan, go to tools in vb editor.. in reference select microsoft outlook options...& run the program it works fine Thanks... On Thu, Mar 15, 2012 at 4:54 PM, Deba Ranjan wrote: > * > * > Dear Expert, > > Please help to create a programing such that the attached file > automatically

Re: $$Excel-Macros$$ need VBA Code plz help

HI Hamed, Attachment is missing... On Sun, Mar 11, 2012 at 12:43 PM, Gulam Hameed wrote: > Dear Noorain & experts > > ** ** > > I want make invoice in easy & shortcut method like eg: order number 8241 > 2012, it has 12 items codes, Description, Price Qty & Total Amount, > > I need so

Re: $$Excel-Macros$$ Help: VBA code for RGB values

HI Don, is this possible in pivot table ? .. i have three columns..a b & c. a & b --having some order nos..& invoice no & C is date..--todays, toms & earilier date.. if its earlier date -order nos & invo no.. should changeto red.. todays date - blue & toms date --green colr.. order

Re: $$Excel-Macros$$ modification in paste special macro.

i think... its not possible... On Wed, Mar 7, 2012 at 10:11 AM, danial mansoor wrote: > i used this macro and assigned it a shortcut key for my conveniance for > paste special values,but i can not undo last actions is that possible to > undo last 2 actions after modification of this posible? > >

Re: $$Excel-Macros$$ loop through cell

Hi learn excel.. Please send it with attachment.. it will be helpful.Thanks/// On Wed, Mar 7, 2012 at 8:16 AM, LearnExcel wrote: > help with code > > > Dim ws As Worksheet > > can someone tell me why the follwowing code wont work > > > >For Each ws In ThisWorkbook.Worksheets >If

Re: $$Excel-Macros$$ help

hi shaik. Sorry. i need code for ths.. On Fri, Mar 2, 2012 at 12:38 PM, vijayajith VA wrote: > Hi Sahik,, > > Sorry ..i need required code for ths .. Thanks'' > > > On Fri, Mar 2, 2012 at 12:35 PM, Shaik Waheed wrote: > >> Hi, >> PFA solved, hope th

Re: $$Excel-Macros$$ help

t click OK. > > On Fri, Mar 2, 2012 at 12:14 PM, vijayajith VA wrote: > >> Hi >> >> >> >> Please find the attached query/// >> >> >> Thanks >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >>

$$Excel-Macros$$ help

Hi Please find the attached query/// 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 attention or may not be

Re: $$Excel-Macros$$ I Macros tutorial & software need

Hi, Is thr good future in learning Imacros? Thanks On Fri, Feb 17, 2012 at 11:12 PM, xlstime wrote: > Hi Amit, > > iMacros is the *only* software that can *automate both Internet Explorer > and Firefox.* You can control both web browsers directly from Excel.*iMacros > works with every website

Re: $$Excel-Macros$$ Thanks in advance

oo get refreshed.* > > > On Sat, Feb 11, 2012 at 9:41 AM, vijayajith VA wrote: > >> Hi >> >> >> Question asked in interview >> >> i have nearly 30 pivot tablein 30 sheets i need to enter >> data in master sheetat a time i need to

$$Excel-Macros$$ Thanks in advance

Hi Question asked in interview i have nearly 30 pivot tablein 30 sheets i need to enter data in master sheetat a time i need to refresh alll the pivot table... how to link the pivot table... Please help me.i dont have any workbook.. question asked in intervth

Re: $$Excel-Macros$$ Load Excel Files

Hi ,, Please share your workbook.Thanks On Sat, Feb 11, 2012 at 2:15 AM, Mayank wrote: > Team, > > I have master file having 10 sheets. > 1st sheet having summarize data (populated using formulas) of other 9 > sheets and these 9 sheets contains data from 6 different files (3 > files having tw

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congrats Noorain,.. On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Jan'12 > He has posted 175 posts in Jan'12 and helped many people through his > expertise. He has been consistent contributor

Re: $$Excel-Macros$$ paste special problem

Hi mansoor, sub tex() selection.value = selection.value end sub On Fri, Feb 3, 2012 at 9:08 PM, danial mansoor wrote: > i have a big file with many sheets i want to convert formula in values,if > i do individually it will take lotes of time can any one tell me the macro > which will work? > >

Re: $$Excel-Macros$$ help

nd(z) + 1 To UBound(z) > rs = rs & Left(z(i), InStr(z(i), ")") - 1) & " " > Next i > extract_words = Application.WorksheetFunction.Trim(rs) > End Function > > > See attached sheet > > > On Fri, Feb 3, 2012 at 10:34 PM, vijayajith VA wrote: >

Re: $$Excel-Macros$$ help

Hi Noorain, Please find the attached sheet. Thanks On Fri, Feb 3, 2012 at 10:30 PM, vijayajith VA wrote: > Hi Noorain ansari, > > Data will be floo see r eree s seer(A23),seruo serereserrser seeess > kke(A89 ) =I need ans answer as A23,A89 > > but if i use your formula i a

Re: $$Excel-Macros$$ help

om/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > -- Forwarded message -- > From: vijayajith VA > Date: Sun, Dec 25, 2011 at 3:01 PM > Subject: $$Excel-Macros$$ help > To: excel-macros@googlegroups.co

$$Excel-Macros$$ help

Hello sir, Just i want to know about use relative reference in vb developer tab.? What is use of that ? Thanks in advance ' -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pro

$$Excel-Macros$$ help

Hi Gurus, Please find the attached querY Thanks in adv. -- 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

Re: $$Excel-Macros$$ help

seeess kke(A25) =A89,A25 On Sun, Dec 25, 2011 at 4:18 PM, vijayajith VA wrote: Thanks HI Rajan, > > > I need only A23,A89 --for 1st one >S89 for second one > > Thanks > > > On Sun, Dec 25, 2011 at 3:08 PM, Rajan_Verma wrote: &g

Re: $$Excel-Macros$$ help

HI Rajan, I need only A23,A89 --for 1st one S89 for second one Thanks On Sun, Dec 25, 2011 at 3:08 PM, Rajan_Verma wrote: > What will be your output? > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf

$$Excel-Macros$$ help

Hi , i have some data like 1) floo see r eree s seer(A23),seruo serereserrser seeess kke(A89) 2) folow re e ser se ser(S89) I want to extract only nos inside the bracket please suggest me for some formula or code Thanks -- FORUM RULES (934+ members already BAN

Re: $$Excel-Macros$$ about getpivotdata

HI Van, Thanks for your info.Can you give some examples with attached file. Thanks On Sun, Dec 25, 2011 at 1:17 AM, Bé Trần Văn wrote: > > > 2011/12/25 vijayajith VA > >> Hello sir, >> >> Please i want to know about getpivotdata . can you give m

$$Excel-Macros$$ about getpivotdata

Hello sir, Please i want to know about getpivotdata . can you give me some examples.? Thanks -- FORUM RULES (934+ 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 Advi

Re: $$Excel-Macros$$ shortcut key .

Sorry . that is for put filter and remove filter.i need to clear checked items .in filtered coloumn. On Sun, Dec 18, 2011 at 12:10 PM, Ms-Exl-Learner . wrote: > Alt+D+F+F > > --- > Ms.Exl.Learner > --- > > > On Sun, Dec 18, 2011

Re: $$Excel-Macros$$ shortcut key .

> Try this: > > http://dmcritchie.mvps.org/excel/shortx2k.htm > > Cheers, > andy > > On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA > wrote: > >> Hello sir >> >> Can you tell me what is shortcut key for data clear(filter)? >> >> >> T

$$Excel-Macros$$ shortcut key .

Hello sir Can you tell me what is shortcut key for data clear(filter)? Thanks -- FORUM RULES (934+ 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 ge

Re: $$Excel-Macros$$ regarding addins in vba

s/ExcelAdd-insPage.htm >> >> -- >> Thanks & regards, >> Noorain Ansari >> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> >> >> On

$$Excel-Macros$$ regarding addins in vba

Hello sir, Please i want to know about Add ins .Can you give me some examples? Thanks -- FORUM RULES (934+ 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 wil

Re: $$Excel-Macros$$ recording macros

oorain Ansari > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > > On Sat, Dec 3, 2011 at 9:32 AM, vijayajith VA wrote: > >> Hi >> >> I have two

Re: $$Excel-Macros$$ recording macros

. Data Range at worksheet will > change.. > > You can write a macro for this purpose..by using conditional Formatting.. > > On Sat, Dec 3, 2011 at 9:32 AM, vijayajith VA wrote: > >> Hi >> >> I have two workbooks.sheet1 and sheet2. I want to find duplicates data &g

$$Excel-Macros$$ recording macros

Hi I have two workbooks.sheet1 and sheet2. I want to find duplicates data from sheet1 to sheet2.Is this possible to record a macro.for this? Thanks -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

  1   2   >