$$Excel-Macros$$ Job
Recruiter- Susan Monica susan.mon...@htcindia.com *Experience required for Job:* 1 - 5 years *Job Annual Salary:* 1.0 - 5.0 Lacs *Job location:* Singapore A marketing information company specialized in conducting customer service satisfaction surveys in various industries. Job: VBA Programmer Job Scope: 1) Develop Excel / Power point based client deliverables/reports though VBA programming 2) Create charts in Excel and PowerPoint. 3) Develop VBA based E-Tools in Excel for research projects for data delivery. 4) Checking reports for accuracy. 5) Documentation of program specifications and research requirements. Duration: Permanent Starting Date: ASAP Requirements: 1) Graduate degree in computer science or related subjects. 2) Programming skills, preferably in VB or VBA. 3) Strong Analytical/ Deductive reasoning Skills. 4) Must have strong communication skills, task prioritization and time management skills. 5) Experience (min. 1 year) in MS Access / MS SQL database (desirable) 6) Experience (min 1 year) in screen design/graphic design (preferred but not mandatory) 7) Ability to work long hours on need basis to meet the client deliverables on time. 8) Ability to demonstrate quick learning and work under minimum supervision. Note: Interested candidates may send their updated profile with the below details. Candidates must be available to join in 20 days of time. Name: Contact Details: Email: Total Exp: Rel Exp: Technical Rating: Comm Skills Rating: Current Company: Current Location: CTC: Notice Period: Regards, Susan Monica susan.mon...@htcindia.com Human Resources, HTC Global Services, URL: www.htcinc.com An Inc.500 Hall of Fame Company *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ JOB
Hi All, I recieved this mail regarding opeing with Zensar today, forwarding it to group . if some is looking for the job HE/SHE can apply Please find the job details below Dear ashish, Greetings from Zensar! Zensar Technologies (www.zensar.com) is among the top 25 software service providers in India. Headquartered in India, Zensar is the world's first enterprise-wide SEI CMM Level 5 Company and now a CMMI Level 5 Company with industry expertise that spans across Banking, Financial Services and Insurance, Utilities, Retail and Distribution, Manufacturing and Telecommunications. With revenues exceeding Rs. 497cr for FY 2009-10 and a growing strength of 6000+ associates worldwide, we are well on the way to becoming the preferred software services partner for Fortune clients. Position: VBA _Excel Developers No. of positions: 10 Nos. Experience – 4-7 years Job location: Pune Skill Set is give below: TASK DESCRIPTION: • Expertise in MS Excel for analysis and reporting • Good Analytical and management Skills • Expertise in Oracle/SQL Server • Ability to relate various data sources for comparing / contrasting • Ability to interpret requirements and be self driven • Ability to work independently with minimum directions • Manage meeting and excellent communication skills MANDATORY SKILL DESCRIPTION MIS Specialist Analysis Excel and VBA Oracle/SQL Server Lead/Client Communication Please Mail your updated profiles to s.indur...@zensar.com Current CTC - Expected CTC- Notice Period- Current Location- Relevant Experience as a VBA _Excel Developers - Regards Dilpreet Human Resource Zensar Technologies Ltd Zensar Knowledge Park, Plot#4, MIDC, Kharadi, Off Nagar Road, Pune – 411014 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Product wise total sale between two dates
try this
c6= =SUMIFS('Sale Data-10-11'!E:E,'Sale Data-10-11'!A:A,Final!B6,'Sale
Data-10-11'!D:D,=Final!$C$4,'Sale Data-10-11'!D:D,=Final!$C$5)
On Thu, Jun 9, 2011 at 7:21 PM, Kal xcel kalx...@gmail.com wrote:
Dear Experts,
I need a help to get product wise total sale between two dates.
Please see the attachment.
Thanks in advance
Kalyan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com http://akoul.blogspot.com/
http://akoul.posterous.com/
*akoul*.wordpress.com http://akoul.wordpress.com/
My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830
P Before printing, think about the environment.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Formula Needed to Extract Data
Johnny Can you please tell me which code you are talking about workbook which i attached as answer to this post is having only formulas can you attach your workbook. and brief description about ur problem On Thu, Jun 9, 2011 at 11:41 PM, Johnny jam7...@gmail.com wrote: Ash Can you post the VBA code? I downloaded the example but it is not in the workbook. I need to use a similar code for data extraction also. This code might help me, too. Thanks Johnny -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Excel Macro- source series for a chart from all sheets
can you share you sample workbook of 2 or 3 sheets On Wed, Jun 8, 2011 at 6:48 PM, Kat viridiancade...@googlemail.com wrote: I'm sorry, I'm still not having any luck with this. I'm getting runtime error 91, object variable or With block not set. Does this mean that when you select the sheets you deselect your chart? How do I best write the code within the loop so that I do not get this error? On Jun 6, 3:22 pm, ashish koul koul.ash...@gmail.com wrote: Sub test() For i = 1 To Sheets.Count Sheets(i).Select ' paste ur code here Next i End Sub On Mon, Jun 6, 2011 at 2:12 PM, Kat viridiancade...@googlemail.com wrote: Hi all, I have a large spreadsheet, ~200 sheets. For each of these, I wish to plot a series where the x values are D3:D103 and the y values are E3:E103, and the series name is the same as that of the sheet, all on the same chart. So far I have ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).XValues = ='0,-1 '!R3C4:R103C4 ActiveChart.SeriesCollection(1).Values = ='0,-1 '!R3C5:R103C5 ActiveChart.SeriesCollection(1).Name = =0,-1 However, I am not sure how to loop this action to cover all worksheets in the book, and not sure how to get excel to automatically write the sheet name as the series name. Any ideas? Thanks in advance. -K -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment.- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Macro to put singles years of age into five year age bands
check the attachment see if it helps On Wed, Jun 8, 2011 at 8:37 PM, Sarah Seager slseage...@gmail.com wrote: Hi, I regularly have to look at raw data that shows me the age of people. However for most of my analysis I have to convert these ages into 5 year age bands (0-4y, 5-9y,.75-59y, 80-84y and 85+) The column that my ages is in is never the same, so I'd like my macro to run on whatever cells I select and then to insert them into an empty field. Any ideas? Sarah -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel PROB.xlsm Description: Binary data
Re: $$Excel-Macros$$ solution to put data automtically
issue = INDEX(E:E,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0) reading =INDEX(F:F,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0) On Wed, Jun 8, 2011 at 7:03 PM, Subhash Yadav scy2...@gmail.com wrote: Dear friends, I am having one sheet containing data for fuel issue. I want, if i put any asset code previous issue and previous reading should come from the latest present issue and present reading of same asset. In the attached sheet yellow cell date should come in yellow cell and magenta cell data should come in magenta cell. Please help me out. -- Subhash Chand Yadav -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ How to copy sheet to new book without sheet module code?
Melina see if it helps try this link once you copied the sheet to new workbook the delte the code of the worksheets. or instead of copying the sheet, copy the data in the sheet and add a new sheet to new workbook and paste the data in it http://www.ozgrid.com/VBA/delete-sheet-code.htm On Thu, Jun 9, 2011 at 5:47 AM, Mel mel.tu...@yahoo.com wrote: I copy specific sheets from one book into a new book but I don't want any VBA code in the new book. One sheet, however, has code in the sheet module. How can I copy it without the code or remove the code in the destination book? For the copy, I'm simply using... Sheets(Array(sShtName1, sShtName2, sShtName3, sShtName4)).Copy Assume sShtName4 has the sheet code. Thanks, Melina -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Application.Caller
below code will help you in extracting the text on images see if it helps you Rectangle 1 , 5-Point Star 2 name of images or boxes a = ActiveSheet.Shapes(Rectangle 1).TextFrame.Characters.Text b = ActiveSheet.Shapes(5-Point Star 2).TextFrame.Characters.Text On Thu, Jun 9, 2011 at 9:59 AM, Dave davebonall...@hotmail.com wrote: Hi group, I have 3 buttons on the worksheet which all fire the same macro. Each button has different text, and the macro examins this text, and uses it to run slightly differently depending on which button was used to fire it. To obtain the text on the button, I use: A = ActiveSheet.Buttons(Application.Caller).Characters.Text The variable 'A' then holds the text. But Excel buttons are a bit dull, so I was trying to brighten up the sheet by using rectangles instead, which I can format as I please. Although I could fire the macro from the rectangle, I couldn't find the syntax to return the text within the rectangle. Anyone know the syntax for this? Regards - Dave. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Copy Multiple Workbooks into One Workbook Macro problem ...
try this http://akoul.blogspot.com/2011/02/merge-data-from-multiple-sheet-from.html see if it helps On Tue, Jun 7, 2011 at 2:37 AM, Greg gamoun...@gmail.com wrote: Hi, I am trying to use a macro which copies multiple workbooks into a single workbook. However, something is going awry. The only thing it does is create a blank Worksheet is created. Can someone explain why this is happening? I copied the macro from the following weblink: http://excelribbon.tips.net/T008884_Condensing_Multiple_Worksheets_Into_One.html Thanks in advance for your help. -Greg -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need a basic tutorial in VB
check the websites and videos at listed o n the below links http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/ http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/ On Tue, Jun 7, 2011 at 4:08 AM, Gagan Singh gaganvicky2...@gmail.comwrote: Hi, I've good knowledge of Advance Excel. Now i want to learn of to do programming through VB, make macro's in VB.Can some one give me a link of the tutorial thru which i can learn the basics of VB. Thanks a ton.. Gagan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Copy Multiple Workbooks into One Workbook Macro problem ...
have you added Microsoft shell control and automation in refrences tool - reference - Microsoft shell control and automation On Tue, Jun 7, 2011 at 7:11 PM, Greg gamoun...@gmail.com wrote: Thanks Ashish for your reply. When I use this macro I get the following error message: Compile error: User-define type not defined. The following line in the macro code is highlighted: Dim objShell As New Shell32.Shell -Greg On Jun 7, 2:22 am, ashish koul koul.ash...@gmail.com wrote: try this http://akoul.blogspot.com/2011/02/merge-data-from-multiple-sheet-from... see if it helps On Tue, Jun 7, 2011 at 2:37 AM, Greg gamoun...@gmail.com wrote: Hi, I am trying to use a macro which copies multiple workbooks into a single workbook. However, something is going awry. The only thing it does is create a blank Worksheet is created. Can someone explain why this is happening? I copied the macro from the following weblink: http://excelribbon.tips.net/T008884_Condensing_Multiple_Worksheets_In. .. Thanks in advance for your help. -Greg -- --- --- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Copy Multiple Workbooks into One Workbook Macro problem ...
save this file in folder and run macro and the new file created will be saved in the same folder automatically On Tue, Jun 7, 2011 at 8:25 PM, Greg gamoun...@gmail.com wrote: Ok, I've added Microsoft shell and the error message has gone away but no file is created. I look into the folder I selected no Excel spreadsheet is created. Isn't that the way it suppose to work? On Jun 7, 10:01 am, ashish koul koul.ash...@gmail.com wrote: have you added Microsoft shell control and automation in refrences tool - reference - Microsoft shell control and automation On Tue, Jun 7, 2011 at 7:11 PM, Greg gamoun...@gmail.com wrote: Thanks Ashish for your reply. When I use this macro I get the following error message: Compile error: User-define type not defined. The following line in the macro code is highlighted: Dim objShell As New Shell32.Shell -Greg On Jun 7, 2:22 am, ashish koul koul.ash...@gmail.com wrote: try this http://akoul.blogspot.com/2011/02/merge-data-from-multiple-sheet-from... see if it helps On Tue, Jun 7, 2011 at 2:37 AM, Greg gamoun...@gmail.com wrote: Hi, I am trying to use a macro which copies multiple workbooks into a single workbook. However, something is going awry. The only thing it does is create a blank Worksheet is created. Can someone explain why this is happening? I copied the macro from the following weblink: http://excelribbon.tips.net/T008884_Condensing_Multiple_Worksheets_In. .. Thanks in advance for your help. -Greg -- --- --- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- --- --- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros
Re: $$Excel-Macros$$ Help with Excel macro
i guess you want to create addin in excel check the link below http://www.ozgrid.com/VBA/excel-add-in-create.htm On Wed, Jun 8, 2011 at 2:13 AM, programmernovice programmernov...@yahoo.com wrote: Hello, I need to an Excel macro that will click a button on the toolbar. A drop-down menu appears and then I need to make a selection (click again) from this menu. I use Excel 2003. Can someone provide a simple script to do this? Or alternatively point me in the proper direction in the net. Many thanks in advance. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Unexpected Open File Dialog
can you share the excel file I am not sure whether this will help you or not ,can you run the below macro once in ur workbook Sub BreakLinks() 'Author : Ken Puls (www.excelguru.ca) 'Macro Purpose: Break all links in the active workbook Dim vLinks As Variant Dim lLink As Long ' Define variable as an Excel link type. vLinks = ActiveWorkbook.LinkSources(Type:=xlLinkTypeExcelLinks) If vLinks = vbNullString Then Exit Sub ' Break all links in the active workbook. For lLink = LBound(vLinks) To UBound(vLinks) ActiveWorkbook.BreakLink _ Name:=vLinks(lLink), _ Type:=xlLinkTypeExcelLinks Next lLink End Sub On Wed, Jun 8, 2011 at 12:53 AM, Evan Smith esmith2...@gmail.com wrote: I have a macro that builds a dynamic list of names, then references values in another spreadsheet through VLOOKUP. I have a worksheet I use as a template that only has the VLOOKUP formulas in the first row. I use the AutoFill method to copy the formula to the rest of the lines depending on how many rows there are from a dynamic list. The VLOOKUP formula originally used a relative name for the table from the reference workbook [RefData]Data1!A:B. This file was opened as part of the macro before the AutoFill occurred and all the VLOOKUP references happily populated themselves. Somewhere over time, something's changed that I can't find. Now every time the AutoFill gets executed, it prompts me for the file, even though it's open. After I choose the file, it goes on its merry way. Since I actually use 4 files for external lookup data, I now get prompted 4 times. I have also tried prepending the complete file path to the workbook name, but still manage to invoke the open file dialog. Since this macro is run many times a day, it gets old really quickly. I've asked all my local gurus, and searched this group, and can't seem to find anyone who's having this same issue. Anyone here ever seen this or know how to revert to the non-prompting behavior? Thanks in advance, Evan Platform = Windows XP + Excel 2003 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ To Copy Paste Data
try this Sub TEST() Rows(2: Range(A1).End(xlDown).Row).Copy Sheets(Detailed).Select Sheets(Detailed).Range(A65356).End(xlUp).Offset(1, 0).Select ActiveSheet.Paste Sheets(Detailed).Range(A1: E Sheets(Detailed).Range(A1).End(xlDown).Row).Sort key1:=Sheets(Detailed).Range(a:a), order1:=xlAscending, Header:=xlYes End Sub On Wed, Jun 8, 2011 at 12:14 AM, kurikkal padinjarappalla padinjarappa...@gmail.com wrote: Dear Experts, Is there a way that in the attached file after entering data in the sheets named 7th June, 8th June, 9th June etc, should be get copy and pasted in detailed sheet on date wise by activating any command button. Thanks in advance. Regards, Kurikkal. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Excel Macro- source series for a chart from all sheets
Sub test() For i = 1 To Sheets.Count Sheets(i).Select ' paste ur code here Next i End Sub On Mon, Jun 6, 2011 at 2:12 PM, Kat viridiancade...@googlemail.com wrote: Hi all, I have a large spreadsheet, ~200 sheets. For each of these, I wish to plot a series where the x values are D3:D103 and the y values are E3:E103, and the series name is the same as that of the sheet, all on the same chart. So far I have ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).XValues = ='0,-1 '!R3C4:R103C4 ActiveChart.SeriesCollection(1).Values = ='0,-1 '!R3C5:R103C5 ActiveChart.SeriesCollection(1).Name = =0,-1 However, I am not sure how to loop this action to cover all worksheets in the book, and not sure how to get excel to automatically write the sheet name as the series name. Any ideas? Thanks in advance. -K -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$
you want to search word divya is name of file or in content of file On Mon, Jun 6, 2011 at 6:50 PM, chhajersand...@gmail.com wrote: Dear excel guru, I have a unique problem. Few days ago my hard disk was crashed. Now when I have recovered all the data,instead of file name assigned to those file, system has assigned file no.(i.e. system generated code to every file) I have 6 pdf file to rename. Is there any way to write macro which can find a particular word and give me the name of such files which contains that particular word! Like if in the search criteria I write divya ltd. It will give the all the names of the file in excel containing word divya ltd. Thanks in advance. Sent on my BlackBerry® from Vodafone -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ i want 2 or more copies print when i press print button - Reg
try this Worksheets(sheet2).PrintOut Copies: 2 On Mon, Jun 6, 2011 at 4:58 PM, jmothilal gjmothi...@gmail.com wrote: Sir i want print 2 copies for my selected areas i am using print push button Worksheets(sheet2).PrintOut any one help Thanks with Mothilal.J -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Formula Needed to Extract Data
see if it helps On Wed, Jun 1, 2011 at 7:07 PM, John A. Smith johnasmit...@gmail.comwrote: Need help please extracting specific data from an Excel spreadsheet into an Excel report. The arrangement of the data isn't always in the same order as shown in the attached sample. Thank you again for your kind help. John -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Copy of Formula Needed to Extract Data from Excel.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ How to filter only the required information using VBA codes?
hi check the attachment done with 2 ways one with help of extra col Temp COL AND RUN macro method 1 or try method 2 macro On Tue, May 24, 2011 at 9:18 PM, John Mutesi jmut...@mtc.com.na wrote: Friends, I am sitting with a simple problem. Given the info below, i want to use vba codes to inset a filter and filter out only the following times and it doesn't matter what which day of the month it is; 11:00, 11;30, 19:00, 19:30, 20:00, 20:30, 21:00, 21:30, 22:00 and 22:30. Start Time 05/22/2011 00:00:00 05/22/2011 00:30:00 05/22/2011 01:00:00 05/22/2011 01:30:00 05/22/2011 02:00:00 05/22/2011 02:30:00 05/22/2011 03:00:00 05/22/2011 03:30:00 05/22/2011 04:00:00 05/22/2011 04:30:00 05/22/2011 05:00:00 05/22/2011 05:30:00 05/22/2011 06:00:00 05/22/2011 06:30:00 05/22/2011 07:00:00 05/22/2011 07:30:00 05/22/2011 08:00:00 05/22/2011 08:30:00 05/22/2011 09:00:00 05/22/2011 09:30:00 05/22/2011 10:00:00 05/22/2011 10:30:00 05/22/2011 11:00:00 05/22/2011 11:30:00 05/22/2011 12:00:00 05/22/2011 12:30:00 05/22/2011 13:00:00 05/22/2011 13:30:00 05/22/2011 14:00:00 05/22/2011 14:30:00 05/22/2011 15:00:00 05/22/2011 15:30:00 05/22/2011 16:00:00 05/22/2011 16:30:00 05/22/2011 17:00:00 05/22/2011 17:30:00 05/22/2011 18:00:00 05/22/2011 18:30:00 05/22/2011 19:00:00 05/22/2011 19:30:00 05/22/2011 20:00:00 05/22/2011 20:30:00 05/22/2011 21:00:00 05/22/2011 21:30:00 05/22/2011 22:00:00 05/22/2011 22:30:00 05/22/2011 23:00:00 05/22/2011 23:30:00 Awaiting for your earliest reply best regards, John -- This e-mail message and any attachment hereto are confidential information intended for a specific addressee and purpose. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you may not disclose, copy, distribute or take any action based on the contents hereof, or retaining this message or any part of it, in any form whatsoever. Any such conduct is prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately by replying to this message and destroy all copies hereof. No opinion expressed by the sender necessarily constitutes the opinion of Mobile Telecommunications Ltd (MTC). This message does not constitute a guarantee or proof of the facts mentioned herein. No employee or intermediary is authorized to conclude a binding agreement on behalf of MTC by e-mail without the express written confirmation by a duly authorized representative of MTC. All reasonable precautions have been taken to ensure a virus free message however, MTC cannot guarantee this nor accept responsibility whatsoever for loss or damage arising from the use of this e-mail or attachments. MTC reserve the right to monitor all e-mail communications transmitted through our network. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel filter on time.xlsm Description: Binary data
Re: $$Excel-Macros$$ Pivot Items
can you attch the worksheet On Wed, May 25, 2011 at 11:55 AM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, Any help regarding this. Thanks!!!. Regards, Chandra Shekar B On Tue, May 24, 2011 at 6:37 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, How to extract data from a pivot item. In the example I need pivot items(1) data in the same worksheet. Thanks! With pvt_tbl pvt_tbl.PivotFields(Priority).PivotItems(1).Visible = True pvt_tbl.PivotFields(Priority).PivotItems(2).Visible = False pvt_tbl.PivotFields(Priority).PivotItems(3).Visible = False pvt_tbl.PivotFields(Priority).PivotItems(4).Visible = False End With -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$
its a function created copy it and paste it in module i have pasted unique names in sheet 2 in cell a2( sheet 2) =lookupall_val(A1,'STEPS with Dupes 156'!$A$2:$A$1505,1) a1= value to be searched STEPS with Dupes 156'!$A$2:$A$1505 ( is range having ids in col a * note dont select the whole column a only select the range having data and fix it with ($) ) 1 = col which needs to be combined suppose if ur description would have been in col c then it should have been 2 instead of 1 like col a =0 col b =1 col c =2 ' On Wed, May 25, 2011 at 9:09 PM, Carter, Jeannie jeannie.car...@chase.comwrote: All descriptions in the same cell *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Daniel *Sent:* Wednesday, May 25, 2011 11:39 AM *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ How does the result should display ? all descriptions in the same cell or each one in a cell ? *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *De la part de* Carter, Jeannie *Envoyé :* mercredi 25 mai 2011 16:14 *À :* excel-macros@googlegroups.com *Objet :* $$Excel-Macros$$ Need assistance with what might be either a formula or vba macro. In the attached you’ll see that some of the Loans #’s are duplicated, but the description is not. What I’m wanting to do is find a way to combine the multiple descriptions and only list the Loan # once. How can this be accomplished? Thanking you in advance! This transmission may contain information that is privileged, confidential, legally privileged, and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. Although this transmission and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by JPMorgan Chase Co., its subsidiaries and affiliates, as applicable, for any loss or damage arising in any way from its use. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel
Re: $$Excel-Macros$$ Macro to Enter Current Time and Date
try this Sub test() Range(B5029).Value = Now() End Sub On Tue, May 24, 2011 at 8:39 PM, John A. Smith johnasmit...@gmail.comwrote: Sub NOWENTRY() ' Please help with my macro to enter current time and date into any cell I choose. It always goes back to the cell in the macro and I want it to work for the current cell the cursor is sitting on when I hit Ctrl+n. My Macro: ' NOWENTRY Macro ' Enters current time and date ' ' Keyboard Shortcut: Ctrl+n ' Range(B5029).Select ActiveCell.FormulaR1C1 = =NOW() Range(B5029).Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub Thank you again for your help. John -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Seperate the data in proper fomat
try this Function companyname(x As String) Dim s As String For i = 1 To Len(x) If Asc(Mid(x, i, 1)) = 48 And Asc(Mid(x, i, 1)) = 57 Then Exit For Else s = s Mid(x, i, 1) End If Next i companyname = s End Function On Tue, May 24, 2011 at 6:07 PM, Deepak Rawat deepakexce...@gmail.comwrote: Hi Friends, I have to seperate the data in proper formatting, Pls suggest the best worksheet is attached. Regards, Deepak -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Simple VBA code for filter data in ascending
try this http://akoul.blogspot.com/search/label/Sort%20data%20in%20vba On Wed, May 25, 2011 at 4:16 AM, Bob bobandrich...@comcast.net wrote: Try this...with a command button, Change your range as needed, this one is A2:B1 Private Sub CommandButton2_Click() ActiveWorkbook.Worksheets(Your Worksheet Name).Sort.SortFields.Clear ActiveWorkbook.Worksheets(Your Worksheet Name).Sort.SortFields.Add Key _ :=Range(A2), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _ xlSortNormal With ActiveWorkbook.Worksheets(Your Worksheet Name).Sort .SetRange Range(A2:B1) .Header = xlNo .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With End Sub On May 24, 7:44 am, Deepak Rawat deepakexce...@gmail.com wrote: yes Sorting On Fri, May 20, 2011 at 5:41 PM, STDEV(i) setiyowati.d...@gmail.com wrote: do you mean SORTING ? Ascending / descending order are parameters of SORTING action not Filtering.. CMIIW On Fri, May 20, 2011 at 2:57 PM, Deepak Rawat deepakexce...@gmail.com wrote: Hi All I need the simplest VBA code to filter any data in ascending. Regards, Deepak -- ------ 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- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Update pivot table filters based on already applied filters?
can you email you file to excel-macros@googlegroups.com and attach the workbook On Mon, May 23, 2011 at 9:58 PM, Robert Jacobs robertjacob...@gmail.comwrote: Well after a bit of searching, it's looking like the Report filters are not dependent. No matter what you select in one report filter, every record is still listed in the other filters, even if they won't show any data when selected. Apparently there's no real way to do this, other than upgrading to Excel 2010 (for every person using this document) and deploying Slicer... Thanks for looking, but I guess this is impossible (wish it wasn't as it would be EXTRAORDINARALLY helpful) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Dynamic formula
can you attach the sample file On Fri, May 20, 2011 at 10:07 PM, Skanda skanda.pokkun...@gmail.com wrote: There are two data files say temp1_mon.xls and temp2_monyyy.xls.these two data files change everymonth i.e temp1.xls is always the current data month and temp2.xls is previous data month. here monyyy is displayed as APR2011 for current month and MAR2011 for previous month. There is a tab called MEMO in temp1_mon.cls where the cell reference(4,6) is calculated as: (sum of column 10 from minus sum of column 9 from current month file ) minus sum of column 10 from previous month file. So the file which is current month will become prior month for the next month run. Help me to make the formula dynamic. VB code can do this? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Macro for Converting txt to xls using Text Import Wizard
Sub delimit_txt_file() Dim s As Workbook Dim fNameAndPath As Variant fNameAndPath = Application.GetOpenFilename _ (FileFilter:=Text Files (*.txt), *.txt, _ Title:=Select File To Be Opened) Workbooks.OpenText Filename:=fNameAndPath, Origin:=xlWindows, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=False _ , Space:=False, Other:=True, OtherChar:=| Set s = ActiveWorkbook s.Sheets(1).Cells.Select s.Sheets(1).Cells.EntireColumn.AutoFit Dim i As Long For i = 2 To s.Sheets(1).Range(a1).End(xlDown).Row s.Sheets(1).Cells(i, 3).Value = Application.Trim(s.Sheets(1).Cells(i, 3).Value | s.Sheets(1).Cells(i, 4).Value) If Right(s.Sheets(1).Cells(i, 3).Value, 1) = | Then s.Sheets(1).Cells(i, 3).Value = Left(s.Sheets(1).Cells(i, 3).Value, Len(s.Sheets(1).Cells(i, 3).Value) - 1) End If If Left(s.Sheets(1).Cells(i, 3).Value, 1) = | Then s.Sheets(1).Cells(i, 3).Value = Right(s.Sheets(1).Cells(i, 3).Value, Len(s.Sheets(1).Cells(i, 3).Value) - 1) End If Next i s.Sheets(1).Columns(D:D).Delete Shift:=xlToLeft End Sub On Thu, May 19, 2011 at 8:59 PM, Susan 1 sunni...@gmail.com wrote: Hi Jsin - I've attached an example of the formatted spreadsheet and the raw data txt file, the macro or VB I need would automatically format the txt file into the spreadsheet style. Thanks for you help on this! On Thu, May 19, 2011 at 4:54 AM, JsinSk jsin...@gmail.com wrote: I can guess how you want it formatted, but is it possible for you to attach a sample excel sheet with the desired tabs/columns how you want it? On May 18, 3:31 pm, Susan 1 sunni...@gmail.com wrote: Hi ~ Wondering if you could assist me with the Text import wizard to configure the columns and tab delimiter for the attached txt file. And then send me the steps. I will be needing to do this every week to the same types of txt files, importing into Excel and I’d like to create a Macro for this but cannot figure out how to set the tab/columns. Thanks, Sunnie 2065409868_05-03-2011.txt 6KViewDownload -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Freeze/Unalterable Cells
its doing the same thing i guess can you check it On Wed, May 18, 2011 at 4:06 AM, Vinod Narayanan nvino...@gmail.com wrote: Hi Ashish, Thanks for your help... As i have explained in my previous mail, its a questionnaire and the cell should freeze the moment the answers is chosen / writtten The macro freezes the moment an answer for a single question is answered... but what i require is when a person answers a question(b3) the answer in C3 should only freeze... then when he answers a question (B4), the answer in C4 should only freeze.. so on.. Please help me On Tue, May 17, 2011 at 10:00 PM, ashish koul koul.ash...@gmail.comwrote: http://akoul.blogspot.com/search?q=protect Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 3 Then 'target.column =3 because column c is no 3 column 'you can change password ashish and choose your own ActiveSheet.Unprotect Password:=ashish If Not IsEmpty(Target.Value) Then Target.Locked = True End If ActiveSheet.Protect Password:=ashish Else: End If End Sub On Mon, May 16, 2011 at 1:04 AM, Vinod Narayanan nvino...@gmail.comwrote: Hi Team, Request you to help me creating an assessment sheet wherein the person taking the test, once chooses the option given in column C, the particular cell should freeze... If the question is given B3 cell and the corresponding answers in C3 (either drop down or need to key in ... depending upon the question) Sample sheet is attached... the movement the option is chosen by the person, the cell c3 should freeze and make it unalterable -- Thanks and Regards Vinod Narayanan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks and Regards Vinod Narayanan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Delete columns A thru D if blank
can you atatch the sample worksheet On Wed, May 18, 2011 at 2:31 AM, Bob bobandrich...@comcast.net wrote: I'm having a problem with, when the code runs, once I type something in cell A3 the formula is automatically copied down. Thats fine but it copies down each time I selcet a cell. I do not want any blanks. I can not just delete blank rows because there is something in columns F thru M. One blank row is fine. I just don't want it to keep inserting a formula each time a select change is made. Maybe.. something like A3:D if blank delete that section instead of entire row. Any help please. Here is what I have... Sub auto_open() ' Auto_Open Macro ' Macro recorded 05/17/11 by R.L.S. ThisWorkbook.Sheets(Worksheet2).OnEntry = ValidateCells End Sub Sub ValidateCells() Worksheets(Worksheet2).Range(D3).Formula = =if(C3=,,C3*B3) Worksheets(Worksheet2).Range(D3, Range(D65536).End(xlUp).Offset(1, 1)).FillDown Worksheets(Worksheet2).Range(E3).Formula = =if(B3=,, (B3*144*C3)) Worksheets(Worksheet2).Range(E3, Range(D65536).End(xlUp).Offset(1, 1)).FillDown End Sub -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Help with Budget - Formula
cell ( b3) =B2-SUMIF(C6:C65356,B1,D6:D65356) cell(c3)=C2-SUMIF(C6:C65356,C1,D6:D65356) On Wed, May 18, 2011 at 2:00 PM, Ashish Pradhan ashlyprad...@gmail.comwrote: Hello Guyscell Any help? Thanks Ashish Pradhan On 5/15/2011 10:52 PM, Ashish Pradhan wrote: Hello All Please see attached an excel file. I need a formula to automatically reduce the closing balance from the proper Funds wherever there are instances of the funds being utilised. The attached excel file will give more clarity. Please let me know if you need any more clarity. Thanks in advance. Ashish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Copy paste data for dynamic data_need Excel Macro Solution
send email to excel-macros@googlegroups.com and attach your workbook On Mon, May 16, 2011 at 12:08 PM, sagaraher sagara...@gmail.com wrote: How to upload a excel file??..kindly help On May 13, 7:29 pm, ashish koul koul.ash...@gmail.com wrote: can you attach the sample sheet On Thu, May 12, 2011 at 3:47 PM, sagaraher sagara...@gmail.com wrote: I have got following data in excel. I need to copy 1st number in given row for e.g. 122532 should be copied against 100 for 4 times similar way 321654 should be get copied against 200 for 3 time like way. ( Problem is that I'm not sure how many times 100 or 200 nos. comes ) kindly suggest me macro to run the same for very large data 122532 100 100 100 100 321654 200 200 200 654987 300 300 300 300 300 300 987654 100 100 789654 300 300 300 300 300 300 300 300 -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment.- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct
i have made changes in the data may be because of that can you attach the sample file back On Tue, May 17, 2011 at 12:06 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi Asish, Thanks for your reply, but I did'nt get the desired result i.e. in MAX, MIN AVG for first record should be 100, 50 avergage should be 87.5. Can we use sumproduct for all the formulas instead of array formulas. Thanks in advanc. Regards, Chandra Shekar B On Mon, May 16, 2011 at 9:15 PM, ashish koul koul.ash...@gmail.comwrote: try this On Mon, May 16, 2011 at 12:12 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, I want Min Max and Average by using Sumproduct. My problem is I want a formula which should be based on Date and Title as shown on Column D, E F and based on Column C I need Average, Min Max Values. If I confusing pls let me know. Thanks Chandra Shekar B -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Help Needed - Copy paste data for dynamic data_need Excel Macro Solution
Sub ests() Dim i As Long Dim j, s As Long For i = 1 To Sheets(1).Range(a65356).End(xlUp).Row If Sheets(1).Cells(i, 1).Value = Then j = i + 1 i = i + 2 End If If Sheets(1).Cells(i, 1).Value Then Sheets(2).Range(b65356).End(xlUp).Offset(1, 0).Value = Sheets(1).Cells(j, 1).Value End If Next i End Sub On Mon, May 16, 2011 at 1:48 PM, sagar aher sagara...@gmail.com wrote: I have got following data in excel. I need to copy 1st number in given row for e.g. 122532 should be copied against 100 for 4 times similar way 321654 should be get copied against 200 for 3 time like way. ( Problem is that I'm not sure how many times 100 or 200 nos. comes ) kindly suggest me macro to run the same for very large data plz find file where input result is shown..kindly suggest me macro solution thanks... -- Cheers Sagar Aher :) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Freeze/Unalterable Cells
http://akoul.blogspot.com/search?q=protect Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 3 Then 'target.column =3 because column c is no 3 column 'you can change password ashish and choose your own ActiveSheet.Unprotect Password:=ashish If Not IsEmpty(Target.Value) Then Target.Locked = True End If ActiveSheet.Protect Password:=ashish Else: End If End Sub On Mon, May 16, 2011 at 1:04 AM, Vinod Narayanan nvino...@gmail.com wrote: Hi Team, Request you to help me creating an assessment sheet wherein the person taking the test, once chooses the option given in column C, the particular cell should freeze... If the question is given B3 cell and the corresponding answers in C3 (either drop down or need to key in ... depending upon the question) Sample sheet is attached... the movement the option is chosen by the person, the cell c3 should freeze and make it unalterable -- Thanks and Regards Vinod Narayanan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Copy of Freeze Cells.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct
try this On Mon, May 16, 2011 at 12:12 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, I want Min Max and Average by using Sumproduct. My problem is I want a formula which should be based on Date and Title as shown on Column D, E F and based on Column C I need Average, Min Max Values. If I confusing pls let me know. Thanks Chandra Shekar B -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel MinMaxAverage_Sumproduct(2).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Formula required
try this link http://www.ozgrid.com/Excel/prevent-duplicates.htm http://www.mrexcel.com/articles/prevent-excel-duplicates.php On Mon, May 16, 2011 at 11:07 PM, vikram vikramahuj...@gmail.com wrote: Hi, Please help regarding formula for validation: If we enter any numeric value in particular column it does not allow a duplicate entry and shows error message. For example;if we enter 1 to 5 numeric value in particular column and try to enter 1 again or any value between already entered value it shows error message and does allow user to enter any value. Regards, Vikram Download: www.eType.com http://www.etype.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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ How to remove space in excel cell
= trim(a1) On Sun, May 15, 2011 at 11:18 AM, Prabhu prabhugate...@gmail.com wrote: Hi friends, How to remove spaces(bugs) in a particular cell either will be as prefix or suffix before or after number or text. 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Excel Macro Request!
try this http://www.contextures.com/xlDataEntry02.html Fill Blank Cells From Above http://www.contextures.com/Excel-Videos-Data-Entry.html#FillBlanks On Sun, May 15, 2011 at 11:34 AM, Prabhu prabhugate...@gmail.com wrote: Hi friends, I need a macro for a selected column to fill previous cell automatically where ever blank cell in the sheet.This Macro should copy the previous cell content.I.e. B2 has xxx B3 and B4 is blank means when we run the macro from B2 to B4 should show xxx. Request. Filling must be column wise not row wise. 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ converting COUNTIFS formula to macro
check the attachement see if it helps
On Sun, May 15, 2011 at 1:22 PM, gemmamckinley gmckin...@sky.com wrote:
Hi all
I am trying to add a countifs formula to a running macro, but so far I
have not had much success and wonder if anyone could help pleas. I have
posted my query on another website without reply, and I will make sure I
post this link on there so people are aware I have asked on more than one
website. I am sure it is something simple I am missing but it is starting to
get frustrating so need some help.
This is the formula I have set up, but as it is on many cells it is slowing
the workbook down.
[code]*
=COUNTIFS('g2 graded'!$G$1:$G$2, C2, 'g2 graded'!$D$1:$D$2, 1)
*[/code]
*
I tried this, which is similar to my countif formulas in the macro but it
doesnt work.*
[code]
*
Cells(x, 20).Value = Application.WorksheetFunction.CountIfs(Sheets(g2
graded).Range(g1:g3), Cells(x, 3), Sheets(g2
graded).Range(d1:d3), 1)
*[/code]
My full running macro is:
[code]
*
Sub UpdateValues()
Application.ScreenUpdating = False
Dim cell As Range
For x = 2 To 1 'loop through rows from row 2 to the last row
'If cell isn't blue then macro assumes it doesn't need to continue (because
it has reached the end of the blue cells)
If Cells(x, 18).Interior.ColorIndex 37 Then
End
Else
'insert value for column U (G2 Graded May).
'note that we don't calculate value for columns R S until last because they
depend on the calculated values of other columns
Cells(x, 21).Value = Application.WorksheetFunction.CountIf(Sheets(g2
graded).Range(G1:G1), Cells(x, 3).Value) 'x refers to the current row
in the loop and 21 is the column number
'insert value for column V (G2 Graded May).
Cells(x, 22).Value = Application.WorksheetFunction.SumIf(Sheets(g2
graded).Range(G1:G1), Cells(x, 3).Value, Sheets(g2
graded).Range(N1:N1))
'insert value for column W (G2 GradedTotal).
Cells(x, 23).Value = Application.WorksheetFunction.CountIf(Sheets(g2 graded
april ).Range(H1:H1), Cells(x, 3).Value) + Cells(x, 21).Value 'x
refers to the current row in the loop and 21 is the column number
'insert value for column X (G2 GradedTotal).
Cells(x, 24).Value = Application.WorksheetFunction.SumIf(Sheets(g2 graded
april ).Range(H1:H1), Cells(x, 3).Value, Sheets(g2 graded april
).Range(O1:O1)) + Cells(x, 22).Value
'insert value for column Z (G2 Claim May).
Cells(x, 26).Value = Application.WorksheetFunction.CountIf(Sheets(g2
claiming).Range(F1:F1), Cells(x, 3).Value)
'insert value for column AA (G2 Claim May).
Cells(x, 27).Value = Application.WorksheetFunction.SumIf(Sheets(g2
claiming).Range(F1:F1), Cells(x, 3).Value, Sheets(g2
claiming).Range(AA1:AA1))
'insert value for column AB (G2 Claim Total).
Cells(x, 28).Value = Application.WorksheetFunction.CountIf(Sheets(g2
claiming april).Range(G1:G1), Cells(x, 3).Value)
'insert value for column AC (G2 Claim Total).
Cells(x, 29).Value = Application.WorksheetFunction.SumIf(Sheets(g2 claiming
april).Range(G1:G1), Cells(x, 3).Value, Sheets(g2 claiming
april).Range(AB1:AB1))
'insert value for column R (Graded Total).
Cells(x, 18).Value = Cells(x, 23).Value + Cells(x, 28).Value
'insert value for column S (Claiming Total).
Cells(x, 19).Value = Cells(x, 24).Value + Cells(x, 29).Value
End If
Next
Application.ScreenUpdating = True
End Sub
*
[/code]
The webpage it is on is
http://www.excelforum.com/excel-worksheet-functions/776036-converting-countifs-formula-to-macro.html
Any help would be greatly appreciated.
Regards
Gemma
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com http://akoul.blogspot.com/
*akoul*.wordpress.com http://akoul.wordpress.com/
My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830
P Before printing, think about the environment.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post
Re: $$Excel-Macros$$ A macro to parse a wordlist in Excel
what in case of address which one it should pic absolute address access address On Fri, May 13, 2011 at 8:42 PM, Ivaylo ivanov.iva...@gmail.com wrote: Hi Ashish, Thank you very much for your efforts! Your macro is just what I needed. However, it seems that it doesn't handle the exceptions: === How to handle exceptions: If the consituent word doesn't have its own headword in the list, then the missing word must be copied in Sheet 2, column A and the phrase from which it comes from in column B - i.e. Sheet 2 must be list all the words which are part of a multiword phrases but don't have their own headwords. This is the case with abnormal termination. The word abnormal exists as a headword, and the phrase abnormal termination is copied in column B next to abnormal. However, the word termination doesn't exist in column A (as a headword), then termination must be copied to column A in Sheet 2 and the phrase abnormal termination to column B in Sheet 2 (next to termination). === Is it possible for you to add this functionality? On May 13, 4:26 pm, ashish koul koul.ash...@gmail.com wrote: try this code Sub tests() Dim i As Long Dim z As String For i = 1 To Sheets(1).Range(a65356).End(xlUp).Row If InStr(1, Application.WorksheetFunction.Trim(Cells(i, 1)), ) 0 Then Cells(i, 2) = Application.WorksheetFunction.Substitute(Application.WorksheetFunction.Trim(Cells(i, 1)), , |) End If Next i For i = 1 To Sheets(1).Range(a65356).End(xlUp).Row z = If InStr(1, Application.WorksheetFunction.Trim(Cells(i, 1)), ) = 0 Then For swa = 1 To Sheets(1).Range(a65356).End(xlUp).Row If swa i Then If InStr(1, Application.WorksheetFunction.Trim(Cells(swa, 1)), Application.WorksheetFunction.Trim(Cells(i, 1))) 0 Then z = z Application.WorksheetFunction.Trim(Cells(swa, 1)) | End If End If Next swa If Right(z, 1) = | Then Cells(i, 2) = Left(z, Len(z) - 1) Else Cells(i, 2) = z End If End If Next i End Sub On Wed, May 11, 2011 at 6:03 PM, Ivaylo ivanov.iva...@gmail.com wrote: Hi to all VBA gurus, I need help with an Excel macro which can do the following: I have a long list of dictionary headwords in column A (sorted alphabetically), something like this: abnormal termination abnormal abort about absolute absolute address absolute code accent access access address access mode access control access time address ... The list consists of single words and multiword phrases. My task is to put in column B reference to the single words that constitute the multiword phrases. For example, for abnormal termination column B must be populated with abnormal and termination, separated by |: abnormal termination abnormal|termination The second part of this task is that for the single-word headwords I must put references to their corresponding multiword phrases. For example, for absolute column B must be populated with absolute address and absolute code, separated by |: absolute absolute address|absolute code Here is a desired output after the processing: Column A - Column B abnormal - termination abnormal|termination abnormal - abnormal termination abort - about - absolute - absolute address|absolute code absolute address - absolute|address absolute code - absolute|code accent - access access - address|access mode|access control|access time access address - access|address access mode - access|mode access control - access|control access time - access|time address - absolute address|access address How to handle exceptions: If the consituent word doesn't have its own headword in the list, then the missing word must be copied in Sheet 2, column A and the phrase from which it comes from in column B - i.e. Sheet 2 must be list all the words which are part of a multiword phrases but don't have their own headwords. This is the case with abnormal termination. The word abnormal exists as a headword, and the phrase abnormal termination is copied in column B next to abnormal. However, the word termination doesn't exist in column A (as a headword), then termination must be copied to column A in Sheet 2 and the phrase abnormal termination to column B in Sheet 2 (next to termination). I'll be very grateful if anyone can help me writing such a macro. -- ------ 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
Re: $$Excel-Macros$$ Copy some files from a folder to another folder
use move to move files and copy to copy the files Public f As Object, d As Object Sub Main() Dim Fso As Object Set Fso = CreateObject(Scripting.FileSystemObject) Set RootFolder = Fso.GetFolder(C:\Documents and Settings\ashish\Desktop\ashish koul) FolderRead RootFolder End Sub Sub FolderRead(ByRef myFolder) Dim sw As Object Set sw = CreateObject(Scripting.FileSystemObject) For Each f In myFolder.Files Var = f.Path If Right(f.Name, 4) = .xls Or Right(f.Name, 5) = .xlsx Then sw.copyFile f.Path, C:\Documents and Settings\ashish\Desktop\excel\ 'sw.MoveFile f.Path, C:\Documents and Settings\ashish\Desktop\excel\ End If If Right(f.Name, 5) = .jpeg Then sw.copyFile f.Path, C:\Documents and Settings\ashish\Desktop\jpeg\ 'sw.MoveFile f.Path, C:\Documents and Settings\ashish\Desktop\jpeg\ End If If Right(f.Name, 4) = .pdf Then sw.copyFile f.Path, C:\Documents and Settings\ashish\Desktop\pdf\ 'sw.MoveFile f.Path, C:\Documents and Settings\ashish\Desktop\pdf\ End If Next f For Each d In myFolder.SubFolders FolderRead d Next d End Sub On Sat, May 14, 2011 at 7:15 AM, Rafael Bruno reservagra...@gmail.comwrote: Hi friends, I have a simple request that it's confusing me. I have a folder (let's call c:\motherfolder\), that has thousands of subfolders. In each subfolder there are 3 files: 1 .pdf, 1 excel (may be .xls or .xlsx), and 1 .jpeg. I need to copy all pdfs to one folder (let's say c:\pdfs_folder\), all excel files to another, and all jpegs to another. Can it be done? A long time ago (years) I remember doing something similar, but only with .xls files (and even this I can't remember how). Thanks in advance, Rafael WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Copy some files from a folder to another folder
use this one Public f As Object, d As Object, sw As Object Sub Main() Dim Fso As Object Set sw = CreateObject(Scripting.FileSystemObject) Set Fso = CreateObject(Scripting.FileSystemObject) Set RootFolder = Fso.GetFolder(C:\Documents and Settings\ashish\Desktop\ashish koul) FolderRead RootFolder End Sub Sub FolderRead(ByRef myFolder) For Each f In myFolder.Files Var = f.Path If Right(f.Name, 4) = .xls Or Right(f.Name, 5) = .xlsx Then sw.copyFile f.Path, C:\Documents and Settings\ashish\Desktop\excel\ 'sw.MoveFile f.Path, C:\Documents and Settings\ashish\Desktop\excel\ End If If Right(f.Name, 5) = .jpeg Then sw.copyFile f.Path, C:\Documents and Settings\ashish\Desktop\jpeg\ 'sw.MoveFile f.Path, C:\Documents and Settings\ashish\Desktop\jpeg\ End If If Right(f.Name, 4) = .pdf Then sw.copyFile f.Path, C:\Documents and Settings\ashish\Desktop\pdf\ 'sw.MoveFile f.Path, C:\Documents and Settings\ashish\Desktop\pdf\ End If Next f For Each d In myFolder.SubFolders FolderRead d Next d End Sub On Sat, May 14, 2011 at 12:19 PM, ashish koul koul.ash...@gmail.com wrote: use move to move files and copy to copy the files Public f As Object, d As Object Sub Main() Dim Fso As Object Set Fso = CreateObject(Scripting.FileSystemObject) Set RootFolder = Fso.GetFolder(C:\Documents and Settings\ashish\Desktop\ashish koul) FolderRead RootFolder End Sub Sub FolderRead(ByRef myFolder) Dim sw As Object Set sw = CreateObject(Scripting.FileSystemObject) For Each f In myFolder.Files Var = f.Path If Right(f.Name, 4) = .xls Or Right(f.Name, 5) = .xlsx Then sw.copyFile f.Path, C:\Documents and Settings\ashish\Desktop\excel\ 'sw.MoveFile f.Path, C:\Documents and Settings\ashish\Desktop\excel\ End If If Right(f.Name, 5) = .jpeg Then sw.copyFile f.Path, C:\Documents and Settings\ashish\Desktop\jpeg\ 'sw.MoveFile f.Path, C:\Documents and Settings\ashish\Desktop\jpeg\ End If If Right(f.Name, 4) = .pdf Then sw.copyFile f.Path, C:\Documents and Settings\ashish\Desktop\pdf\ 'sw.MoveFile f.Path, C:\Documents and Settings\ashish\Desktop\pdf\ End If Next f For Each d In myFolder.SubFolders FolderRead d Next d End Sub On Sat, May 14, 2011 at 7:15 AM, Rafael Bruno reservagra...@gmail.comwrote: Hi friends, I have a simple request that it's confusing me. I have a folder (let's call c:\motherfolder\), that has thousands of subfolders. In each subfolder there are 3 files: 1 .pdf, 1 excel (may be .xls or .xlsx), and 1 .jpeg. I need to copy all pdfs to one folder (let's say c:\pdfs_folder\), all excel files to another, and all jpegs to another. Can it be done? A long time ago (years) I remember doing something similar, but only with .xls files (and even this I can't remember how). Thanks in advance, Rafael WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Calculate Due dates
can you attach the sample sheet On Sat, May 14, 2011 at 6:20 PM, Mr excel excelkeec...@gmail.com wrote: Thanks ashish bhayya for that great formula.Upon drilling deep into the formula the result,i feel we are into the logical error.To make it clear, for Supplier A, if the transaction date is *12/05/2001*.the formula should return the previous month just like, *05-Apr'2011 TO 04-May'2011.Kindly update the formula. Thanks in advance. * On Thu, May 12, 2011 at 9:41 AM, Anil Bhange anil.bha...@tatacommunications.com wrote: I think Ashish is right use this, Still try with this “mmm'” Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mr excel *Sent:* Wednesday, May 11, 2011 8:37 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Calculate Due dates what i meant is instead of the period,the formula is showing as a result the formula should return only the month with the year. For example,*05-Apr-2011 TO 04-May-2011*. should return apr'2011. hope this is not confusing you...ashish... On Sat, May 7, 2011 at 1:25 PM, ashish koul koul.ash...@gmail.com wrote: change dd-mmm- to dd-mmm' in formula On Sat, May 7, 2011 at 7:47 AM, Mr excel excelkeec...@gmail.com wrote: dear ashish,, That is excellent great.Thanks a lot .The formula u provided is very nearer to the solution i wanted.everthing is same except in the month column of the sheet.Name of the month should be printed like April'2011 instead of *05-Apr-2011 TO 04-May-2011*. the above formula also is very helpful to me in another scenario.. Really my joy knew no boundaries.. On Fri, May 6, 2011 at 6:46 AM, ashish koul koul.ash...@gmail.com wrote: try this one On Thu, May 5, 2011 at 9:11 PM, ashish koul koul.ash...@gmail.com wrote: see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.com wrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier A will be billed in this period. Here in this example, there is only one transaction related to A and the billing is done for the month of jan'2011 so in the month column Jan'2011 should be displayed as this single transaction is done between 5th of Jan'2011-4th Feb'2011 Likewise for all the other suppliers… Hope I had made it clear. On Wed, May 4, 2011 at 9:57 PM, ashish koul koul.ash...@gmail.com wrote: can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.com wrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel WebRep Overall rating
Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 12 Messages in 8 Topics
text to column and select tab.. On Thu, May 12, 2011 at 5:12 PM, renuka chari jva.ch...@gmail.com wrote: hi to all thanks in advance here iam attaching one file i need like that but idont know how to do this can u help me any one Pl thanks regards On 12 May 2011 05:58, excel-macros+nore...@googlegroups.com wrote: Today's Topic Summary Group: http://groups.google.com/group/excel-macros/topics Please help to make my project good. [2 Updates] Calculate Due dates [2 Updates] [No Subject] [2 Updates] A macro to parse a wordlist in Excel [1 Update] .Refresh Background:-False [1 Update] Total of sum of Diff. criteria according to date [1 Update] How to start Excel-Macro [1 Update] Consolidate data [2 Updates] Topic: Please help to make my project good. karan 1237 karan1...@gmail.com May 11 03:51PM +0530 ^ Respected Sirs/Mam, I need your help making my project good. Please find attachment. I will be very obliged if someone can help me as earlier as possible. -- Basically I have to do more... STDEV(i) setiyowati.d...@gmail.com May 12 07:03AM +0700 ^ please check the attachment if it helps.. best regards, STDEV(i) note: we need dynamic* Max Value* of ScrollBar so we use Scroolbar from ActiveX Control, instead of from FORM. more... Topic: Calculate Due dates Mr excel excelkeec...@gmail.com May 11 08:37PM +0530 ^ what i meant is instead of the period,the formula is showing as a result the formula should return only the month with the year. For example,*05-Apr-2011 TO 04-May-2011*. should return apr'2011. more... Mr excel excelkeec...@gmail.com May 11 08:42PM +0530 ^ Got it ashish bhayya..thanks a lot.played with the formula and got the desired result.. Thanks a lot. more... Topic: [No Subject] Siraj Momin (BTG) smo...@ccc.ae May 11 01:27PM +0400 ^ Hi I have following code for filtering It works fine but the problem is in red font color code, this field is date field when I put this it gives wrong information May be because of more... jmothilal gjmothi...@gmail.com May 11 04:45PM +0530 ^ Dear Experts, I am typing Name and place name day 2 day different excel files, what is easy method i type these names and place names. -- J.Mohilal Universal Computer more... Topic: A macro to parse a wordlist in Excel Ivaylo ivanov.iva...@gmail.com May 11 05:33AM -0700 ^ Hi to all VBA gurus, I need help with an Excel macro which can do the following: I have a long list of dictionary headwords in column A (sorted alphabetically), something like this: more... Topic: .Refresh Background:-False Sobavia soba...@gmail.com May 11 01:09AM -0500 ^ Thanks Ashish. It helped Sent from my iPhone more... Topic: Total of sum of Diff. criteria according to date Rohan Young rohan.j...@gmail.com May 11 10:42AM +0530 ^ Thanks very much Ashish Ji Zafar Regds ROHAN more... Topic: How to start Excel-Macro pramod kumar kumar.pramod03i...@gmail.com May 11 10:38AM +0530 ^ Thanks for reply Sir... -- Regards, Pramod Kumar Technocare Solution(TCS) Rudrapur +91 9927033573 E-Mail:-kumar.pramod03i...@gmail.com more... Topic: Consolidate data ashish koul koul.ash...@gmail.com May 11 08:07AM +0530 ^ check the attachemnt see if it helps -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ more... ChilExcel chilexcel...@gmail.com May 10 05:54PM -0400 ^ Please see attached file By Chilexcel 2011/5/10 Rajesh K R rajeshkainikk...@gmail.com -- Visita ; http://sites.google.com/site/chilexcel/Home more... -- -- 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
Re: $$Excel-Macros$$ A macro to parse a wordlist in Excel
try this code Sub tests() Dim i As Long Dim z As String For i = 1 To Sheets(1).Range(a65356).End(xlUp).Row If InStr(1, Application.WorksheetFunction.Trim(Cells(i, 1)), ) 0 Then Cells(i, 2) = Application.WorksheetFunction.Substitute(Application.WorksheetFunction.Trim(Cells(i, 1)), , |) End If Next i For i = 1 To Sheets(1).Range(a65356).End(xlUp).Row z = If InStr(1, Application.WorksheetFunction.Trim(Cells(i, 1)), ) = 0 Then For swa = 1 To Sheets(1).Range(a65356).End(xlUp).Row If swa i Then If InStr(1, Application.WorksheetFunction.Trim(Cells(swa, 1)), Application.WorksheetFunction.Trim(Cells(i, 1))) 0 Then z = z Application.WorksheetFunction.Trim(Cells(swa, 1)) | End If End If Next swa If Right(z, 1) = | Then Cells(i, 2) = Left(z, Len(z) - 1) Else Cells(i, 2) = z End If End If Next i End Sub On Wed, May 11, 2011 at 6:03 PM, Ivaylo ivanov.iva...@gmail.com wrote: Hi to all VBA gurus, I need help with an Excel macro which can do the following: I have a long list of dictionary headwords in column A (sorted alphabetically), something like this: abnormal termination abnormal abort about absolute absolute address absolute code accent access access address access mode access control access time address ... The list consists of single words and multiword phrases. My task is to put in column B reference to the single words that constitute the multiword phrases. For example, for abnormal termination column B must be populated with abnormal and termination, separated by |: abnormal termination abnormal|termination The second part of this task is that for the single-word headwords I must put references to their corresponding multiword phrases. For example, for absolute column B must be populated with absolute address and absolute code, separated by |: absolute absolute address|absolute code Here is a desired output after the processing: Column A - Column B abnormal - termination abnormal|termination abnormal - abnormal termination abort - about - absolute - absolute address|absolute code absolute address - absolute|address absolute code - absolute|code accent - access access - address|access mode|access control|access time access address - access|address access mode - access|mode access control - access|control access time - access|time address - absolute address|access address How to handle exceptions: If the consituent word doesn't have its own headword in the list, then the missing word must be copied in Sheet 2, column A and the phrase from which it comes from in column B - i.e. Sheet 2 must be list all the words which are part of a multiword phrases but don't have their own headwords. This is the case with abnormal termination. The word abnormal exists as a headword, and the phrase abnormal termination is copied in column B next to abnormal. However, the word termination doesn't exist in column A (as a headword), then termination must be copied to column A in Sheet 2 and the phrase abnormal termination to column B in Sheet 2 (next to termination). I'll be very grateful if anyone can help me writing such a macro. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$
can you explain it bit more and attach the sample sheet On Wed, May 11, 2011 at 4:45 PM, jmothilal gjmothi...@gmail.com wrote: Dear Experts, I am typing Name and place name day 2 day different excel files, what is easy method i type these names and place names. -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Copy paste data for dynamic data_need Excel Macro Solution
can you attach the sample sheet On Thu, May 12, 2011 at 3:47 PM, sagaraher sagara...@gmail.com wrote: I have got following data in excel. I need to copy 1st number in given row for e.g. 122532 should be copied against 100 for 4 times similar way 321654 should be get copied against 200 for 3 time like way. ( Problem is that I'm not sure how many times 100 or 200 nos. comes ) kindly suggest me macro to run the same for very large data 122532 100 100 100 100 321654 200 200 200 654987 300 300 300 300 300 300 987654 100 100 789654 300 300 300 300 300 300 300 300 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ fixing Format of pivot table noit working
try this pivot pivot tutorial http://www.contextures.com/xlPivot11.html http://www.contextures.com/excel-vba-pivot-table-field-list.html You can also select the header and use find and replace option On Thu, May 12, 2011 at 4:11 PM, Jorge Marques leote.w...@gmail.com wrote: Hi guys is there anyway to format a pivot table and it´s stays that way whether i insert or take the options from and columns labels and row labels because when i change the design of the pivot it put´s everything back to standard like Sum of Jan instead of Jan like i what i tried to do with a macro on activesheet but i don´´t know how to assign the macro to the pivot, i have to change the name of the pivot in the macro!thank you very much in advance -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Excel Fourmla
Sub swa() Dim s For k = 1 To Sheets(1).Range(a65356).End(xlUp).Row s = For i = Len(Sheets(1).Cells(k, 1).Text) To 1 Step -1 If IsNumeric(Mid(Sheets(1).Cells(k, 1).Value, i, 1)) Then s = Mid(Sheets(1).Cells(k, 1).Value, i, 1) s Else Exit For End If Next i MsgBox s Sheets(1).Cells(k, 3).Value = s Next k End Sub On Fri, May 13, 2011 at 7:05 PM, Mishra, Kailash (GE Capital, Non-GE) kailash.mis...@ge.com wrote: Hi Experts, I have Consolidate Addresses along with PIN code in one column I need only the PIN the pin code in Next column Please confirm if any formula for this, Regards *Appointment Address* *PIN Code* 13/1, NS road, room no735, Martial street,kolkata-71 Opp.Bank of India.Shanti Park,Mira Road East flat no 13,ground floor,guru nanak market,infrt of national park,laajpat nagar,part 4,delhi 110024 97-A, pocket-B, mayur vihar, phase-II, delhi-110092 A-7, SIDDHI APARTMENT OPP.AMAR~APARTMENT OPERA SOCI., nava vikas road, PALDI ahm 380007 # 27/161, Pragatinagar~Naranpura ahm 380013 jp nagar 6 th phase near sindoora kalyana mantap sarakki signal Bangalore-560078 THE FOYER HOUSE NO.52, 2ND CRSS HUCCHINS RD , COX TOWN, BANGALORE #229, 9th A Main~vijayanagar, NEAR GOVT SCHOOL, BANGALORE-40 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Excel Fourmla
Sub swa() Dim s For k = 1 To Sheets(1).Range(a65356).End(xlUp).Row s = For i = Len(Sheets(1).Cells(k, 1).Text) To 1 Step -1 If IsNumeric(Mid(Sheets(1).Cells(k, 1).Value, i, 1)) Then s = Mid(Sheets(1).Cells(k, 1).Value, i, 1) s Else Exit For End If Next i MsgBox s Sheets(1).Cells(k, 3).Value = s Next k End Sub On Fri, May 13, 2011 at 7:05 PM, Mishra, Kailash (GE Capital, Non-GE) kailash.mis...@ge.com wrote: Hi Experts, I have Consolidate Addresses along with PIN code in one column I need only the PIN the pin code in Next column Please confirm if any formula for this, Regards *Appointment Address* *PIN Code* 13/1, NS road, room no735, Martial street,kolkata-71 Opp.Bank of India.Shanti Park,Mira Road East flat no 13,ground floor,guru nanak market,infrt of national park,laajpat nagar,part 4,delhi 110024 97-A, pocket-B, mayur vihar, phase-II, delhi-110092 A-7, SIDDHI APARTMENT OPP.AMAR~APARTMENT OPERA SOCI., nava vikas road, PALDI ahm 380007 # 27/161, Pragatinagar~Naranpura ahm 380013 jp nagar 6 th phase near sindoora kalyana mantap sarakki signal Bangalore-560078 THE FOYER HOUSE NO.52, 2ND CRSS HUCCHINS RD , COX TOWN, BANGALORE #229, 9th A Main~vijayanagar, NEAR GOVT SCHOOL, BANGALORE-40 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need macro help to copy paste each column data under one column
change sheet3 name as out and tun the macro Sub swa() Dim i, SW, swa As Long SW = Sheets(input).Range(A65356).End(xlUp).Row For i = 2 To Sheets(input).Range(b6).End(xlToRight).Column Sheets(input).Activate Sheets(input).Range(a8:a SW).Copy swa = Sheets(out).Range(b65356).End(xlUp).Row + 1 Sheets(out).Activate Sheets(out).Range( b swa).Select ActiveSheet.Paste Sheets(input).Activate Sheets(input).Range(Cells(8, i), Cells(SW, i)).Copy Sheets(out).Activate Sheets(out).Range( c swa).Select ActiveSheet.Paste Sheets(out).Activate Sheets(out).Range( a swa).Value = Sheets(input).Cells(6, i).Value Sheets(out).Range( a swa).Copy Sheets(out).Range(a swa :a Sheets(out).Range(b65356).End(xlUp).Row).Select ActiveSheet.Paste Next i End Sub On Mon, May 9, 2011 at 7:20 PM, Vinod vinu1sm...@gmail.com wrote: Hello Team, could you please help me with the below file. explained the problem in the attached file. Thanks, Vinod. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ $$Excel - Macros$$ Help me to Generate report in a button Click and sent to the Manager
http://akoul.blogspot.com/search/label/Sending%20a%20Range%20as%20attachment%20in%20mail%20though%20Excel%20VBA try this if it helps On Mon, May 9, 2011 at 9:20 AM, sreekanth m sreekanthm.namb...@gmail.comwrote: Dear All, I am attaching an Excel with some hypothetical data. Please help me to : - Take out the data by filtering the Managers name and paste it in a New Work Book. - Sent it to the respective managers E-Mail ID. - All the above actions should get done in a button Click. Awaiting for you valuable response. Bunch of Thanks in advance.! ThanksRegards, *Sreekanth M *Mobile:08420642256 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Consolidate data
check the attachemnt see if it helps On Wed, May 11, 2011 at 2:08 AM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi Experts Pls check the attached file and tell me how to consolidate date month wise. 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel CONSOLIDATE(1).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ .Refresh Background:-False
see if it helps CODE: With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ ODBC;DSN=PP;UID=ris;PWD=ri;DBQ=PP;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;MTS=F;MDI=F _ ), Array(;CSR=F;FWC=F;PFC=10;TLO=0;)), Destination:=Range(A1)) .CommandText = sql1 .Name = Query from PP .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = True .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .PreserveColumnInfo = True on error resume next .Refresh BackgroundQuery:=False End With On Fri, May 6, 2011 at 9:58 PM, Kojovi Aka soba...@gmail.com wrote: Forumers, I am having problems with *.Refresh Background:-False* statement in 2 different codes that I inherited and has been running successfully until today.I am using Excel 2007. Has anything changed with regards to the use of this statement? Please help. One of the codes is reproduced below. This code has been running fine as is until this morning. Thanks sobavia CODE: With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ ODBC;DSN=PP;UID=ris;PWD=ri;DBQ=PP;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;MTS=F;MDI=F _ ), Array(;CSR=F;FWC=F;PFC=10;TLO=0;)), Destination:=Range(A1)) .CommandText = sql1 .Name = Query from PP .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = True .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .PreserveColumnInfo = True .Refresh BackgroundQuery:=False End With -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ get name of months from date
=TEXT(a1,) On Sun, May 8, 2011 at 4:48 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi Experts If I want to get the name of month from dates 1/4/11- April 5/5/11 - May how I can I do it with a formula or code 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Calculate Due dates
change dd-mmm- to dd-mmm' in formula On Sat, May 7, 2011 at 7:47 AM, Mr excel excelkeec...@gmail.com wrote: dear ashish,, That is excellent great.Thanks a lot .The formula u provided is very nearer to the solution i wanted.everthing is same except in the month column of the sheet.Name of the month should be printed like April'2011 instead of *05-Apr-2011 TO 04-May-2011*. the above formula also is very helpful to me in another scenario.. Really my joy knew no boundaries.. On Fri, May 6, 2011 at 6:46 AM, ashish koul koul.ash...@gmail.com wrote: try this one On Thu, May 5, 2011 at 9:11 PM, ashish koul koul.ash...@gmail.comwrote: see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.com wrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier A will be billed in this period. Here in this example, there is only one transaction related to A and the billing is done for the month of jan'2011 so in the month column Jan'2011 should be displayed as this single transaction is done between 5th of Jan'2011-4th Feb'2011 Likewise for all the other suppliers… Hope I had made it clear. On Wed, May 4, 2011 at 9:57 PM, ashish koul koul.ash...@gmail.comwrote: can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.comwrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://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.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 WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel
Re: $$Excel-Macros$$ Please Help
try the attachment On Sat, May 7, 2011 at 2:20 PM, karan 1237 karan1...@gmail.com wrote: * LIST1* *LIST1* *LIST1* *RESULT* BACK SIDE FRONT BACK, SIDE, FRONT FRONT SIDE FRONT FRONT, SIDE BACK FRONT BACK BACK, FRONT FRONT FRONT FRONT FRONT *Hi Experts, I want like this. Please help. Thnx in Advance. * ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Help(1).xlsm Description: Binary data
Re: $$Excel-Macros$$ needed forumula
try this c58 = enter employee no t 58 =SUMPRODUCT(MAX(($C$8:$C$57=C58)*($T$8:$T$57))) u 58 =SUMPRODUCT(MAX(($C$8:$C$57=C58)*($U$8:$U$57))) On Thu, May 5, 2011 at 10:02 PM, sudarshan rampe sidhu...@gmail.com wrote: hello friends i need a formula in the excel sheet in the last two columns so that it would give the balance leave of a particular employee when i enter the employee no. of that person. Eg. if i enter 1061 in the cell C58 then i should get the last balance leave of that person i.e. 115 in T58 and 172 in U58 please see the attached sheet.(Please open the excel file in MS excel 2003 so that the List function works) sudarshan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ compile all excel file.
try this press alt +f11 goto tool - reference - Microsoft shell control and automation and paste below code and run it. select the folder in which files 1 and 2 are stored Function SelectFolder(Optional Title As String, Optional TopFolder _ As String) As String Dim objShell As New Shell32.Shell Dim objFolder As Shell32.Folder Set objFolder = objShell.BrowseForFolder _ (0, Title, 1, TopFolder) If Not objFolder Is Nothing Then SelectFolder = objFolder.Items.Item.Path End If End Function Sub merge_sheets_from_workbooks_to_single() ' tool - reference - Microsoft shell control and automation 'On Error GoTo Dim fldpth As String Dim fld, fil As Object Dim j, a As Long Dim ask, ask2 As Workbook Dim abc As Range fldpth = SelectFolder(Select Folder, ) Set fso = CreateObject(scripting.filesystemobject) Set fld = fso.getfolder(fldpth) Set ask = Workbooks.Add For Each fil In fld.Files If UCase(Right(fil.Path, 4)) = UCase(.xls) Or UCase(Right(fil.Path, 5)) = UCase(.xlsx) Then Set ask2 = Workbooks.Open(fil.Path) ask2.Activate ask2.Sheets(1).Select ask2.Sheets(1).Range(A1).Select ActiveCell.SpecialCells(xlLastCell).Select N = ActiveCell.Row - 1 If N = 2 Then Set abc = ask2.Sheets(1).Columns(a:A).Find(Page, LookIn:=xlValues) Rows(abc.Row + 1 : N).Select Selection.Copy ask.Activate ' change sheets(1) as per your requirement you can also write the name of sheet for example if sheet name is abc then write sheets(abc) ask.Sheets(1).Activate Sheets(1).Range(A1).Select ActiveCell.SpecialCells(xlLastCell).Select Z = ActiveCell.Row + 1 Range(A Z).Select ActiveSheet.Paste ask2.Activate ask2.Close End If End If Next fil ask.SaveAs ThisWorkbook.Path \ merge_data_file.xlsx ': Exit Sub End Sub On Wed, May 4, 2011 at 3:16 PM, Brajesh Kumar Porwal brajeshkumarpor...@gmail.com wrote: hi expert, please help me. I want to compile all excel file by Macro. find enclose example data. Regards, Brajesh Kumar Porwal 9250525089, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Copy Paste next blank row
send email to excel-macros@googlegroups.com and add the attachment On Fri, May 6, 2011 at 4:24 PM, Bob bobandrich...@comcast.net wrote: Were is it located to attach file? Sorry I don't see it. Thanks On May 6, 1:25 am, ashish koul koul.ash...@gmail.com wrote: can you share the sample file On Fri, May 6, 2011 at 5:22 AM, Bob bobandrich...@comcast.net wrote: I'm sorry , Still having trouble with copy on next available blank row. If I record a macro it's: Columns(A:E).Select Selection.Copy Sheets(Customer Record).Select ActiveSheet.Paste I want to keep what I have already copied. How do I make it go to the next available blank row. Thanks in Advance. -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment.- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ NEED HELP - GET PIVOT
try this (VLOOKUP(MAX(G:G),G:K,5,0)+VLOOKUP(MAX(G:G)-1,G:K,5,0)+VLOOKUP(MAX(G:G)-2,G:K,5,0))/3 On Fri, May 6, 2011 at 5:20 PM, mayur zinknax.zin...@gmail.com wrote: Hi All, I need help on get pivot formula for getting average of last three days score. Please find attached sheet, is more self explanatory. G:18 is expected result. Can somebody help on this. -- Thanks in advance. Mayur -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Macro to send email automatically.
see if it helps http://akoul.blogspot.com/search/label/Sending%20e%20mail%20based%20on%20data%20in%20column%20in%20excel%20using%20outlook On Fri, May 6, 2011 at 4:46 PM, rajan verma rajanverma1...@gmail.comwrote: See if It help,, Edit Macro According to your requirement.. Public Sentmag As String Sub SenDmail() Dim outLookApp As Object Set outLookApp = CreateObject(Outlook.application) Dim FileName As String Dim Data As Integer Dim Msg As String Dim mitem As Object Dim Sign As String Dim recp As String Dim msglp As Integer Dim sigLp As Integer Dim cell As Range For Each cell In Range(Range) Msg = Dear cell.Offset(0, 9).Value Msg = Msg vbCrLf Please find the below mention Complaint Which is showing open Status in DFR , At this site Temperaute is going above 35, _ I Request you to please repair this Ac , if it is not capable to maintaint temperatue then Please Provide the SME Certificate for further Action Msg = Msg vbCrLf Indus ID= cell.Offset(0, 2).Value Msg = Msg vbCrLf Complaint No = cell.Offset(0, 1) vbCrLf Site Name = cell.Offset(0, 3).Value vbCrLf Equipment =AC/ cell.Offset(0, 4).Value Msg = Msg vbCrLf Technician/SUpervisor Contact No = cell.Offset(0, 7).Text vbCrLf Complaint = cell.Offset(0, 8).Text Msg = Msg vbCrLf Regards vbCrLf Rajan Verma Set mitem = outLookApp.createitem(OlMailitem) With mitem .To = cell.Offset(0, 10).Text .Subject = AC problem of cell.Offset(0, 3).Text .Body = Msg End With mitem.Send Next outLookApp.Quit Set outLookApp = Nothing MsgBox Mail Has been Sent , vbInformation End Sub On Fri, May 6, 2011 at 4:07 PM, Jitheesh Vazhapully 7jit...@gmail.comwrote: Hello Experts, I'm looking for an macro to send an email on a specific date, We can run the macro daily and I want it to compare todays date with the deadline and in case it matches, the excel should shoot an email. I have mentioned the details in the excel sheet. Please advice if this is possible -- -- 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 Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ A small query, need your help in vba coding.
try this Private Sub CommandButton1_Click() Range(C1:D1).Select Selection.Copy Range(A65356).End(xlUp).Offset(1, 0).Select ActiveSheet.Paste Application.CutCopyMode = False End Sub On Sat, May 7, 2011 at 1:56 AM, Indrajit $nai talk2indra...@gmail.comwrote: Hi All, I have a little query in vba coding, please see the attached file. In the excel file there is a Save command button, whenever I press the button it will copy the data from cell no. c1:d1 and paste in the cell a1:b1, now my query is, if the data is already in the cell no. a1:b1 it will be saved in the next cell no. means a2:b2 then a3:b3 just going on like this, can anyone help me in that coding how do I create that loop? Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Calculate Due dates
see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.com wrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier A will be billed in this period. Here in this example, there is only one transaction related to A and the billing is done for the month of jan'2011 so in the month column Jan'2011 should be displayed as this single transaction is done between 5th of Jan'2011-4th Feb'2011 Likewise for all the other suppliers… Hope I had made it clear. On Wed, May 4, 2011 at 9:57 PM, ashish koul koul.ash...@gmail.com wrote: can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.com wrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel DATE Q.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ data merged
hi save all your daily files in a single folder and try code on below links. see if it helps http://akoul.blogspot.com/search/label/Merge%20Data%20from%20sheet%201%20from%20multiple%20workbooks%20to%20single%20workbook http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheet%20from%20multiple%20workbook%20to%20a%20workbook On Thu, May 5, 2011 at 9:27 AM, dannybrown2006 dannybrown2...@yahoo.comwrote: Hi, Me my colleagues are working on daily sheet (same file in a local network). Is there any way by end of the day me my colleagues click on update button all data are merged in one sheet i.e final sheet without open or manually copy paste. Regards Danny -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ data merged
or try this Sub sw() Application.ScreenUpdating = False Dim i As Long Dim s As Workbook Set s = Workbooks.Open(Application.GetOpenFilename) ThisWorkbook.Activate ThisWorkbook.Sheets(1).Rows(2: Sheets(1).Range(a1).End(xlDown).Row).Copy s.Activate s.Sheets(1).Range(a65356).End(xlUp).Offset(1, 0).Select ActiveSheet.Paste s.Save s.Close Application.ScreenUpdating = True End Sub select the master file when it asks for workbook On Thu, May 5, 2011 at 9:14 PM, ashish koul koul.ash...@gmail.com wrote: hi save all your daily files in a single folder and try code on below links. see if it helps http://akoul.blogspot.com/search/label/Merge%20Data%20from%20sheet%201%20from%20multiple%20workbooks%20to%20single%20workbook http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheet%20from%20multiple%20workbook%20to%20a%20workbook On Thu, May 5, 2011 at 9:27 AM, dannybrown2006 dannybrown2...@yahoo.comwrote: Hi, Me my colleagues are working on daily sheet (same file in a local network). Is there any way by end of the day me my colleagues click on update button all data are merged in one sheet i.e final sheet without open or manually copy paste. Regards Danny -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Calculate Due dates
try this one On Thu, May 5, 2011 at 9:11 PM, ashish koul koul.ash...@gmail.com wrote: see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.com wrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier A will be billed in this period. Here in this example, there is only one transaction related to A and the billing is done for the month of jan'2011 so in the month column Jan'2011 should be displayed as this single transaction is done between 5th of Jan'2011-4th Feb'2011 Likewise for all the other suppliers… Hope I had made it clear. On Wed, May 4, 2011 at 9:57 PM, ashish koul koul.ash...@gmail.comwrote: can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.com wrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel DATE_Q.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Copy Paste next blank row
can you share the sample file On Fri, May 6, 2011 at 5:22 AM, Bob bobandrich...@comcast.net wrote: I'm sorry , Still having trouble with copy on next available blank row. If I record a macro it's: Columns(A:E).Select Selection.Copy Sheets(Customer Record).Select ActiveSheet.Paste I want to keep what I have already copied. How do I make it go to the next available blank row. Thanks in Advance. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ excel 2003 or 2007???
Sub test() If Application.Version = 12.0 Then code for excel 2007 End If If Application.Version = 11.0 Then code for excel 2003 End If End Sub On Wed, May 4, 2011 at 4:32 PM, Pravin Kumar pravin.si...@gmail.com wrote: Hi is there any code that will allow me to run the first macros if the user is excel 2003... and the second if the user is excel 2007. regards Pravin -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Calculate Due dates
can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.com wrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ How to include new Rs font in Excel Currency format (option in format cell)
try this link http://blog.foradian.com/font-with-indian-rupee-symbol-download-and-us On Sat, Apr 30, 2011 at 4:22 PM, ankur ankurpande...@gmail.com wrote: hi rajan this font is not showing in excel font dialog box, can u help Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sat, Apr 30, 2011 at 9:12 AM, vaibhav joshi vaibhav...@gmail.com wrote: Hi Rajan I have dwnld the file ,but unable use the font.It is not coming Regards Vaibhav Joshi 91-9869069433 On Fri, Apr 29, 2011 at 1:05 PM, rajan verma rajanverma1...@gmail.com wrote: Add the attached Font File and use ' for Rs Font.. On Fri, Apr 29, 2011 at 12:27 PM, vaibhav joshi vaibhav...@gmail.com wrote: Hello everybody Can any one tell me how to insert New Rs font in currency format in excel. So that when ever i type any amt that should reflect also to ensure that i can use that cell for formula also Regards Vaibhav -- -- 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 Rajan verma +91 9158998701 -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Help Required!
try this macro Sub t() Dim i, j, k As Long For ww = 1 To Worksheets.Count Sheets(ww).Activate For j = 2 To Sheets(ww).Range(a1).End(xlDown).Row If Sheets(ww).Cells(j, 4).Value - DateSerial(Year(Now), Month(Now), Day(Now)) = 1 Then MsgBox Sheets(ww).Cells(j, 1).Value Will Expire in Abs(DateSerial(Year(Now), Month(Now), Day(Now)) - Sheets(ww).Cells(j, 4).Value) days End If Next j Next ww End Sub On Fri, Apr 29, 2011 at 9:04 AM, syed aliya raza hashim hashim...@gmail.com wrote: Hi Andred, see for example in sheet1 UPS 28-Apr-12 Battery 28-Jul-11 SMPS 2-Jan-11 then i want the meassage box should display message when we open the file --like ur UPS product will expire in 1 year 0r 365 days because it will calculate from today date so today is 28 april-2011 but for UPS date entry is 28-Apr-2012 so that means it will expire in 365 days same for Battery ur Battery product will expire after 3 month because today date is 28 april 2011 and battery entry date is 28 jul-2011 so that means it will expire after 3 month but for SMPS product no need to display because the date mention for SMS is 02-jan-2011 which is already expired on so if the above condition is there for all product in all sheet then i want to display the message box for all sheet if remaining date is there to expire from current date 2011/4/28 André D'Avila C Hello Syed, Let me understand... You have in Sheet1 - UPS, Battery and SMPS Sheet2 - Phone, Data Card, Lenser Sheet3 - Keyboard, Mouse and Monitor You want when the file open, a message like: Ur product UPS will expire in X days Ur product Battery will expire in X days Ur product SMPS will expire in X days Ur product Phone will expire in X days Ur product Data Card will expire in X days Ur product Lenser will expire in X days Ur product Keyboard will expire in X days Ur product Mouse will expire in X days Ur product Monitor will expire in X days Or Each time you open a sheet, for exemple sheet3 That automaticaly a message shows and display: Ur product Keyboard will expire in X days Ur product Mouse will expire in X days Ur product Monitor will expire in X days Best Regards André Luiz D´Avila 2011/4/28 syed aliya raza hashim hashim...@gmail.com Hi, Problem is stated in file itself , the problem is how to displaly the meassage box suppose date column is there is all sheets i want to display the meaasage like this product will be expired on one month or 30 days or more *when we open the file * see in the attachment -- syed aliya -- -- 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 -- syed aliya -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment
$$Excel-Macros$$ Re: Please Help.................
try this Private Sub CommandButton1_Click() ThisWorkbook.Windows(1).Visible = False UserForm1.Show End Sub On Wed, Apr 27, 2011 at 12:08 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Experts, How can Hide only workbook but userform should be visilble and work as it, when we click on *Eng In out Report* button. Please see attached sheet.. Thanks in Advance -- Thanks regards, Noorain Ansari -- Thanks regards, Noorain Ansari -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ RE: Multiple file Formatting
save all work in a directory and run the macro and choose taht directory Function SelectFolder(Optional Title As String, Optional TopFolder _ As String) As String Dim objShell As New Shell32.Shell Dim objFolder As Shell32.Folder Set objFolder = objShell.BrowseForFolder _ (0, Title, 1, TopFolder) If Not objFolder Is Nothing Then SelectFolder = objFolder.Items.Item.Path End If End Function Sub FORMATMULTIPLE() application.screenupdating = false ' tool - reference - Microsoft shell control and automation Dim fldpth As String Dim fld, fil As Object Dim j, a As Long Dim ask, ask2 As Workbook fldpth = SelectFolder(Select Folder, ) Set fso = CreateObject(scripting.filesystemobject) Set fld = fso.getfolder(fldpth) For Each fil In fld.Files Set ask2 = Workbooks.Open(fil.Path) ask2.Activate -- paste your code for activeworkbook here ask2.Close Next fil application.screenupdating = true End Sub On Wed, Apr 27, 2011 at 2:15 AM, Muni muni.r...@gmail.com wrote: Hi Srinivas, if all the files are under same folder than u can write an macro which opens each file automatically and then which runs your macro for formatting. You can use fso file object and then you can open each file in the folder using the for next where u can call ur macros Hope this might help. Please let me know if you need any further help on this On Tue, Apr 26, 2011 at 11:46 AM, Chidurala, Shrinivas shrinivas.chidur...@citi.com wrote: Please help. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com -Original Message- From: Chidurala, Shrinivas [ICG-GTS] Sent: Monday, April 25, 2011 9:10 PM To: excel-macros@googlegroups.com Subject: Multiple file Formatting Dear Gurus, I have created the attached macro for formatting of 50 to 60 files everyday which are receive from system. But to run this macro i need to open and then run. It taking too much time. Please can you advise to prepare the macro which will give facility do similar formatting of all files at a time, if i save all files in specific folder. Find attached sample file for your reference. Thanks in Advance Regards, Shrinivas -- -- 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 Muni -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Please Help
try this =B3/(RIGHT(C3,LEN(C3)-FIND(~,SUBSTITUTE(C3, ,~,LEN(C3)-LEN(SUBSTITUTE(C3, ,)*1) On Wed, Apr 27, 2011 at 7:32 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.com wrote: Dear Gurus, Please advise any formula to calculate the Book Value in given attachment. Thanks in Advance Regards, Shrinivas -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need Help urgent Please
Try ths code Private Sub Workbook_Open() Dim i, j, k As Long Dim SWA1, SWA2, SWA3 As String SWA1 = SWA2 = SWA3 = Sheets(UPS).Activate For j = 2 To Sheets(UPS).Range(a1).End(xlDown).Row If Sheets(UPS).Cells(j, 2).Value = DateSerial(Year(Now), Month(Now), Day(Now)) Then SWA1 = SWA1 vbNewLine Sheets(UPS).Cells(j, 1).Value End If Next j Sheets(Router).Activate For j = 2 To Sheets(Router).Range(a1).End(xlDown).Row If CDate(Sheets(Router).Cells(j, 2).Value) = DateSerial(Year(Now), Month(Now), Day(Now)) Then SWA2 = SWA2 vbNewLine Sheets(Router).Cells(j, 1).Value End If Next j Sheets(SMPS).Activate For j = 2 To Sheets(SMPS).Range(a1).End(xlDown).Row If CDate(Sheets(SMPS).Cells(j, 2).Value) = DateSerial(Year(Now), Month(Now), Day(Now)) Then SWA3 = SWA3 vbNewLine Sheets(SMPS).Cells(j, 1).Value End If Next j MsgBox UPS :- vbNewLine SWA1 vbNewLine vbNewLine Router :- vbNewLine SWA2 vbNewLine vbNewLine _ SMPS :- vbNewLine SWA3 Sheets(UPS).Activate End Sub -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 17 Messages in 11 Topics
press ctrl h in find what type *) replace with keep it blank press replace all On Tue, Apr 26, 2011 at 11:12 AM, renuka chari jva.ch...@gmail.com wrote: thanks to all here i am attaching one sheet here how to remove this kind of special characters help me plz -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel extra_chrs_removing_how(2).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ HELP SOS
see if this helps On Fri, Feb 18, 2011 at 4:03 PM, Surendra shindaro...@rediffmail.comwrote: HI Team, Please help. Regards, surendra Regards, Surendra Singh 9301334795 http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Show full screen for a particular workbook only.
check the attachment see if it helps On Sun, Apr 24, 2011 at 8:33 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi Paul, Thanks for the answer I checked the same idea before I sent the message, I give the fullscreen code when the work book open, but when I give the code for display screen normal when work book deactive it is not working as we think.that's why I posted it.Will u pls send attached sheet with the macro u mentioned.If so I can understand what is the fault I made. Regards Rajesh kainikkara On 4/21/11, Paul Schreiner schreiner_p...@att.net wrote: You really need to create two event macros. the workbook_activate event would go to full screen when you select the workbook, if you use a workbook_deactivate macro to change the displayfullscreen to false, it will revert to normal for when in any other workbook or window. Paul From: ChilExcel chilexcel...@gmail.com To: excel-macros@googlegroups.com Sent: Wed, April 20, 2011 12:43:36 PM Subject: Re: $$Excel-Macros$$ Show full screen for a particular workbook only. You need add ins ? 2011/4/20 rajan verma rajanverma1...@gmail.com make it add-ins On Fri, Apr 15, 2011 at 5:16 PM, Rajesh K R rajeshkainikk...@gmail.com wrote: Hi Experts, I gave the following code to get the full screen view, if it is only applicable to that particular workbook how can i change it. Private Sub Workbook_Open() Application.DisplayFullScreen = True End Sub 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 -- Regards Rajan verma +91 9158998701 -- -- 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 -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com
Re: $$Excel-Macros$$ Excel spell out word from number
press alt+ f11 to view or write a new macro http://www.techbookreport.com/tutorials/excel_vba1.html On Sat, Apr 23, 2011 at 6:09 PM, vikram vikramahuj...@gmail.com wrote: Hi, Please advice the way by which we can view such macros and add in our workbooks. As this function is showing in sheet attached but I am not able to get this add to new workbook. Kindly help in this regard. Regards, Vikram *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *jmothilal *Sent:* Saturday, April 23, 2011 12:03 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Excel spell out word from number Dear Friend here with i am attached fle macro file u add this. Thanks with Mothilal.j Vellore-2 On Wed, Apr 20, 2011 at 7:33 PM, Tony O tonyrulesy...@yahoo.com wrote: I have an Excel spreadsheet with a column of numbers. I would like each number to be spelled out, for example B1=4 C1=four B2=99 C2=ninety-nine. How would I go about this with a macro? -- -- 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 -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ help
see if it helps name:- =VLOOKUP(A25,A4:$C$8,2,0) lecture =VLOOKUP(VLOOKUP(A25,$A$3:$C$8,3,0),$A$13:$C$16,3,0) On Mon, Apr 25, 2011 at 6:36 PM, vijayajith VA vijayajith...@gmail.comwrote: hai Please see the attched exl file.. i need your help thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need Help
rohan try this =IF(ABS(C3-B3)=0.1,B3,C3) On Thu, Apr 21, 2011 at 1:49 PM, Rohan Young rohan.j...@gmail.com wrote: Dear Ashish, please sought it out my problem as attached thanks Rohan On Thu, Apr 21, 2011 at 12:02 PM, Rohan Young rohan.j...@gmail.comwrote: Dear rajan, i need output figure not blank cell thanks On Wed, Apr 20, 2011 at 3:46 PM, rajan verma rajanverma1...@gmail.comwrote: =IF((C3-B3)0.01,C3, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need macro code help regaring the pop up .
add application.displayalert = false at the beginning of code application.displayalert = true before end sub statement On Wed, Apr 20, 2011 at 4:02 PM, Bhushan Sabbani bsabban...@gmail.comwrote: Dear All, I have record a macro there i have delete the sheet. The code are as below Sheets(MNS Summary).Activate Sheets(MNS Summary).Delete but i am getting the pop up that data may exist . the option is delete and cancel. I have click on delete option again and again to select the selected file. I do not want the such pop up it should delete the file directly without any confirm or pop up. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ pls help
try this link http://www.contextures.com/xladvfilter01.html On Wed, Apr 20, 2011 at 4:35 PM, rohit gupta gupta1.ro...@gmail.com wrote: hiii, kindly let me know what are the benifits of ADVANCE FILER in Excel 2003. wating for reply... Thanks in advance... Regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Search Formula
paste the macro in worksheet change event . if your search criteria is in sheet 1 the paste the macro in Worksheet_Change even tof sheet 1 Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 3 And Target.Column = 5 Then ActiveSheet.Rows(6:65356).Clear Sheets(database).Activate If Sheets(database).FilterMode Then Sheets(database).ShowAllData End If Z = Sheets(database).Range(a1).End(xlDown).Row Sheets(database).Range($A$1:$c Z).AutoFilter Field:=1, Criteria1:=* Sheets(1).Range(e3).Value * Sheets(database).AutoFilter.Range.Copy Sheets(1).Range(d5) If Sheets(database).FilterMode Then Sheets(database).ShowAllData End If Sheets(1).Activate End If End Sub On Tue, Apr 19, 2011 at 11:12 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Thnaks Ashish. It is very useful but i am not getting desired output when i copy VBA code to my actual workbook.Please suggest Where i have to make change. Regards, C.G.Kumar On Mon, Apr 18, 2011 at 6:18 PM, ashish koul koul.ash...@gmail.comwrote: try this see if it helps On Mon, Apr 18, 2011 at 2:21 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Hello, I have a very tricky problem. I have got an excel sheet having some columns but more than 5000 rows. In those columns there are some names which may/may not be similar to each other. I want to make a macro which can: 1. Search for the name. e.g. If I have Katie Holmes in 1st row, Sherlock Holmes in 2nd row, Holmes Matt in 3rd row, James Holmes Dammon in 4th row and so onthen if put only Holmes in search criteria then it should get the result for all the 4 rows. 2. Secondly it should display only those 4 rows in the result. Like if we are using a sort function. Regards, C.G.Kumar -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ How to Separate Text and Nos in a sentence ?
see if it helps On Tue, Apr 19, 2011 at 7:14 PM, karan kanuga karankan...@gmail.com wrote: Hi, Can any1 pls let me know how do i separate the text and nos in a given sentence. PFA the sheet where i need to separate the nos and text. Thanks. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel extract_nos_from_text(1).xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Search Formula
try this see if it helps On Mon, Apr 18, 2011 at 2:21 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Hello, I have a very tricky problem. I have got an excel sheet having some columns but more than 5000 rows. In those columns there are some names which may/may not be similar to each other. I want to make a macro which can: 1. Search for the name. e.g. If I have Katie Holmes in 1st row, Sherlock Holmes in 2nd row, Holmes Matt in 3rd row, James Holmes Dammon in 4th row and so onthen if put only Holmes in search criteria then it should get the result for all the 4 rows. 2. Secondly it should display only those 4 rows in the result. Like if we are using a sort function. Regards, C.G.Kumar -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel search filter.xlsm Description: Binary data
Re: $$Excel-Macros$$ Deploying Excel 2003 updates
try these links http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm http://www.ozgrid.com/VBA/SpeedingUpVBACode.htm http://www.cpearson.com/excel/optimize.htm On Sun, Apr 17, 2011 at 2:48 PM, BJthebear brian.jerm...@gmail.com wrote: I have a spreadsheet with multiple macros and userforms running perfectly in Excel 2003 across 10 different sites with 10 different sets of information in the tables - but there are various improvements that have been requested and I was looking for some advice on redeploying a revised spreadsheet to each of the sites:- 1. Are there any links which would point me in the right direction 2. Is there a developers pack that makes this sort of thing easy - I am concerned about reformatting certain things in certain Worksheets - rewriting macros etc and ensuring that all the information is deployed correctly to all sites Any help and advice would be truly appreciated thanks Brian -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re:Data - text to date format
try this =SUBSTITUTE(B3,.,-)-SUBSTITUTE(A3,.,-) On Sun, Apr 17, 2011 at 5:41 PM, Mohd Sanusi Mohd Noor sanus...@gmail.comwrote: Dear all, Would like to seek your kind assistance/help on the date format. I've a data on date derive from SAP, when transfer to excel the date is in text format. Is there any way/method to change the dates from text to date format. Attached is the sample data for reference. The assistance on the above is highly appreciated. Tq Sanusi -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Open Excel addin is unavailable
try this link http://code.google.com/p/openexcel/downloads/detail?name=OPEN_XL.zipcan=2q On Sat, Apr 16, 2011 at 11:03 AM, OpenExcel.com 26may.1...@gmail.comwrote: Hi Bhushan, Files section has been removed from google groups. Go to http://www.openexcel.com and click on downloads. Here is the Direct Link to Download:http://openexcel.googlecode.com/files/OPEN_XL.zip http://openexcel.googlecode.com/files/OPEN_XL.zip Regards Ashish Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Macro Help in Excel 2007?
change Sheets(1) as per your requirement activesheet or Sheets( name of sheet) On Fri, Apr 15, 2011 at 11:57 PM, Prabhu prabhugate...@gmail.com wrote: Hi Ashish, Thanks, But when i run the macro i had an issue 1) It is woking only on the Sheet 1 only not other sheet 2) I want to use this code with other macro as a Continuation Plz help from which line i have to copy to my exising macro code. 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ how to copy all sheets data in one sheet by VBA
try this Sub method2() Dim i, j, k, s As Long s = Sheets.Count Sheets.Add After:=Sheets(Sheets.Count) For i = 1 To s Sheets(i).Select 'change upper row here in this case it will start copying from second row j = 2 ' it will copy till last used row automatically k = ActiveSheet.UsedRange.Rows.Count Rows(j : k).Copy Sheets(Sheets.Count).Select Sheets(Sheets.Count).Range(a65356).End(xlUp).Offset(1, 0).Select ActiveSheet.Paste Next i End Sub On Sat, Apr 16, 2011 at 3:24 PM, Yogesh Gohil yashr...@gmail.com wrote: Hi Experts, Please provide me the solution for this. Regards Gohil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ How to make excel addins
try this http://www.ozgrid.com/VBA/excel-add-in-create.htm or once you will save file as xlam in excel 2007 goto excel option goto addins- bottom you will find manage option choose excel addin and in browse slelect your addin and ok. and now in macro type your macroname(which will not be visisble) and click on run On Sat, Apr 16, 2011 at 3:55 PM, Prabhu prabhugate...@gmail.com wrote: Hi, Ok i have saved as Add In file on my add In folder, But now how to run the Add in file. It may be a basic question but really i don't know how to run the Add in file. Plz help. 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Open Excel addin is unavailable
http://code.google.com/p/openexcel/downloads/detail?name=OPEN_XL.zipcan=2q = On Fri, Apr 15, 2011 at 10:26 AM, ashish koul koul.ash...@gmail.com wrote: try this =SUBSTITUTE(B3,.,-)-SUBSTITUTE(A3,.,-) On Fri, Apr 15, 2011 at 8:34 AM, Mohd Sanusi Mohd Noor sanus...@gmail.com wrote: Dear all, Would like to seek your kind assistance/help on the date format. I've a data on date derive from SAP, when transfer to excel the date is in text format. Is there any way/method to change the dates from text to date format. Attached is the sample data for reference. The assistance on the above is highly appreciated. Tq Sanusi -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Macro Help in Excel 2007?
try this code assuming you have data in col a to col c and you want to delete all records with #n/a in col C Sub TEST() Application.Calculation = xlCalculationManual Application.ScreenUpdating = False If Sheets(1).FilterMode Then Sheets(1).ShowAllData End If Sheets(1).Range(A1:C Range(A1).End(xlDown).Row).AutoFilter Field:=3, Criteria1:=#N/A Sheets(1).Range(A2:C Range(A1).End(xlDown).Row).SpecialCells(xlCellTypeVisible).EntireRow.Delete If Sheets(1).FilterMode Then Sheets(1).ShowAllData End If Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True End Sub On Fri, Apr 15, 2011 at 3:59 PM, Prabhu prabhugate...@gmail.com wrote: Macro Help in Excel 2007? I want to delete particular rows only in my work sheet which contains #N/A in a particular column? Assuming the column containing the #N/A errors is column A, and i need to delete the entire row where '#N/A' if found in column A. Plz help with macro code which should delete enter #N/A at one time not line by line. 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Problem in pivot table
its because its showing subtotals . hide them thats it . keep the cursor on vgood right click and unselect subtotal ,same for good etc. On Fri, Apr 15, 2011 at 11:32 PM, alisha malhotra alisha.malhotr...@gmail.com wrote: Hi Ashish, I have made the pivot table using the layout as yours layout. But my pivot is little bit complicated.Why is that so happening?. Why did you use employee code in data instead of count of poor or count of avg etc.? I am sending you the attachment. Regards, Alisha On Fri, Apr 15, 2011 at 10:27 AM, ashish koul koul.ash...@gmail.comwrote: see if it helps On Thu, Apr 14, 2011 at 9:29 PM, alisha malhotra alisha.malhotr...@gmail.com wrote: Hi, I want to create one pivot table. In this, *I want to calculate the number of employees in Poor, Avg, good, and very good.* But it is showing the same no. of employees in each category that is wrong. I am sending you the file as attachment. Please help me in creating the pivot table. *Please tell me how to use formula in pivot table also*. Waiting for your reply. Thanks Regards, Alisha -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Open Excel addin is unavailable
try this =SUBSTITUTE(B3,.,-)-SUBSTITUTE(A3,.,-) On Fri, Apr 15, 2011 at 8:34 AM, Mohd Sanusi Mohd Noor sanus...@gmail.comwrote: Dear all, Would like to seek your kind assistance/help on the date format. I've a data on date derive from SAP, when transfer to excel the date is in text format. Is there any way/method to change the dates from text to date format. Attached is the sample data for reference. The assistance on the above is highly appreciated. Tq Sanusi -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Problem in pivot table
see if it helps On Thu, Apr 14, 2011 at 9:29 PM, alisha malhotra alisha.malhotr...@gmail.com wrote: Hi, I want to create one pivot table. In this, *I want to calculate the number of employees in Poor, Avg, good, and very good.* But it is showing the same no. of employees in each category that is wrong. I am sending you the file as attachment. Please help me in creating the pivot table. *Please tell me how to use formula in pivot table also*. Waiting for your reply. Thanks Regards, Alisha -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Book1.xls Description: MS-Excel spreadsheet
