$$Excel-Macros$$ Fwd: Job
- Original message From:S Suvarna ssuva...@magna.in Date: 12 Sep 11 13:12:37 Subject: Urgent Oening for SQL Server Developer at Chennai based Client To: S Suvarna Hi, Greetings for the day!!! Let me take this opportunity to introduce Magna Infotech Pvt. Ltd. We are one ofthe most dynamic and fast growing IT Staffing, Development and SolutionsCompany in India. Spread across 7 Different locations Magna always responded tothe ever-changing business dynamics stood the test of time for the lastten years in India, US. Today we are one of the top 3 IT consulting andTechnical Staffing Organization in India. Aiming high to scale dizzier heights.We at Magna Infotech are looking for aggressive and focused individuals to comeand join us in our Journey of Success I think you fit the bill. We havean opening in our organization, which is just right for you. It is a permanentEmployment with Magna Infotech and you will be working for our client, for moreinformation on our organization feel free to log on to www.magna.in. I am sure we willmeet your expectations and together we will move towards a magnificent future. We have an urgent requirement for our Chennai based Client forSQL Server Developer Role: SQL Server Developer Work Location: Chennai Joining Date: ASAP Job Description:Skills Required:*Experience on SQL Server/MS SQL*Experience on .NET*Salary will offer-upto 3 LPA Note: If you are not interested. I would appreciate if youcan refer some of your friends who are looking out for a change. 1. Full Name 2. Alternate Num: 3. Land Line num: 4. Present salary: 5. Expected: 6. DOB: 7. Total work experience: 8. Are you ready for interviews? 9. Current location: 10. Notice Period(Preferred asap) 11. Are you a Graduate? 12.Are you fine to work on Magna Infotech Payroll? Best Regards, Suvarna – Magna infotechssuva...@magna.in Go GreenP Save ATree! Please do not print this email/attachments unless you really need to. -- *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * * * -- -- 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 attachment: image001.png
Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files
Hi Ashish, appreciate you help. The code is partly okay. The above code created a new files with those x and y sheets. Can you alter the above macro code, so that those x and y sheets will get pasted to already existing (12)files? Appreciate your help once again. Regards, Sridhar BL -- -- 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$$ vba help
Thanks for your reply... Can you please do a small favour for me. Now I want to copy the same data not in to more sheets, it should be into different workbooks. Thanks and Regards, Naresh V, Sr Analyst, iSpace global services India pvt ltd. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: Friday, September 09, 2011 9:42 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vba help If you do it that way, you're going to skip some rows: first loop: i = 1, selects 1 to 200 i = i + 200 = 201 second loop: INCREMENTS i i = 201, for loop increments to 202, selects 202 to 401 i = i + 200 = 402 loop increments 402 to 403, selects 403-602 what you SHOULD use for the loop is: For I = 1 to 2000 step 200 that way, the loop is: I = 1 I = 201 I = 401 I = 601 etc. 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. - John Wesley - From: ashish koul koul.ash...@gmail.com To: excel-macros@googlegroups.com Sent: Fri, September 9, 2011 11:40:55 AM Subject: Re: $$Excel-Macros$$ vba help Sub breaksheet_data() For i = 1 To 2000 Sheets(1).Rows(i : i + 199).Copy Sheets.Add After:=Sheets(Sheets.Count) Cells(1, 1).Select ActiveSheet.Paste i = i + 200 Next End Sub On Fri, Sep 9, 2011 at 12:47 PM, naresh v naresh.veerabo...@gmail.commailto:naresh.veerabo...@gmail.com wrote: Hi Group, I have one excel sheet with 2000 records. i want to split those records. those 2000 records should copy into moresheets for ex: main sheet -- 2000 records; sheet1 -- 1 to 200 sheet2 -- 201 to 400 sheet3 -- 401 to 600 . . . sheet10 -- 1801 to 2000 thanks in advance regards, naresh v -- -- 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.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.comhttp://akoul.blogspot.com/ http://akoul.posterous.com/ akoul.wordpress.comhttp://akoul.wordpress.com/ My Linkedin Profilehttp://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.comhttp://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.comhttp://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 DISCLAIMER: This e-mail and any attachments are intended only for the individual or company to which it is addressed and may contain information which is privileged, proprietary, confidential and prohibited from disclosure or unauthorized use under applicable law. If you are not the intended recipient of this e-mail, you are hereby notified that any use, dissemination, or copying of this e-mail or the information contained in this e-mail is strictly prohibited by the sender. If you have received this transmission in error, please return the material received to the sender and delete all copies from your system. -- -- Some important links
Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files
For each in a LIST in range(“a1:a12”) Sub test() For i = 1 To 12 ThisWorkbook.Sheets(Array(Sheet1, Sheet2)).Copy ActiveWorkbook.SaveAs C:\Documents and Settings\ASHISH\Desktop\ABC\book cells(I,”a”) .xlsx ActiveWorkbook.Close Next i End Sub From: ashish koul Sent: Wednesday, September 07, 2011 9:34 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files Hi, Sub test() For i = 1 To 10 ThisWorkbook.Sheets(Array(Sheet1, Sheet2)).Copy ActiveWorkbook.SaveAs C:\Documents and Settings\ASHISH\Desktop\ABC\book i .xlsx ActiveWorkbook.Close Next i End Sub On Wed, Sep 7, 2011 at 5:29 PM, SridharBL sridhar@gmail.com wrote: Ashish, I need to save the sheets of One Workbook to 12 other workbooks. Say, I have One Master excel work book with sheets x and y. These x and y sheets should be moved to other 12 workbooks. So, now all the 12 Work books will have x y sheets as of Master excel work book. Thanks, Sridhar BL -- -- 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
$$Excel-Macros$$ txt to excel
Hey Folks,, I have figured out a code to match the text file with excel sheet name.but not able to open thetext file. Error in red line. I want to open without using get openfilename. Sub Read_text_File() Dim fso, fld, fil As Object Dim fldpth As String fldpth = C:\Documents and Settings\287940\Desktop\Test Macros1\VBA Proj\Amlesh - Naveen\PDF\Page Center Reports Set fso = CreateObject(scripting.filesystemobject) Set fld = fso.getfolder(fldpth) For Each fil In fld.Files fname = fil.Name For i = 1 To Sheets.Count If ActiveWorkbook.Sheets(i).Name = Left(fname, InStr(fname, .) - 1) Then Workbooks.OpenText Filename:=fldpth fname strng .txt, _ Origin:=xlWindows, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:= _ Array(0, 2), TrailingMinusNumbers:=True End If Next i Next fil End Sub Thanks, Mrinal -- -- 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$$ Compare multiple tables - hopefully through a pivot table?
I guess I'm in over my head. I have no clue how to use what you just attached. Thanks anyway. On Sep 8, 9:30 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Robert, Please see attached add-in. It will be help to Compare Table. On Fri, Sep 9, 2011 at 12:29 AM, Robert Jacobs robertjacob...@gmail.comwrote: Thanks in advance, experts! What I have: 2 worksheets in same Excel file, each has a table (Table1 on WS1, Table2 on WS2) with the SAME headers/type of data. As an example (only), BOTH tables have: Invoice# Cat1Sales Cat2Sales Cat3Sales TotalSales The only difference is that Table1 has this info for a single customer, Table2 has the info for multiple other customers. I would like to be able to bring it all into a pivot table (and have a chart) that will allow me to filter and calculate % differences between Table1 and Table2. For instance: Table1 shows that Cat1Sales make up 30% of all sales in the table (Cat2Sales 50%, Cat3Sales 20%), but for other customers (Table2), Cat1Sales make up 50% of all sales (Cat2Sales 10%, Cat3Sales 40%). This will show the customer how their purchasing direction varies from other customers', and maybe help them change their buying habits for more success. I would love to attach my existing file, but I can't seem to figure that out either... Thanks again for helping -- --- --- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ CompareWorksheetsAdd-in.xla 134KViewDownload -- -- 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$$ macros
hello everyone I have created a macro long back and i have protected it and now forgot the passwork, is it possible to veiw the code?? -- -- 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$$
hello everyone i have created a macro and protected it and i forgot the password is it possible to view the code?? please help thanks srinivas -- -- 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: Walk in For Finance Professionals on September 13th and 14thTuesday and Wednesday@ Scope International Haddows Road
- Original message From:Scope International Pvt Ltd ramya.rampra...@sc.com Date: 12 Sep 11 16:01:05 Subject: Walk in For Finance Professionals on September 13th and 14thTuesday and Wednesday@ Scope International Haddows Road To: The sender of this email is registered with Naukri.com as Scope International Pvt Ltd Experience required for the Job: 2 - 7 yearsJob Location: Chennai Dear Candidate,Dear Candidate, Greetings from Scope International!!! Exciting opportunity with Scope International, (subsidiary of Standard Chartered Bank), Chennai for Financial Profesionals. Walk in on Tuesday and Wednesday - September 13th and 14th Experience: 2 yrs Work Location : Chennai No Night shift Walk in with 2 copies of resumes and 2 passport size photo at our Haddows road Office in nungambakkam from 10 Am to 2 Pm. We welcome references * Good Communication is mandatory * Knowledge in Excel * Hands on Experience in MIS ,Budgeting, Forecasting, Contact Person: Ramya Ramprabhu Regards, Recruitment TeamIs this job relevant to you? Yes No Your feedback would help us in sending you the most relevant job opportunities Disclaimer: The sender of this email is registered with naukri.com as Scope International Pvt Ltd (satish.xav...@sc.com, 1,Haddows Road, CHENNAI, Tamilnadu - 66) using Naukri.com services. The responsibility of checking the authenticity of offers/correspondence lies with you. If you consider the content of this email inappropriate or spam, you may:Report abuse by forwarding this email to: compliance@naukri.comYou can also Block this Company from searching your resume in the database. Advisory: Please do not pay any money to anyone who promises to find you a job. This could be in the form of a registration fee, or document processing fee or visa charges or any other pretext. The money could be asked for upfront or it could be asked after trust has been built after some correspondence has been exchanged. Also please note that in case you get a job offer or a letter of intent without having been through an interview process it is probably a scam and you should contact compliance@naukri.comfor advise. To be on the top of Employer's Resume Search Update Your Resume Now Your Resume has only 30 seconds to impress a Recruiter. Get your resume written by Experts. Call 1800-102-5557 now! (Toll-Free) -- *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * * * -- -- 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$$ date difference
Hai all, I am attaching an excel userform which contains Dateof Birth textbox and Date of Retirement textbox. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth is in the year 1960 date of retirement would be 2020 ii) Date of retirement would be last day of the month if date of birth is on 28-04-1981 then date of retirement would in the last day of the April month i.e. 30-04-2041 iii) if the date of retirement falls in the month of February and if it is a leap year then the retirement date would be 29th feb. iv) If date of birth fells on 1st of the month the retirement date would be the last day of the last month eg. if Dob is 01-01-2012 then the date of retirement would be 31-12-2011. I have written code for that but its not throwing errors. if there is any simplest way may kindly be suggest. -- -- 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 dOr.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ date difference
Why not just a simple formula for a dob in cell d11 =DATE(YEAR(D11)+60,MONTH(D11)+1,0) From: Shankar Bheema Sent: Monday, September 12, 2011 9:54 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ date difference Hai all, I am attaching an excel userform which contains Dateof Birth textbox and Date of Retirement textbox. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth is in the year 1960 date of retirement would be 2020 ii) Date of retirement would be last day of the month if date of birth is on 28-04-1981 then date of retirement would in the last day of the April month i.e. 30-04-2041 iii) if the date of retirement falls in the month of February and if it is a leap year then the retirement date would be 29th feb. iv) If date of birth fells on 1st of the month the retirement date would be the last day of the last month eg. if Dob is 01-01-2012 then the date of retirement would be 31-12-2011. I have written code for that but its not throwing errors. if there is any simplest way may kindly be suggest. -- -- 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$$ txt to excel
Try Workbooks.OpenText Filename:=fldpth fname, _ Origin:=xlWindows, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:= _ Array(0, 2), TrailingMinusNumbers:=True On Mon, Sep 12, 2011 at 6:40 PM, mrinal saha mris...@gmail.com wrote: Hey Folks,, I have figured out a code to match the text file with excel sheet name.but not able to open thetext file. Error in red line. I want to open without using get openfilename. Sub Read_text_File() Dim fso, fld, fil As Object Dim fldpth As String fldpth = C:\Documents and Settings\287940\Desktop\Test Macros1\VBA Proj\Amlesh - Naveen\PDF\Page Center Reports Set fso = CreateObject(scripting.filesystemobject) Set fld = fso.getfolder(fldpth) For Each fil In fld.Files fname = fil.Name For i = 1 To Sheets.Count If ActiveWorkbook.Sheets(i).Name = Left(fname, InStr(fname, .) - 1) Then Workbooks.OpenText Filename:=fldpth fname strng .txt, _ Origin:=xlWindows, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:= _ Array(0, 2), TrailingMinusNumbers:=True End If Next i Next fil End Sub Thanks, Mrinal -- -- 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 -- Sam Mathai Chacko -- -- 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$$ date difference
but i am using userform na sir. So pls see my attachment and i am not understanding the mistake i did in my code On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 dguille...@gmail.com wrote: Why not just a simple formula for a dob in cell d11 =DATE(YEAR(D11)+60,MONTH(D11)+1,0) *From:* Shankar Bheema shankar.n...@gmail.com *Sent:* Monday, September 12, 2011 9:54 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ date difference Hai all, I am attaching an excel userform which contains Dateof Birth textbox and Date of Retirement textbox. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth is in the year 1960 date of retirement would be 2020 ii) Date of retirement would be last day of the month if date of birth is on 28-04-1981 then date of retirement would in the last day of the April month i.e. 30-04-2041 iii) if the date of retirement falls in the month of February and if it is a leap year then the retirement date would be 29th feb. iv) If date of birth fells on 1st of the month the retirement date would be the last day of the last month eg. if Dob is 01-01-2012 then the date of retirement would be 31-12-2011. I have written code for that but its not throwing errors. if there is any simplest way may kindly be suggest. -- -- 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$$ date difference
Private Sub CommandButton1_Click() txtdor.Text = DateAdd(, 60, IIf(Day(CDate(txtdob.Text)) = 1, DateAdd(d, -1, CDate(txtdob.Text)), CDate(txtdob.Text))) End Sub Regards, Sam Mathai Chacko (GL) On Mon, Sep 12, 2011 at 9:28 PM, Shankar Bheema shankar.n...@gmail.comwrote: but i am using userform na sir. So pls see my attachment and i am not understanding the mistake i did in my code On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 dguille...@gmail.com wrote: Why not just a simple formula for a dob in cell d11 =DATE(YEAR(D11)+60,MONTH(D11)+1,0) *From:* Shankar Bheema shankar.n...@gmail.com *Sent:* Monday, September 12, 2011 9:54 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ date difference Hai all, I am attaching an excel userform which contains Dateof Birth textbox and Date of Retirement textbox. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth is in the year 1960 date of retirement would be 2020 ii) Date of retirement would be last day of the month if date of birth is on 28-04-1981 then date of retirement would in the last day of the April month i.e. 30-04-2041 iii) if the date of retirement falls in the month of February and if it is a leap year then the retirement date would be 29th feb. iv) If date of birth fells on 1st of the month the retirement date would be the last day of the last month eg. if Dob is 01-01-2012 then the date of retirement would be 31-12-2011. I have written code for that but its not throwing errors. if there is any simplest way may kindly be suggest. -- -- 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 -- Sam Mathai Chacko -- -- 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$$ date difference
I tried with the provided code but its working only with the years but months and days are not working On Mon, Sep 12, 2011 at 9:33 PM, Sam Mathai Chacko samde...@gmail.comwrote: Private Sub CommandButton1_Click() txtdor.Text = DateAdd(, 60, IIf(Day(CDate(txtdob.Text)) = 1, DateAdd(d, -1, CDate(txtdob.Text)), CDate(txtdob.Text))) End Sub Regards, Sam Mathai Chacko (GL) On Mon, Sep 12, 2011 at 9:28 PM, Shankar Bheema shankar.n...@gmail.comwrote: but i am using userform na sir. So pls see my attachment and i am not understanding the mistake i did in my code On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 dguille...@gmail.com wrote: Why not just a simple formula for a dob in cell d11 =DATE(YEAR(D11)+60,MONTH(D11)+1,0) *From:* Shankar Bheema shankar.n...@gmail.com *Sent:* Monday, September 12, 2011 9:54 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ date difference Hai all, I am attaching an excel userform which contains Dateof Birth textbox and Date of Retirement textbox. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth is in the year 1960 date of retirement would be 2020 ii) Date of retirement would be last day of the month if date of birth is on 28-04-1981 then date of retirement would in the last day of the April month i.e. 30-04-2041 iii) if the date of retirement falls in the month of February and if it is a leap year then the retirement date would be 29th feb. iv) If date of birth fells on 1st of the month the retirement date would be the last day of the last month eg. if Dob is 01-01-2012 then the date of retirement would be 31-12-2011. I have written code for that but its not throwing errors. if there is any simplest way may kindly be suggest. -- -- 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 -- Sam Mathai Chacko -- -- 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$$ date difference
And if you go the formula way, try this =IF(DAY(A2)=1,DATE(YEAR(A2-1)+60,MONTH(A2-1)+1,0),DATE(YEAR(A2)+60,MONTH(A2)+1,0)) On Mon, Sep 12, 2011 at 9:43 PM, Sam Mathai Chacko samde...@gmail.comwrote: Thought you wanted to increment date only... Try this Private Sub CommandButton1_Click() txtdor.Text = DateAdd(, 60, IIf(Day(CDate(txtdob.Text)) = 1, DateAdd(d, -1, CDate(txtdob.Text)), DateAdd(m, 1, DateSerial(Year(CDate(txtdob.Text)), Month(CDate(txtdob.Text)), 1)) - 1)) End Sub Sam Mathai Chacko (GL) On Mon, Sep 12, 2011 at 9:37 PM, Shankar Bheema shankar.n...@gmail.comwrote: I tried with the provided code but its working only with the years but months and days are not working On Mon, Sep 12, 2011 at 9:33 PM, Sam Mathai Chacko samde...@gmail.comwrote: Private Sub CommandButton1_Click() txtdor.Text = DateAdd(, 60, IIf(Day(CDate(txtdob.Text)) = 1, DateAdd(d, -1, CDate(txtdob.Text)), CDate(txtdob.Text))) End Sub Regards, Sam Mathai Chacko (GL) On Mon, Sep 12, 2011 at 9:28 PM, Shankar Bheema shankar.n...@gmail.comwrote: but i am using userform na sir. So pls see my attachment and i am not understanding the mistake i did in my code On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 dguille...@gmail.comwrote: Why not just a simple formula for a dob in cell d11 =DATE(YEAR(D11)+60,MONTH(D11)+1,0) *From:* Shankar Bheema shankar.n...@gmail.com *Sent:* Monday, September 12, 2011 9:54 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ date difference Hai all, I am attaching an excel userform which contains Dateof Birth textbox and Date of Retirement textbox. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth is in the year 1960 date of retirement would be 2020 ii) Date of retirement would be last day of the month if date of birth is on 28-04-1981 then date of retirement would in the last day of the April month i.e. 30-04-2041 iii) if the date of retirement falls in the month of February and if it is a leap year then the retirement date would be 29th feb. iv) If date of birth fells on 1st of the month the retirement date would be the last day of the last month eg. if Dob is 01-01-2012 then the date of retirement would be 31-12-2011. I have written code for that but its not throwing errors. if there is any simplest way may kindly be suggest. -- -- 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 -- Sam Mathai Chacko -- -- 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$$ date difference
amazing its working bro. i didnot understand that, in the code you have written IIf(Day(CDate(txtdob.Text). I thought its wrong and changed it to If(Day(CDate(txtdob.Text) then it thrown error. Why it happened so. IIf is what for ? On Mon, Sep 12, 2011 at 9:46 PM, Sam Mathai Chacko samde...@gmail.comwrote: And if you go the formula way, try this =IF(DAY(A2)=1,DATE(YEAR(A2-1)+60,MONTH(A2-1)+1,0),DATE(YEAR(A2)+60,MONTH(A2)+1,0)) On Mon, Sep 12, 2011 at 9:43 PM, Sam Mathai Chacko samde...@gmail.comwrote: Thought you wanted to increment date only... Try this Private Sub CommandButton1_Click() txtdor.Text = DateAdd(, 60, IIf(Day(CDate(txtdob.Text)) = 1, DateAdd(d, -1, CDate(txtdob.Text)), DateAdd(m, 1, DateSerial(Year(CDate(txtdob.Text)), Month(CDate(txtdob.Text)), 1)) - 1)) End Sub Sam Mathai Chacko (GL) On Mon, Sep 12, 2011 at 9:37 PM, Shankar Bheema shankar.n...@gmail.comwrote: I tried with the provided code but its working only with the years but months and days are not working On Mon, Sep 12, 2011 at 9:33 PM, Sam Mathai Chacko samde...@gmail.comwrote: Private Sub CommandButton1_Click() txtdor.Text = DateAdd(, 60, IIf(Day(CDate(txtdob.Text)) = 1, DateAdd(d, -1, CDate(txtdob.Text)), CDate(txtdob.Text))) End Sub Regards, Sam Mathai Chacko (GL) On Mon, Sep 12, 2011 at 9:28 PM, Shankar Bheema shankar.n...@gmail.com wrote: but i am using userform na sir. So pls see my attachment and i am not understanding the mistake i did in my code On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 dguille...@gmail.comwrote: Why not just a simple formula for a dob in cell d11 =DATE(YEAR(D11)+60,MONTH(D11)+1,0) *From:* Shankar Bheema shankar.n...@gmail.com *Sent:* Monday, September 12, 2011 9:54 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ date difference Hai all, I am attaching an excel userform which contains Dateof Birth textbox and Date of Retirement textbox. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth is in the year 1960 date of retirement would be 2020 ii) Date of retirement would be last day of the month if date of birth is on 28-04-1981 then date of retirement would in the last day of the April month i.e. 30-04-2041 iii) if the date of retirement falls in the month of February and if it is a leap year then the retirement date would be 29th feb. iv) If date of birth fells on 1st of the month the retirement date would be the last day of the last month eg. if Dob is 01-01-2012 then the date of retirement would be 31-12-2011. I have written code for that but its not throwing errors. if there is any simplest way may kindly be suggest. -- -- 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 -- Sam Mathai Chacko -- -- 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
Re: $$Excel-Macros$$ Need to populate the data from Pivot
Hi All, Need your help to Populate the data from the pivot for the available columns. Regards Anu On Thu, Sep 8, 2011 at 10:57 PM, anu gomathi anugomathi.d...@gmail.comwrote: Hi All, Please find the attached file. Need to populate the data sheet from pivot Regards Anu On Thu, Sep 8, 2011 at 10:46 PM, anu gomathi anugomathi.d...@gmail.comwrote: Hi All, Please help me with macro to populate the data from the the pivot to the specific fields Regards Anu On Wed, Sep 7, 2011 at 3:17 PM, anu gomathi anugomathi.d...@gmail.comwrote: Hi, Attached the File Regards Anu On Wed, Sep 7, 2011 at 12:25 PM, Abhishek Jain abhishek@gmail.com wrote: Anu, A sample file will help. Please provide. AJ On Wed, Sep 7, 2011 at 12:23 PM, anu gomathi anugomathi.d...@gmail.comwrote: Hi All, Attached the sample data. I have a set of data with multiple opportunity id with the product split which is in the vertical order. Now i have to make the opportunity id unique the product level 3 in the horizantal. I have used the pivot for this linked to the pivot vp sheet to final format sheet. Is there any way to populate the data from the data sheet Final format sheet? or from pivot final format sheet I have linked the the first row in the final format sheet marked in brown. Need to populate the only the linked columns the others should be left blank Regards Anu I -- -- 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. -- -- 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$$ date difference
Thought you wanted to increment date only... Try this Private Sub CommandButton1_Click() txtdor.Text = DateAdd(, 60, IIf(Day(CDate(txtdob.Text)) = 1, DateAdd(d, -1, CDate(txtdob.Text)), DateAdd(m, 1, DateSerial(Year(CDate(txtdob.Text)), Month(CDate(txtdob.Text)), 1)) - 1)) End Sub Sam Mathai Chacko (GL) On Mon, Sep 12, 2011 at 9:37 PM, Shankar Bheema shankar.n...@gmail.comwrote: I tried with the provided code but its working only with the years but months and days are not working On Mon, Sep 12, 2011 at 9:33 PM, Sam Mathai Chacko samde...@gmail.comwrote: Private Sub CommandButton1_Click() txtdor.Text = DateAdd(, 60, IIf(Day(CDate(txtdob.Text)) = 1, DateAdd(d, -1, CDate(txtdob.Text)), CDate(txtdob.Text))) End Sub Regards, Sam Mathai Chacko (GL) On Mon, Sep 12, 2011 at 9:28 PM, Shankar Bheema shankar.n...@gmail.comwrote: but i am using userform na sir. So pls see my attachment and i am not understanding the mistake i did in my code On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 dguille...@gmail.comwrote: Why not just a simple formula for a dob in cell d11 =DATE(YEAR(D11)+60,MONTH(D11)+1,0) *From:* Shankar Bheema shankar.n...@gmail.com *Sent:* Monday, September 12, 2011 9:54 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ date difference Hai all, I am attaching an excel userform which contains Dateof Birth textbox and Date of Retirement textbox. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth is in the year 1960 date of retirement would be 2020 ii) Date of retirement would be last day of the month if date of birth is on 28-04-1981 then date of retirement would in the last day of the April month i.e. 30-04-2041 iii) if the date of retirement falls in the month of February and if it is a leap year then the retirement date would be 29th feb. iv) If date of birth fells on 1st of the month the retirement date would be the last day of the last month eg. if Dob is 01-01-2012 then the date of retirement would be 31-12-2011. I have written code for that but its not throwing errors. if there is any simplest way may kindly be suggest. -- -- 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 -- Sam Mathai Chacko -- -- 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
Re: $$Excel-Macros$$ date difference
Shankar, IIF is an alternative for the IF Else.End if. statement to evaluate single-statement true-false comparisons. The *IIf* function is easier to debug and shortens the amount of code you need to write, and it takes for following format: IIf(Expression, TruePart, FalsePart) The downside of this function is that it evaluates BOTh the true and false parts, and sometimes can cause issues when evaluating various calculations like cheecking if a divisor is 0. Hope this helps. Sam Mathai Chacko On Mon, Sep 12, 2011 at 9:57 PM, Shankar Bheema shankar.n...@gmail.comwrote: amazing its working bro. i didnot understand that, in the code you have written IIf(Day(CDate(txtdob.Text). I thought its wrong and changed it to If(Day(CDate(txtdob.Text) then it thrown error. Why it happened so. IIf is what for ? On Mon, Sep 12, 2011 at 9:46 PM, Sam Mathai Chacko samde...@gmail.comwrote: And if you go the formula way, try this =IF(DAY(A2)=1,DATE(YEAR(A2-1)+60,MONTH(A2-1)+1,0),DATE(YEAR(A2)+60,MONTH(A2)+1,0)) On Mon, Sep 12, 2011 at 9:43 PM, Sam Mathai Chacko samde...@gmail.comwrote: Thought you wanted to increment date only... Try this Private Sub CommandButton1_Click() txtdor.Text = DateAdd(, 60, IIf(Day(CDate(txtdob.Text)) = 1, DateAdd(d, -1, CDate(txtdob.Text)), DateAdd(m, 1, DateSerial(Year(CDate(txtdob.Text)), Month(CDate(txtdob.Text)), 1)) - 1)) End Sub Sam Mathai Chacko (GL) On Mon, Sep 12, 2011 at 9:37 PM, Shankar Bheema shankar.n...@gmail.comwrote: I tried with the provided code but its working only with the years but months and days are not working On Mon, Sep 12, 2011 at 9:33 PM, Sam Mathai Chacko samde...@gmail.comwrote: Private Sub CommandButton1_Click() txtdor.Text = DateAdd(, 60, IIf(Day(CDate(txtdob.Text)) = 1, DateAdd(d, -1, CDate(txtdob.Text)), CDate(txtdob.Text))) End Sub Regards, Sam Mathai Chacko (GL) On Mon, Sep 12, 2011 at 9:28 PM, Shankar Bheema shankar.n...@gmail.com wrote: but i am using userform na sir. So pls see my attachment and i am not understanding the mistake i did in my code On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 dguille...@gmail.comwrote: Why not just a simple formula for a dob in cell d11 =DATE(YEAR(D11)+60,MONTH(D11)+1,0) *From:* Shankar Bheema shankar.n...@gmail.com *Sent:* Monday, September 12, 2011 9:54 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ date difference Hai all, I am attaching an excel userform which contains Dateof Birth textbox and Date of Retirement textbox. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth is in the year 1960 date of retirement would be 2020 ii) Date of retirement would be last day of the month if date of birth is on 28-04-1981 then date of retirement would in the last day of the April month i.e. 30-04-2041 iii) if the date of retirement falls in the month of February and if it is a leap year then the retirement date would be 29th feb. iv) If date of birth fells on 1st of the month the retirement date would be the last day of the last month eg. if Dob is 01-01-2012 then the date of retirement would be 31-12-2011. I have written code for that but its not throwing errors. if there is any simplest way may kindly be suggest. -- -- 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
Re: $$Excel-Macros$$ date difference
I am an advocate of the KISS (keep it simple stupid-not meant personally) so stick with my original offering. From: Shankar Bheema Sent: Monday, September 12, 2011 10:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ date difference but i am using userform na sir. So pls see my attachment and i am not understanding the mistake i did in my code On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 dguille...@gmail.com wrote: Why not just a simple formula for a dob in cell d11 =DATE(YEAR(D11)+60,MONTH(D11)+1,0) From: Shankar Bheema Sent: Monday, September 12, 2011 9:54 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ date difference Hai all, I am attaching an excel userform which contains Dateof Birth textbox and Date of Retirement textbox. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth is in the year 1960 date of retirement would be 2020 ii) Date of retirement would be last day of the month if date of birth is on 28-04-1981 then date of retirement would in the last day of the April month i.e. 30-04-2041 iii) if the date of retirement falls in the month of February and if it is a leap year then the retirement date would be 29th feb. iv) If date of birth fells on 1st of the month the retirement date would be the last day of the last month eg. if Dob is 01-01-2012 then the date of retirement would be 31-12-2011. I have written code for that but its not throwing errors. if there is any simplest way may kindly be suggest. -- -- 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 -- -- 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$$ Look formula to select ledger group
Hi Experts, Is there any formula we can use to select matched texts just like sumif formula(in case of numbers).Kindly find the attached file it ellaborate well about the issue.And tell me how to solve it. Regards Rajesh Kainikkara -- -- 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 Ledger Grouping.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ date difference
Repost I really don’t use USERFORMS, but try Private Sub CommandButton1_Click() txtdor.Text = DateSerial(Year(txtdob.Text) + 60, Month(txtdob.Text) + 1, 0) End Sub From: dguillett1 Sent: Monday, September 12, 2011 1:04 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ date difference I am an advocate of the KISS (keep it simple stupid-not meant personally) so stick with my original offering. From: Shankar Bheema Sent: Monday, September 12, 2011 10:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ date difference but i am using userform na sir. So pls see my attachment and i am not understanding the mistake i did in my code On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 dguille...@gmail.com wrote: Why not just a simple formula for a dob in cell d11 =DATE(YEAR(D11)+60,MONTH(D11)+1,0) From: Shankar Bheema Sent: Monday, September 12, 2011 9:54 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ date difference Hai all, I am attaching an excel userform which contains Dateof Birth textbox and Date of Retirement textbox. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth is in the year 1960 date of retirement would be 2020 ii) Date of retirement would be last day of the month if date of birth is on 28-04-1981 then date of retirement would in the last day of the April month i.e. 30-04-2041 iii) if the date of retirement falls in the month of February and if it is a leap year then the retirement date would be 29th feb. iv) If date of birth fells on 1st of the month the retirement date would be the last day of the last month eg. if Dob is 01-01-2012 then the date of retirement would be 31-12-2011. I have written code for that but its not throwing errors. if there is any simplest way may kindly be suggest. -- -- 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 -- -- 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$$
Hi, Pls send me the file, I will try. Regards Rajesh On 9/12/11, channa srinivas srinivascha...@yahoo.co.in wrote: hello everyone i have created a macro and protected it and i forgot the password is it possible to view the code?? please help thanks srinivas -- -- 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$$ Look formula to select ledger group
It appears that a simple vlookup should do it. =IF(ISNA(VLOOKUP(A11,$A$1:$B$8,2,0)),,(VLOOKUP(A11,$A$1:$B$8,2,0))) -Original Message- From: Rajesh K R Sent: Monday, September 12, 2011 1:51 PM To: excel-macros Subject: $$Excel-Macros$$ Look formula to select ledger group Hi Experts, Is there any formula we can use to select matched texts just like sumif formula(in case of numbers).Kindly find the attached file it ellaborate well about the issue.And tell me how to solve it. Regards Rajesh Kainikkara -- -- 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$$
I would strongly suggest that you not try to break this password UNLESS poster can PROVE ownership. Legal problems -Original Message- From: Rajesh K R Sent: Monday, September 12, 2011 1:58 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Hi, Pls send me the file, I will try. Regards Rajesh On 9/12/11, channa srinivas srinivascha...@yahoo.co.in wrote: hello everyone i have created a macro and protected it and i forgot the password is it possible to view the code?? please help thanks srinivas -- -- 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$$
Hi, I was not aware of that.Thanks for information. Regards Rajesh Kainikkara On 9/13/11, dguillett1 dguille...@gmail.com wrote: I would strongly suggest that you not try to break this password UNLESS poster can PROVE ownership. Legal problems -Original Message- From: Rajesh K R Sent: Monday, September 12, 2011 1:58 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Hi, Pls send me the file, I will try. Regards Rajesh On 9/12/11, channa srinivas srinivascha...@yahoo.co.in wrote: hello everyone i have created a macro and protected it and i forgot the password is it possible to view the code?? please help thanks srinivas -- -- 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 -- -- 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$$ Look formula to select ledger group
Hi, Thanks for getting a very quick reply, I don't know lookup formulas. Regards Rajesh Kainikkara On 9/13/11, dguillett1 dguille...@gmail.com wrote: It appears that a simple vlookup should do it. =IF(ISNA(VLOOKUP(A11,$A$1:$B$8,2,0)),,(VLOOKUP(A11,$A$1:$B$8,2,0))) -Original Message- From: Rajesh K R Sent: Monday, September 12, 2011 1:51 PM To: excel-macros Subject: $$Excel-Macros$$ Look formula to select ledger group Hi Experts, Is there any formula we can use to select matched texts just like sumif formula(in case of numbers).Kindly find the attached file it ellaborate well about the issue.And tell me how to solve it. Regards Rajesh Kainikkara -- -- 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$$ Look formula to select ledger group
Just put in the top cell and use the fill handle to copy down -Original Message- From: Rajesh K R Sent: Monday, September 12, 2011 2:08 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Look formula to select ledger group Hi, Thanks for getting a very quick reply, I don't know lookup formulas. Regards Rajesh Kainikkara On 9/13/11, dguillett1 dguille...@gmail.com wrote: It appears that a simple vlookup should do it. =IF(ISNA(VLOOKUP(A11,$A$1:$B$8,2,0)),,(VLOOKUP(A11,$A$1:$B$8,2,0))) -Original Message- From: Rajesh K R Sent: Monday, September 12, 2011 1:51 PM To: excel-macros Subject: $$Excel-Macros$$ Look formula to select ledger group Hi Experts, Is there any formula we can use to select matched texts just like sumif formula(in case of numbers).Kindly find the attached file it ellaborate well about the issue.And tell me how to solve it. Regards Rajesh Kainikkara -- -- 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 -- -- 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
Consultant Parvathy Email ID parva...@absolutehrs.com Subject: Absolute HR - XL Group - Analyst - Management Information This refers to our telecon today; firstly I would like to thank you for your time. *Absolute HR International* is a Global Talent Acquisition Consulting firm. Absolute HR offers an exhaustive suite of comprehensive HR solutions with a systematic approach to the field of Human Resource Consulting to meet the ever increasing demand for right people. As discussed, please find below a brief write up on the client - *XL Group PLC **http://www.xlgroup.com/* *About the Company:* * * XL Group Plc is a global provider of insurance and reinsurance products services, XL Group companies specialize in commercial risks. Our customers are some of the world's largest industrial, commercial and professional service firms, insurance companies, and financial institutions. As an operations centre of excellence XL India Business Services provides support to the XL group of companies across the world for Underwriting, Claims, Operations, Actuarial Analysis, Finance and Investments processes. With employee strength of 400 plus, XL India has proven its excellence by serving into 19 countries with diversified processes belonging to functions spread across 3 business lines. * * *Position*: *Analyst - Management Information* * * *Shift Timings: 8.30 AM to 5.00 PM OR 12.30 PM to 9.00 PM* * * *Location*: *Gurgaon* ** ** *Primary Responsibilities* ** ** **· **Support the production of the Monthly MI reports **· **Preparation of comprehensive MIS packs **ü **Segment Report **ü **Product Reports **· **Assist in review analysis of financial statements **· **Consolidation of financial results as per US GAAP for Insurance Segment **· **Detailed in depth analysis of various heads profit loss account **· **Ratio analysis **· **Budget variance analysis by business segment, region legal entity **· **Support the production of the MI team’s deliverables **· **Run and Develop Queries/Macros in MS Access and VBA. **· **Develop and run Xcelsius Reports . ** ** Kindly mail me acceptance of applying for this role at the earliest feasible. ** ** *Thanks Regards, * *Parvathy* *Team Integrator* *Absolute HR International USA. CANADA. INDIA www.absolutehrs.com **“Leadership Through Delivery”* *+ 91 20 30454 210* *+91 9011 970 333* [image: cid:image002.jpg@01CB17B2.08CC85F0] P Please consider responsibility towards our environment before printing this e-mail. THINK BEFORE YOU PRINT. ** ** -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ 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 attachment: image001.jpg
$$Excel-Macros$$ Subtotal
I have a macro to sort and subtotal a set of data. This data will always be different amount of lines. I can set the macro to subtotal only current range. If I try to include all lines so that I account for when the lines of data increase, it will not allow the first line to be included. Here is my recorded macro: ActiveSheet.Range($A$20:$H$2745).AutoFilter Field:=5, Criteria1:=0 Range(A21:A2745).Select Selection.EntireRow.Delete ActiveSheet.Range($A$20:$H$634).AutoFilter Field:=5 Range(A20:H634).Select Range(A634).Activate ActiveWorkbook.Worksheets(Sheet1).AutoFilter.Sort.SortFields.Clear ActiveWorkbook.Worksheets(Sheet1).AutoFilter.Sort.SortFields.Add Key:=Range _ (A21:A634), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _ xlSortNormal With ActiveWorkbook.Worksheets(Sheet1).AutoFilter.Sort .Header = xlYes .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With Selection.SUBTOTAL GroupBy:=1, Function:=xlSum, TotalList:=Array(5), _ Replace:=True, PageBreaks:=False, SummaryBelowData:=True End Sub Any ideas? Thanks for your help. -- -- 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$$ *Comparing two columns and sum unique values in excel *
Hi All, I need to compare two columns and sum the unique value. Example: Apple 10 Orange 5 Apple 20 Mango 25 Orange 15 Mango 7 Result Apple 30 Orange 20 Mango 32 Plz help to know the formula. Regards, Prabhu -- -- 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$$ **DAT to Excel conversion**
Hi All, How to convert DAT to Excel file. Now i am just converting by importing DAT to excel but i am facing some alignment problem. Plz help to know the same. Regards Prabhu -- -- 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$$ **DAT to Excel conversion**
try this Sub copy_files() Dim ServerA As String Dim ServerB As String ServerA = C:\temp\filename.dat ServerB = C:\temp\filename2.xls FileCopy ServerA, ServerB End Sub On Tue, Sep 13, 2011 at 7:30 AM, Prabhu prabhugate...@gmail.com wrote: Hi All, How to convert DAT to Excel file. Now i am just converting by importing DAT to excel but i am facing some alignment problem. Plz help to know the same. Regards Prabhu -- -- 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$$ *Comparing two columns and sum unique values in excel *
Use sumif or put pivot tableplease find the attachment.. On Tue, Sep 13, 2011 at 7:15 AM, Prabhu prabhugate...@gmail.com wrote: Hi All, I need to compare two columns and sum the unique value. Example: Apple 10 Orange 5 Apple 20 Mango 25 Orange 15 Mango 7 Result Apple 30 Orange 20 Mango 32 Plz help to know the formula. Regards, Prabhu -- -- 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 su.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ *Comparing two columns and sum unique values in excel *
Dear Prabhu, Please see attached sheet.. Conditional SUM thourgh VBA.. On Tue, Sep 13, 2011 at 7:15 AM, Prabhu prabhugate...@gmail.com wrote: Hi All, I need to compare two columns and sum the unique value. Example: Apple 10 Orange 5 Apple 20 Mango 25 Orange 15 Mango 7 Result Apple 30 Orange 20 Mango 32 Plz help to know the formula. Regards, Prabhu -- -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- 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 Sum_If (VBA).xlsm Description: Binary data
Re: $$Excel-Macros$$ Subtotal
Dear Awal, Please see below link it will help to u. http://www.vbaexpress.com/kb/getarticle.php?kb_id=360 On Tue, Sep 13, 2011 at 5:46 AM, Awal malaw...@gmail.com wrote: I have a macro to sort and subtotal a set of data. This data will always be different amount of lines. I can set the macro to subtotal only current range. If I try to include all lines so that I account for when the lines of data increase, it will not allow the first line to be included. Here is my recorded macro: ActiveSheet.Range($A$20:$H$2745).AutoFilter Field:=5, Criteria1:=0 Range(A21:A2745).Select Selection.EntireRow.Delete ActiveSheet.Range($A$20:$H$634).AutoFilter Field:=5 Range(A20:H634).Select Range(A634).Activate ActiveWorkbook.Worksheets(Sheet1).AutoFilter.Sort.SortFields.Clear ActiveWorkbook.Worksheets(Sheet1).AutoFilter.Sort.SortFields.Add Key:=Range _ (A21:A634), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _ xlSortNormal With ActiveWorkbook.Worksheets(Sheet1).AutoFilter.Sort .Header = xlYes .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With Selection.SUBTOTAL GroupBy:=1, Function:=xlSum, TotalList:=Array(5), _ Replace:=True, PageBreaks:=False, SummaryBelowData:=True End Sub Any ideas? Thanks for your help. -- -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- 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$$ date difference
thank one and all for providing solution for me. On Tue, Sep 13, 2011 at 12:23 AM, dguillett1 dguille...@gmail.com wrote: Repost I really don’t use USERFORMS, but try Private Sub CommandButton1_Click() txtdor.Text = DateSerial(Year(txtdob.Text) + 60, Month(txtdob.Text) + 1, 0) End Sub *From:* dguillett1 dguille...@gmail.com *Sent:* Monday, September 12, 2011 1:04 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ date difference I am an advocate of the KISS (keep it simple stupid-not meant personally) so stick with my original offering. *From:* Shankar Bheema shankar.n...@gmail.com *Sent:* Monday, September 12, 2011 10:58 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ date difference but i am using userform na sir. So pls see my attachment and i am not understanding the mistake i did in my code On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 dguille...@gmail.com wrote: Why not just a simple formula for a dob in cell d11 =DATE(YEAR(D11)+60,MONTH(D11)+1,0) *From:* Shankar Bheema shankar.n...@gmail.com *Sent:* Monday, September 12, 2011 9:54 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ date difference Hai all, I am attaching an excel userform which contains Dateof Birth textbox and Date of Retirement textbox. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth is in the year 1960 date of retirement would be 2020 ii) Date of retirement would be last day of the month if date of birth is on 28-04-1981 then date of retirement would in the last day of the April month i.e. 30-04-2041 iii) if the date of retirement falls in the month of February and if it is a leap year then the retirement date would be 29th feb. iv) If date of birth fells on 1st of the month the retirement date would be the last day of the last month eg. if Dob is 01-01-2012 then the date of retirement would be 31-12-2011. I have written code for that but its not throwing errors. if there is any simplest way may kindly be suggest. -- -- 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 -- -- 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
$$Excel-Macros$$ Re: Inventory Sheet
Hi All Please help me for the inventory sheet for manufacturing unit. Regards Manhar -- On Sat, Sep 10, 2011 at 4:33 PM, manhar prajapati prajapati.man...@gmail.com wrote: Hi Anyone have inventory sheet for manufacturing unit. -- *Manhar Prajapati* *Contact: 9824335449* :) -- *Manhar Prajapati* *Contact: 9824335449* :) -- -- 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