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

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

$$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 :

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

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

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

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

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

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

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