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

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 > 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 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 : http://twitter.com/exceldailytip

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 > Dear Sir / Mam, > > > Do the create the excel pivot table in to MS world without copy past and > show the example ? > > -- > > --

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 ~ Blog ~ 2 2010/3/31 Abdul Rasheed > hi fellows > i hit a prob in excel sheet ... on cha

Re: $$Excel-Macros$$ Delete row if the next row is same

Hi mono You can use pivot table by set e-mail to row and select data to count then you can copy only single e-mail that you wanted. *or * using simple macro mixed with pivo table like this 1. first you have to put you list in column A 2. Run macro as below code Sub DeleteDuplicate() Range

Re: $$Excel-Macros$$ Finding a diff b/w two time

Hi Harpreet Gujral In cell c1 you can use formula like this =IF(A1-B1<0,(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-B2<0,"Delay(Hrs)","Have ti

Re: $$Excel-Macros$$ copy cell from source to target - not by advancefilter

Can y attached file for more clear ? Worawat Excelbeginner 2010/3/2 OSAVentures Calamba > Hi All, Basically i have a list of dates and numbers. > > What i want to do is to copy each numbers from source worksheet based on > the criteria date which is located

Re: $$Excel-Macros$$ Macro web query based on selection list

Hi Tom, May be below link will help you. It easy to get web query by existing menu. *http://www.exceluser.com/explore/webqueries_1.htm* Good luck Worawat Excelbeginner 2010/3/2 birkepab > I have a huge request. How to write a macro to retrieve data from a >

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 > Hi folks, > Looking for a function(if it exists) that will grab the first letter > in a string and put it in another

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 Selec

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