Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months
Hi Kalyan You can use pivot table to solve this , better than use many excel function Worawat 2010/10/8, Kal xcel kalx...@gmail.com: Dear Experts, I want to extract last 3 months consolidated sale data based on current month. I have attached the file with my query. 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- Moo Moo' I have much time for give 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ How to increase size and color of text in user form ?
Dear Krisha , Thank you very much. Worawat 2010/7/2 krishna mummina lovemekris...@gmail.com CLICK ON THE TEXT, YOU WILL GET THE PROPERTIES OR ELSE, RIGHT CLICK ON THAT AND PROPERTIES, THERE YOU WILL FIND WHAT YOU WANT. On 7/2/10, worawat kh worawat...@gmail.com wrote: Dear Group , How to increase size and color of text in user form ? Thanks, Worawat -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Moo Moo' MyBlog http://ExcelBeginner.BlogSpot.Com Excel Tip http://MySTTAtrtip.BlogSpot.Com My trip picture -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ How to increase size and color of text in user form ?
Dear Group , How to increase size and color of text in user form ? Thanks, Worawat -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ plz help me Its Urgent
Dear Anil, MS word did not have pivot table function , but you can use them by insert excel object and use pivot table same as Excel. 2010/6/23 Anil Saxena anilsaxena170...@gmail.com Dear Sir / Mam, Do the create the excel pivot table in to MS world without copy past and show the example ? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Moo Moo' MyBlog http://ExcelBeginner.BlogSpot.Com Excel Tip http://MySTTAtrtip.BlogSpot.Com My trip picture -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Need Help
Hi , You just copy on range a1:a4 and click on other blank cell then right click and select paste special , select value and transpose it can arrange series as you want. pls note that it can not paste on cell a1 because it was same cell that be copied. Hope it can help you. Worawat 2010/4/28 balbirkumar . balbirku...@sify.com Dear Friends, I want to arrange the series of data in a coloum to series of row. For example Data is available in the following Format: A B C D 1 Cat 2 Rat 3 Dog 4 Lion 5 Want to arrange the data as : A B C D 1 Cat Rat Dog Lion 2 3 4 5 Please advice friends. Thanks in Advance. -- Balbir Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Moo Moo' MyBlog http://ExcelBeginner.BlogSpot.Com Excel Tip http://MySTTAtrtip.BlogSpot.Com My trip picture -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Help......................
Hi Rasheed , You have to go to toolbar Tool --- Option --- Calculation and select Automatic . may be can help Worawat ~ Blog ~ 1 http://excelbeginner.blogspot.com ~ Blog ~ 2 http://sttamytrip.blogspot.com 2010/3/31 Abdul Rasheed rashee...@gmail.com hi fellows i hit a prob in excel sheet ... on change of figures, formula does not updated automatically.. i have to get in the cell by pressing F2 and then enter... its so pathetic... n wanna permanent solution. is there any1 to help me out. regards -- Regards, Abdul Rasheed Confidence never comes if we have all the answers, Be ready for all the questions... .Be bold to face the world -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Moo Moo' MyBlog http://ExcelBeginner.BlogSpot.Com Excel Tip http://MySTTAtrtip.BlogSpot.Com My trip picture -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ Finding a diff b/w two time
Hi Harpreet Gujral In cell c1 you can use formula like this =IF(A1-B10,(A1-B1)*-1,A1-B1) then select in format cell Time - Select hours (should be 37:30:55) and D1 you have to put some trick to remind you that result will delay or still have time ==IF(A2-B20,Delay(Hrs),Have time(Hrs)) Simple way may can help you. Worawat MyBlog! http://excelbeginner.blogspot.com 2010/3/6 Harpreet Singh Gujral harpreetguj...@gmail.com Hi Group, I have the following question: I have two cells, both have the following formating. DD/MM/ HH:MM. Suppose, CellA1 has time 11/12/2009 09:00 while cell B1 has the following value 11/12/2009 10:00. Can we find a diff in cell C1. The actual difference would be 1hr. Actually, what i am looking at is, Cell A1 consists of my deadline, while Cell B1 consists of the actuall time. All i want to know is that, what was the time which it got delayed. Thanks Harpreet Gujral -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Need to grab a word from a string
*Hi Mike, Simple function like this 12 Roosevelt Ave* * =RIGHT(A1,14)* * =LEFT(A1,2)* 12 Roosevelt Ave Roosevelt Ave 12 Hope it can help Worawat 2010/2/25 Mike foehamme...@yahoo.com Hi folks, Looking for a function(if it exists) that will grab the first letter in a string and put it in another cell. For example: '12 Roosevelt Ave.' Some function that will grab the '12' and put it in another cell, with the original cell left over with just 'Roosevelt Ave.' I don't know how easy/hard this would be but any help would be appreciated. TIA, Mike -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Cash Statement :Need help
Dear K.Sri, I just learning for macro but may can help you Please try Sub Macro1() Range(R4).Select ActiveCell.FormulaR1C1 = =IF(RC[-4]=debit,RC[-7],) Range(S4).Select ActiveCell.FormulaR1C1 = =IF(RC[-5]=credit,RC[-8],) Range(R4:S4).Select Selection.Copy Application.CutCopyMode = False Selection.AutoFill Destination:=Range(R4:S105) Range(R4:S105).Select Columns(R:S).Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False Range(R4).Select End Sub or you can try to use if function for easy to understand like this cell in column R =IF(N4=debit,K4,) cell in column S =IF(N4=credit,K4,) then copy to cell that you want the result. Hope it can help you. Worawat 2010/2/1 Sri Jai jaisri1...@gmail.com Dear All, Can someone please help me on the attached? On column K are the amounts and on column N it reflects debit and credit. I want to run a macro which reflects (the data in Columns kN)to reflect like the way i have indicated in column R S on the attached splitting the debit and credit amountsplease help Thanks a ton for the help Sri -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Macro Pivotable
?Hi Anill , Sorry for late reply , below is macro code record. Range(C8).Select With ActiveSheet.PivotTables(PivotTable1).PivotFields(Transaction Type) .PivotItems(Accept).Visible = False .PivotItems(Return to Receiving).Visible = False .PivotItems(Return to Supplier).Visible = False .PivotItems((blank)).Visible = False End With I have pivotitem 6 item are accept , return to receiving , return to supplier , blank , receive , delivery when I refresh data macor was not work coz pivotitem had less than 6 items. some time will no blank item or no return item actually I need data only 2 pivotitem are receive and delivery.I don't know how to set only receive and delivery item. Thanks, WKH8919 2010/1/20 Anil anilkuma...@target.com Hi WKH8919, I would like to see the recorded macro code. Regars, Anil On Jan 20, 2:52 pm, WKH8919 worawat...@gmail.com wrote: Hi I just start to learn about macro and need expert to advise. Now I have pivotable and I record macro that will select 2 pivotItems from pivotfields but some time pivotfields will container different number of pivotItem then when i run macro it's not work , I don't know why ? May some one help me ? Sorry for my english not good. Thanks WKH8919 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe