Re: $$Excel-Macros$$ Date format

C the att.       From: Lokesh Loki lokeshsmg2...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, June 4, 2012 6:48 PM Subject: $$Excel-Macros$$ Date format Hi Experts, I want to confirm the date format whether it is showing Indian date format or us

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

Congrats Rajan. :D On Mon, Jun 4, 2012 at 6:06 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Thank you all J ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of

Re: $$Excel-Macros$$ Need a Email Macro based on the Cell time

Experts, Can you have look on my requirements and provide the solution. On Mon, Jun 4, 2012 at 12:19 AM, Puttu * puttu...@gmail.com wrote: Hi Excel Experts, Need a help on the macro for automated email reminders. below is the requirements. Attached is sheet for your reference Need a

Re: $$Excel-Macros$$ Records found but unable to get proper result.

many many thanks ashish sir for helping me. i am also done it with the following formula =IFERROR(INDEX(Table1[SUBCODE],SMALL(IF(COURSES!$A$2:$A$804=LIST!$E$1,ROW(INDIRECT(1:803)),),ROW()-34)),) but sir your method is simpler than me now i am following your method. On Mon, Jun 4, 2012 at

Re: $$Excel-Macros$$ unhide all sheet

Hi, You can use the following code, i had been using this.. Sub unhide_sheets() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Visible = True Next ws End Sub On Tue, Jun 5, 2012 at 1:33 PM, jayendra gaurav jayendra.gau...@gmail.comwrote: Dear Team, I required your

Re: $$Excel-Macros$$ Need a Email Macro based on the Cell time

Dear, I am not an expert, but see if the below page can give you some idea. Darwin 2012/6/5 Puttu * puttu...@gmail.com Experts, Can you have look on my requirements and provide the solution. On Mon, Jun 4, 2012 at 12:19 AM, Puttu * puttu...@gmail.com wrote: Hi Excel Experts, Need a

Re: $$Excel-Macros$$ Need a Email Macro based on the Cell time

http://www.teachexcel.com/excel-help/excel-how-to.php?i=447580#3 2012/6/5 Darwin Chan darwin.chankaw...@gmail.com Dear, I am not an expert, but see if the below page can give you some idea. Darwin 2012/6/5 Puttu * puttu...@gmail.com Experts, Can you have look on my requirements and

Re: $$Excel-Macros$$ Text Cleaning

Hi Asa, your code really works exact for me.Thanks for the help but can u please explain why you have done this Character As String * 1. On Monday, June 4, 2012 9:14:07 PM UTC+5:30, Asa R. wrote: I re-read your query and I see you only wanted alphabet characters. I had this include

Re: $$Excel-Macros$$ Text Cleaning

Hi david. that e was bymistake.I want to clean special characters spaces it's done by Asa's code. thanks for your concern. On Tuesday, June 5, 2012 6:11:41 AM UTC+5:30, David Grugeon wrote: Hi Sonal I hope you realise that if you apply any of the suggested solutions to your string

Re: $$Excel-Macros$$ Text Cleaning

Rajan...Thanks for the help but still your code is returning numbers . On Monday, June 4, 2012 9:11:22 PM UTC+5:30, Rajan_Verma wrote: Ah , *Cod* is just a integer type *variable* , that will hold the *ACSII Code* or each character in string, * * *Regards* *Rajan verma* *+91

RE: $$Excel-Macros$$ Text Cleaning

Hi Sonal, Sure -- String * length indicates a fixed-length string of length number of characters in length. I used it because the variable will always hold exactly one character, but the usual variable length string (declared as just String) would have worked too. Asa From:

$$Excel-Macros$$ Graph

Hi, Please help me in drawing the graph, as per the attachment. Need a graph , month wise where the employee growth, cost wise growth and team could be identified . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

$$Excel-Macros$$ delete my id from mailing list

Hi Please delete my name from mailing list for the time being. Thanx Ajay Tripathi -- 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

Re: $$Excel-Macros$$ delete my id from mailing list

*To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com* On Tue, Jun 5, 2012 at 4:04 AM, Ajay Tripathi tripathiaja...@gmail.comwrote: Hi Please delete my name from mailing list for the time being. Thanx Ajay Tripathi -- FORUM RULES (986+ members already

Re: $$Excel-Macros$$ Graph

Please help on the graph preparation On Tue, Jun 5, 2012 at 3:25 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, Please help me in drawing the graph, as per the attachment. Need a graph , month wise where the employee growth, cost wise growth and team could be identified . -- FORUM RULES

Re: $$Excel-Macros$$ Urgent help required for Vlookup macro code

May I ask why your request is more urgent and more important than the other requests.?? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Nagendra Modupalli Sent: Monday, June 04, 2012 11:30 PM To: excel-macros@googlegroups.com Subject:

RE: $$Excel-Macros$$ Graph with radio button

Hi, There are three Simple VBA Procedure to accomplish this task. I have created 3 name ranges in your sheet Team1,Team2 and Team3 then on Every Option Button Click Event I am assigning the Current Region of Corresponding Range to the Chart Source. Sub OptionButton1_Click()

Re: $$Excel-Macros$$ Need VBA to select and reassign moving XY chart data

This can probably be greatly simplified. Provide your excel version and the file. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: thatguy Sent: Monday, June 04, 2012 9:59 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need VBA to select and

RE: $$Excel-Macros$$ Creating a Chart with bubble on it

Can you please provide sample data also? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shishir Ranjan Sent: 05 June 2012 11:30 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$

RE: $$Excel-Macros$$ unhide all sheet

You need to hide your workbook , because you cannot hide all worksheets in your workbook ALT +W H to Hide ALT + W H U to Unhide Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shaik Waheed

RE: $$Excel-Macros$$ Graph

Hi Smith Every Chart needs related data, can you provide the data of Growth? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Smitha S R Sent: 05 June 2012 3:25 To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Creating a Chart with bubble on it

Hi Rajan, See below and attached. The first three are DOR (days of receivables) in days and second three are the amounts associated with these accounts. DOR in DaysInventory in m$ AccountWIPAR TotalWIPAR TotalABC5645101 6.517.524DEF 68351036.313.2 19.5GHI344579 3.44.57.9JKL

Re: $$Excel-Macros$$ Multiple excel sheets in merge in single excel sheet

You can use the vba DIR to open each file in the current folder and then copy the used range.offset(1) to the next available row in the consolidate file. If necessary, you can specify the files within an array Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From:

$$Excel-Macros$$ How to disable all macros initially when i open the workbook

Hi Friends, I am working with the file containing macros. I want all macros should be disable when i opened the file and should be enable when i click on command button in file. My intention is to stop executing the macro just after opening the file. It should be run only when i click on command

Re: $$Excel-Macros$$ Excel VBA Book?

Refer functionx.com/vbaexcel this will help Sandeep On Tue, Jun 5, 2012 at 7:12 AM, charlyRoot c...@jwsre.com wrote: I don't know VBA other than manipulating recorded macros. What is the quickest way to learn from foundation up? Book? Some pay site? It takes to long to go through

Re: $$Excel-Macros$$ Excel VBA Book?

PERFECT!! Thank you very much! I knew there was something out there I haven't found yet. On Tuesday, June 5, 2012 10:57:07 AM UTC-4, Sandeep Kumar Baranwal wrote: Refer functionx.com/vbaexcel this will help Sandeep On Tue, Jun 5, 2012 at 7:12 AM, charlyRoot wrote: I don't know VBA

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

Thanks Asa, Noorain and Vijayjith for your help. Works great. On Monday, June 4, 2012 5:59:40 PM UTC+4, vijayajith VA wrote: Hi ,, Then removie ..YES ..just give Thanks =IF(NOT(ISERROR(VLOOKUP(A7,'C:\Documents and Settings\user\My Documents\Downloads\New

$$Excel-Macros$$ extract data from table

Hi, I have a table and need to extract data that is non-zero. Attached is the sample file for your reference. Thanks, Joseph -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

$$Excel-Macros$$ Re: Need a Email Macro based on the Cell time

Hi Puttu, Please provide more details about your task such as the email client you want to use. I would suppose Outlook but you don't tell. How column F is completed? Do you manually changed the dates? What are the dates related to. You should provide more details, it's too vague to me and

$$Excel-Macros$$ Re: extract data from table

Hi, Is your table going to be the same? I mean the number of columns and rows going to be same?? On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph wrote: Hi, I have a table and need to extract data that is non-zero. Attached is the sample file for your reference. Thanks, Joseph

Re: $$Excel-Macros$$ Re: extract data from table

yes, the number of rows and columns will be the same, but the values in it may change. On Wed, Jun 6, 2012 at 1:10 AM, Vish vishwamitr...@gmail.com wrote: Hi, Is your table going to be the same? I mean the number of columns and rows going to be same?? On Wednesday, June 6, 2012 12:51:31 AM

Re: $$Excel-Macros$$ Re: extract data from table

Can you also give me an option if my number of rows change. On Wed, Jun 6, 2012 at 1:18 AM, joseph camill joseph.cam...@gmail.comwrote: yes, the number of rows and columns will be the same, but the values in it may change. On Wed, Jun 6, 2012 at 1:10 AM, Vish vishwamitr...@gmail.com wrote:

$$Excel-Macros$$ VBA script to change cell color if text has strikethrough

I am working on a spreadsheet that contains several columns with due dates. I have conditional formatting rules that change the cell color as a due date gets closer to today's date. 15 days = yellow 10 days = orange 5 days = red Once an activity has been completed, the user formats the date

Re: $$Excel-Macros$$ Re: extract data from table

Hi Joseph, Do you want this done with formula or Vba script? Pascal -- 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

Re: $$Excel-Macros$$ Re: extract data from table

Dear Joseph, Please find attached sheet, Hope it will help to you. for Column Heading =IFERROR(INDEX($1:$1,0,SMALL(IF(($A$2:$A$11=$A$16)*($A$2:$S$110),COLUMN($B$1:$S$1),),COLUMN(B1))-1),) For Numbers without 0 =IFERROR(HLOOKUP(B$15,$B$1:$S$11,MATCH($A16,$A$1:$A$11,0),0),) -- Thanks regards,

Re: $$Excel-Macros$$ VBA script to change cell color if text has strikethrough

Dear Michael, Please share a sample workbook with Group. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Wed, Jun 6, 2012 at 2:03 AM, Michael Landry miclandr...@gmail.comwrote: I am working on a spreadsheet that contains several columns with due

Re: $$Excel-Macros$$ Re: extract data from table

Hi You can use below formula also... =IFERROR(INDEX($B$3:$S$3,MATCH(B$19,$B$1:$S$1,0)),) On Tue, Jun 5, 2012 at 7:31 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Joseph, Please find attached sheet, Hope it will help to you. for Column Heading