Re: $$Excel-Macros$$ Posting jobs in group
Thanks Ayush. Best Regards, DILIPandey On 6/8/11, Ayush jainayus...@gmail.com wrote: Dilip, Ok, I will approve the external link if it is opening form for that specific job only. I hope that is fine. Dear Group, Start posting jobs :) Regards Ayush Jain Group Manager -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sent from my mobile device Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Application.Caller
Hi Ashish, Exactly what I wanted. Didn't know about the .TextFrame part. Thanks! Regards - Dave. Date: Thu, 9 Jun 2011 11:10:06 +0530 Subject: Re: $$Excel-Macros$$ Application.Caller From: koul.ash...@gmail.com To: excel-macros@googlegroups.com below code will help you in extracting the text on images see if it helps you Rectangle 1 , 5-Point Star 2 name of images or boxes a = ActiveSheet.Shapes(Rectangle 1).TextFrame.Characters.Text b = ActiveSheet.Shapes(5-Point Star 2).TextFrame.Characters.Text On Thu, Jun 9, 2011 at 9:59 AM, Dave davebonall...@hotmail.com wrote: Hi group, I have 3 buttons on the worksheet which all fire the same macro. Each button has different text, and the macro examins this text, and uses it to run slightly differently depending on which button was used to fire it. To obtain the text on the button, I use: A = ActiveSheet.Buttons(Application.Caller).Characters.Text The variable 'A' then holds the text. But Excel buttons are a bit dull, so I was trying to brighten up the sheet by using rectangles instead, which I can format as I please. Although I could fire the macro from the rectangle, I couldn't find the syntax to return the text within the rectangle. Anyone know the syntax for this? Regards - Dave. -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.com http://akoul.posterous.com/ akoul.wordpress.com My Linkedin Profile P Before printing, think about the environment. -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Current Region
Thanks for the reply. How to put loop if we have more than one current region. Thanks! Regards, Chandra Shekar B On Wed, Jun 8, 2011 at 8:06 PM, Rajan_Verma rajanverma1...@gmail.comwrote: HI Please use this Code Sub HighLight() Dim rng As Range ActiveCell.CurrentRegion.Select Set rng = Selection ActiveCell.Resize(1, rng.Columns.Count).Interior.Color = 15773695 rng.Cells(rng.Rows.Count, 1).Resize(1, rng.Columns.Count).Interior.Color = 15773696 End Sub Rajan *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar *Sent:* Wednesday, June 08, 2011 4:01 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Current Region Hi, Please find attached file here I want to highlight first and last row of the region, Please let me know how to do this in VBA. Thanks, Chandra Shekar B -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Excel Macro- source series for a chart from all sheets
Please attached Your Sample WOrksheet -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kat Sent: Wednesday, June 08, 2011 6:49 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Excel Macro- source series for a chart from all sheets I'm sorry, I'm still not having any luck with this. I'm getting runtime error 91, object variable or With block not set. Does this mean that when you select the sheets you deselect your chart? How do I best write the code within the loop so that I do not get this error? On Jun 6, 3:22 pm, ashish koul koul.ash...@gmail.com wrote: Sub test() For i = 1 To Sheets.Count Sheets(i).Select ' paste ur code here Next i End Sub On Mon, Jun 6, 2011 at 2:12 PM, Kat viridiancade...@googlemail.com wrote: Hi all, I have a large spreadsheet, ~200 sheets. For each of these, I wish to plot a series where the x values are D3:D103 and the y values are E3:E103, and the series name is the same as that of the sheet, all on the same chart. So far I have ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).XValues = ='0,-1 '!R3C4:R103C4 ActiveChart.SeriesCollection(1).Values = ='0,-1 '!R3C5:R103C5 ActiveChart.SeriesCollection(1).Name = =0,-1 However, I am not sure how to loop this action to cover all worksheets in the book, and not sure how to get excel to automatically write the sheet name as the series name. Any ideas? Thanks in advance. -K -- --- --- 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=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment.- Hide quoted text - - Show quoted text - -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ JOB
Hi All, I recieved this mail regarding opeing with Zensar today, forwarding it to group . if some is looking for the job HE/SHE can apply Please find the job details below Dear ashish, Greetings from Zensar! Zensar Technologies (www.zensar.com) is among the top 25 software service providers in India. Headquartered in India, Zensar is the world's first enterprise-wide SEI CMM Level 5 Company and now a CMMI Level 5 Company with industry expertise that spans across Banking, Financial Services and Insurance, Utilities, Retail and Distribution, Manufacturing and Telecommunications. With revenues exceeding Rs. 497cr for FY 2009-10 and a growing strength of 6000+ associates worldwide, we are well on the way to becoming the preferred software services partner for Fortune clients. Position: VBA _Excel Developers No. of positions: 10 Nos. Experience – 4-7 years Job location: Pune Skill Set is give below: TASK DESCRIPTION: • Expertise in MS Excel for analysis and reporting • Good Analytical and management Skills • Expertise in Oracle/SQL Server • Ability to relate various data sources for comparing / contrasting • Ability to interpret requirements and be self driven • Ability to work independently with minimum directions • Manage meeting and excellent communication skills MANDATORY SKILL DESCRIPTION MIS Specialist Analysis Excel and VBA Oracle/SQL Server Lead/Client Communication Please Mail your updated profiles to s.indur...@zensar.com Current CTC - Expected CTC- Notice Period- Current Location- Relevant Experience as a VBA _Excel Developers - Regards Dilpreet Human Resource Zensar Technologies Ltd Zensar Knowledge Park, Plot#4, MIDC, Kharadi, Off Nagar Road, Pune – 411014 -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Product wise total sale between two dates
try this c6= =SUMIFS('Sale Data-10-11'!E:E,'Sale Data-10-11'!A:A,Final!B6,'Sale Data-10-11'!D:D,=Final!$C$4,'Sale Data-10-11'!D:D,=Final!$C$5) On Thu, Jun 9, 2011 at 7:21 PM, Kal xcel kalx...@gmail.com wrote: Dear Experts, I need a help to get product wise total sale between two dates. Please see the attachment. Thanks in advance Kalyan -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Excel 2010 problem - Need to work with 15 + digits
DEF Highligh the column then go to DATA then Text to Column. You will have 2 choices, Delimited or Fixed. I don't know how the data is so I am guessing no commas. I would choose Delimited. Click next. Click tab as I think there is no spaces. If so then click spaces too. click next then the data should be highlighted. In the column data format click Text. Then finish. That should solve it. Johnny -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Formula Needed to Extract Data
Ash Can you post the VBA code? I downloaded the example but it is not in the workbook. I need to use a similar code for data extraction also. This code might help me, too. Thanks Johnny -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Reverse Vlookup - -- very very urgent
Hi friends, this is really really urgent and very very very IMP for me so quick help would be really really appreciated. Name No a 1 s 2 d 3 f 4 g 5 h 6 j 7 data is like above i.e. first Name and then No. i want to Vlookup for No. values and get Name but without moving any col or modifying anything. i.e something like =VLOOKUP(E2,$B$2:$D$8,3,0) but this will not work as in a range parameter No. column is not at 1st place. please find the attached workbook for more details. let me know if you need anything else. -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Reverse Vlookup.xls Description: application/excel
$$Excel-Macros$$ Error 424 and With block
Can anyone tell me why this works: Sub LoadActuals(a As Worksheet) ... a.ListObjects(1).DataBodyRange.Font.Name = Arial ... End Sub but this gets Error 424 Object required: Sub LoadActuals(a As Worksheet) ... With a.ListObjects(1).DataBodyRange ... .Font.Name = Arial ... End With End Sub ??? Thanks. -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Reverse Vlookup - -- very very urgent
=OFFSET($A$1,MATCH(E2,$B$2:$B$8,0),0) or =INDEX($A$2:$B$8,MATCH(E2,$B$2:$B$8,0),1) On Fri, Jun 10, 2011 at 3:14 AM, hanumant shinde arsfan2...@yahoo.co.inwrote: Hi friends, this is really really urgent and very very very IMP for me so quick help would be really really appreciated. Name No a 1 s 2 d 3 f 4 g 5 h 6 j 7 data is like above i.e. first Name and then No. i want to Vlookup for No. values and get Name but without moving any col or modifying anything. i.e something like =VLOOKUP(E2,$B$2:$D$8,3,0) but this will not work as in a range parameter No. column is not at 1st place. please find the attached workbook for more details. let me know if you need anything else. -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel ctv_Vlookup_to_LEFT.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Formula Needed to Extract Data
Johnny Can you please tell me which code you are talking about workbook which i attached as answer to this post is having only formulas can you attach your workbook. and brief description about ur problem On Thu, Jun 9, 2011 at 11:41 PM, Johnny jam7...@gmail.com wrote: Ash Can you post the VBA code? I downloaded the example but it is not in the workbook. I need to use a similar code for data extraction also. This code might help me, too. Thanks Johnny -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Reverse Vlookup - -- very very urgent
Its working good. thanks.. regards kannan V On Fri, Jun 10, 2011 at 7:43 AM, STDEV(i) setiyowati.d...@gmail.com wrote: =OFFSET($A$1,MATCH(E2,$B$2:$B$8,0),0) or =INDEX($A$2:$B$8,MATCH(E2,$B$2:$B$8,0),1) On Fri, Jun 10, 2011 at 3:14 AM, hanumant shinde arsfan2...@yahoo.co.inwrote: Hi friends, this is really really urgent and very very very IMP for me so quick help would be really really appreciated. Name No a 1 s 2 d 3 f 4 g 5 h 6 j 7 data is like above i.e. first Name and then No. i want to Vlookup for No. values and get Name but without moving any col or modifying anything. i.e something like =VLOOKUP(E2,$B$2:$D$8,3,0) but this will not work as in a range parameter No. column is not at 1st place. please find the attached workbook for more details. let me know if you need anything else. -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Macro to put singles years of age into five year age bands
Hi Sarah, A way of using worksheet formulas without a lookup table: If your data is in A2, paste this formula into an adjacent cell: =ROUNDDOWN(H16*2,-1)/2 - (ROUNDDOWN(H16*2,-1)/2)+4 It's a bit cumbersome, but gives the answer and format you need. Regards - Dave. -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Macro to put singles years of age into five year age bands
Oops. That was supposed to be: =ROUNDDOWN(A2*2,-1)/2 - (ROUNDDOWN(A2*2,-1)/2)+4 Dave. -- -- 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=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel