Fwd: $$Excel-Macros$$ formula required to update values form one sheet to another sheet with date criteria

2013-07-20 Thread Pravin Gunjal
Dear Lerner Not Understood.. Because it's getting updated in the file sent by me. Regards Pravin Gunjal. -- Forwarded message -- From: excel lerner exceller...@gmail.com Date: Sat, Jul 20, 2013 at 10:15 AM Subject: Re: $$Excel-Macros$$ formula required to update values form one

Re: $$Excel-Macros$$ Re: Whole Sheet is Hidden, But actually not Hidden!

2013-07-20 Thread P.VIJAYKUMAR
Respected Paul, Lot of Sheets and formulas and queries within them do slow excel considerably.Set no the processors to all in advanced tab of excel options.this may improve your condition a little bit.But if you want to improve the situation you have to increase the processor spy eed and also

Re: $$Excel-Macros$$ Running numbers

2013-07-20 Thread ashish koul
you have to remove prtsafe. visit below link to know more http://msdn.microsoft.com/en-us/library/office/ee691831(v=office.14).aspx http://msdn.microsoft.com/en-us/library/office/gg278832.aspx On Fri, Jul 19, 2013 at 8:09 PM, Rajan sharma rajansharma9...@gmail.comwrote: eliminate the

Re: $$Excel-Macros$$ Export Excel Data Into Outlook email template

2013-07-20 Thread ashish koul
you can try word mail merge On Sat, Jul 20, 2013 at 5:59 AM, dynamitekicker dynamitekic...@gmail.comwrote: Hi all, Hi all newbie over here attempting to learn macros. I am currently trying to convert information from an Excel document into an Outlook email template. I have attached an

Re: $$Excel-Macros$$ To SUM Dynamic Columns

2013-07-20 Thread Waseem Saifi
Dear Excel_Lover, PFA your query file with solved formula. Regards, Waseem Saifi On 7/19/13, Excel_Lover idforex...@gmail.com wrote: Dear All, Attached is a sample data in which I have some month wise item total, I need a formula which can calculate SUM of an item from the Month Jan-12 to

RE: $$Excel-Macros$$ Deleting Blank Rows

2013-07-20 Thread Amit Desai (MERU)
Dear Vijay, Thanks a lot for your help. How shall I add the addin is the file extension correct? Best Regards, Amit Desai Mobile:- +91 98672 32534 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of P.VIJAYKUMAR Sent: 20 July 2013 13:20 To:

Re: $$Excel-Macros$$ Whole Sheet is Hidden, But actually not Hidden!

2013-07-20 Thread Waseem Saifi
Dear Experts, thank you so much for all your views. I got lot of Experience and guidance from your post on this mail. again thank you so much ! Regards, Waseem Saifi On 7/19/13, Paul Schreiner schreiner_p...@att.net wrote: I've encountered similar issues before. It seems to be a

RE: $$Excel-Macros$$ Deleting Blank Rows

2013-07-20 Thread Amit Desai (MERU)
Thanks a lot... Best Regards, Amit Desai Mobile:- +91 98672 32534 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of P.VIJAYKUMAR Sent: 20 July 2013 17:12 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Deleting Blank Rows Respected Amit ,

Re: $$Excel-Macros$$ To SUM Dynamic Columns

2013-07-20 Thread Waseem Saifi
Dear Excel_Lover, it is exactly in attachment you are asking for. Regards, Waseem Saifi On Sat, Jul 20, 2013 at 2:12 PM, Waseem Saifi waseemsa...@gmail.com wrote: Dear Excel_Lover, PFA your query file with solved formula. Regards, Waseem Saifi On 7/19/13, Excel_Lover

Re: $$Excel-Macros$$ Need Ramp up Plan Template.

2013-07-20 Thread Prabhu Pinky
Thanks a lot Vijay. Thanks Regards, Prabhu R On 20 July 2013 13:34, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Repected Prabhu, Please find the attached templates. Regards, Vijaykumar On Sat, Jul 20, 2013 at 8:06 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi Experts, if

Re: $$Excel-Macros$$ Export Excel Data Into Outlook email template

2013-07-20 Thread dynamitekicker
Thanks Ashish! Word mail merge is a satisfactory solution, but ultimately I would still need to insert fields for the date and several other fields. I'm looking for something that is automated with a single click and requires essentially no editing before sending. Thanks again. On Saturday,

$$Excel-Macros$$ Please help

2013-07-20 Thread Sanjay Kumar Maurya
Hi All, I have attached a file in this email. This is record of incidents that's updated on daily basis. and i required the last date incidents count. I have done pivot automatic and getting the problem to select the last date automatic. Please me to select the date automatic. -- ***Thanks

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-20 Thread Prabhu Pinky
hi priti, very nice formula.. very useful. thank you. Thanks Regards, Prabhu R On 16 July 2013 14:57, priti verma pritiverma1...@gmail.com wrote: PFA On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E emuralidha...@gmail.comwrote: Dear Friends good afternoon, I need help reg. lookup

Re: $$Excel-Macros$$ Please help

2013-07-20 Thread Santy
Hi, Please find attached solution Hope its fulfill ur requirement *Thanks Regards,* *Santy* On Sat, Jul 20, 2013 at 7:38 PM, Sanjay Kumar Maurya mail2sanja...@gmail.com wrote: Hi All, I have attached a file in this email. This is record of incidents that's updated on daily basis.

$$Excel-Macros$$ Need your help

2013-07-20 Thread Sanjay Kumar Maurya
Hi All, I want to join this group. -- ***Thanks Sanjay Kumar Maurya* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate

Re: $$Excel-Macros$$ Index Match Not working in VBA

2013-07-20 Thread respuzy
Hello Experts Pls can someone assist on ♍Ɣ request below. If ♍Ɣ requirement explanation Ȋ̝̊̅§ not properly understood pls let me know. Cheers Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Hilary Lomotey resp...@gmail.com Sender:

$$Excel-Macros$$ Indirect Function syntax

2013-07-20 Thread MLT
I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF?

$$Excel-Macros$$ Indirect Function syntax

2013-07-20 Thread MLT
I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF?

$$Excel-Macros$$ Indirect Function syntax

2013-07-20 Thread MLT
I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF?

$$Excel-Macros$$ Indirect Function syntax

2013-07-20 Thread MLT
I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF?

$$Excel-Macros$$ Indirect Function syntax

2013-07-20 Thread MLT
I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF?

Re: $$Excel-Macros$$ Indirect Function syntax

2013-07-20 Thread Ms Excel user
Hi MLT, Use this =SUM(INDIRECT(A1:A3)) ** * Best Regards, Ms Excel User * ** On Sun, Jul 21, 2013 at 12:37 AM, MLT mlthorn...@gmail.com wrote: I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum

$$Excel-Macros$$ Indirect Function syntax

2013-07-20 Thread MLT
cool thanks. can that same syntax be used for vlookup? for example: =VLOOKUP(INDIRECT(A1,B1:C3,2,FALSE)) -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Indirect Function syntax

2013-07-20 Thread Ms Excel user
Hi, Use this =VLOOKUP(INDIRECT(A1),B1:C3,2,FALSE) ** * Best Regards, Ms Excel User * ** On Sun, Jul 21, 2013 at 1:08 AM, MLT mlthorn...@gmail.com wrote: cool thanks. can that same syntax be used for vlookup? for example: =VLOOKUP(INDIRECT(A1,B1:C3,2,FALSE)) -- Are

$$Excel-Macros$$ Indirect Function syntax

2013-07-20 Thread MLT
I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF?

$$Excel-Macros$$ indirect function syntax

2013-07-20 Thread MLT
I'm trying to figure out the syntax to use a function within the Indirect function. I would like to do something like this but am getting a #REF error: =INDIRECT(SUM(A1:A3)) Where am I going wrong? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Export Excel Data Into Outlook email template

2013-07-20 Thread dynamitekicker
Hi all, Hi all newbie over here attempting to learn macros. I am currently trying to convert information from an Excel document into an Outlook email template. I have attached an Excel file with representative data. When sending off a job summary I want to just be able to run a macro on a

Re: $$Excel-Macros$$ indirect function syntax

2013-07-20 Thread xlstime
. Enjoy Team XLS On Sun, Jul 21, 2013 at 12:54 AM, MLT mlthorn...@gmail.com wrote: I'm trying to figure out the syntax to use a function within the Indirect function. I would like to do something like this but am getting a #REF error: =INDIRECT(SUM(A1:A3))

Re: $$Excel-Macros$$ Deleting Blank Rows

2013-07-20 Thread Prafull Jadhav
Dear Amit Sir, you can do it by filter data. 1 go at end of row where data is end then last row and select all till top (down to up) 2 filter on it then you will get blank data ...you can remove it easy. Regards, prafull 9920553518 On Sat, Jul 20, 2013 at 6:02 PM, Amit Desai (MERU)