Re: $$Excel-Macros$$ Conditional Sum or Sumproduct.

Hi C.G., Could you please elaborate more on what condition you would like to put in here? Regards, Andy On Fri, Oct 8, 2010 at 10:34 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: I am looking for conditional sum i.e. sum based on criteria. But neither Sumproduct nor SUMIFS and Pivot serve

$$Excel-Macros$$

Dear All Please help me on given problem Problem I have many sheet in File(more than 30) In Shhet 1 ,C4 =B4 In Sheet 2 C4=B4 of sheet2 + C4 of sheet 1 If I copy paste this pformula in sheet 3 it will take as C4= B4 of Sheet 3+C4 of sheet 1 but actually I want C4= B4 of Sheet 3+C4 of

Re: $$Excel-Macros$$ Rupee symbol on PC

Hi, I accidentally found an answer to the question put up by N Shivkumar. So wanted to share the same, though I am sure most of you must have found the solution to this. Following are the steps: 1) Select the column/cell where you want to have the format with the new ` rupee symbol. 2) Change

Re: $$Excel-Macros$$ Conditional Sum or Sumproduct.

THANKS. BUT IT SERVE THE PURPOSE PARTIALLY...IN ADDITION I HAVE TO CONSIDER ONLY FY 2009-10 WHEREAS FORMULA TAKES BEYOND 31/03/2010.3 IS IT POSSIBLE TO REVISE THE FORMULA. REGARDS, C.G.KUMAR On Fri, Oct 8, 2010 at 2:19 PM, ashish koul koul.ash...@gmail.com wrote: check the atatchment see

$$Excel-Macros$$ Column hide from excel

4 column(A,B,C,D) in atteched excel, please tell me how to do this -- With Regards, *Vishal K. Angre* E-mail : visha...@gmail.com vishal.k.an...@gmail.com -- -- Some important links for excel users:

Re: $$Excel-Macros$$ Column hide from excel

Dear Vishal This trick is VBA inst log file. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count = 1 Then If Target.Value Then If Target.Column = 3 And Target.Row 1 Then Target(1, -1) = Format(Now, dd-mmm- hh:mm:ss) Target(1, 0) = Application.UserName End If End If

RE: $$Excel-Macros$$ Column hide from excel

See this http://www.youtube.com/watch?v=CrX6353lSx4 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Vishal Angre Sent: Friday, October 08, 2010 12:34 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Column hide from excel 4

Re: $$Excel-Macros$$ Column hide from excel

Dear Sumit only 4 column(A,B,C,D) in atteched excel how to hide column E,F,H. thank regard Vishal On Fri, Oct 8, 2010 at 5:08 PM, SUMIT VYAS svyas0...@gmail.com wrote: Dear Vishal This trick is VBA inst log file. Private Sub Worksheet_Change(ByVal Target As Range) If

$$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

Hi guys I Have a column xyz which is there in every sheet of the workbook and the column number in sheet A is 1 ,sheet B is 2,sheet C is 1 If i delete a value from that column xyz in sheet A,the deleted cell has to be deleted from these B,C sheets But the vice-versa should not happen i.e Delete

$$Excel-Macros$$ HELP

Hi Guys, I am running a variance between two numbers and am unable to get the proper condition required. In the file attached in Clmn E it is working correct if there are numbers in Clmn B. But if B is zero then the formula should show a red arrow (if there is a number in Clmn A) Hope

Re: $$Excel-Macros$$ Column hide from excel

Thank you On Fri, Oct 8, 2010 at 6:07 PM, عمر omar27...@gmail.com wrote: See this http://www.youtube.com/watch?v=CrX6353lSx4 *From:* excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] *On Behalf Of *Vishal Angre *Sent:* Friday, October 08, 2010 12:34 PM *To:*

Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

Hey Dude, Do this, Select the Cell which you want to delete and Ctrl+Select Every Sheet, then press Delete. I hope it will helpful. Regards, Krrish On Fri, Oct 8, 2010 at 6:40 PM, sudheer lolla sudheer1...@gmail.com wrote: Hi guys I Have a column xyz which is there in every sheet of the

$$Excel-Macros$$ Job Opening for Excel and VBA

Dear Group, There is a opening for one person with the following skill to work as Sub contractor. Basic Skill set: (Mandatory) Advance knowledge of xl and VBA Marco Advance Skill Set: (Optional) Exposure to PM methodology Quality Systems Qualifications: MCA/BE Company Name :-

$$Excel-Macros$$ Re: Losing weight

hi sir, i think you can't find solution that problem by excel..:)) (mmm... maybe your finger can lose a little weight) but i can advice to you zumba...:)) it will be more useful than excel. ohh and i have a problem with my hair.. i am starting to lose it.. if someone have any excel program..

Re: $$Excel-Macros$$ dynamic range (table_array) in vlookup formule

Dear Carlo, Select Range Q:R i.e. both entire col and vlookup is enough Regards Ramkesh On Thu, Oct 7, 2010 at 5:48 PM, cg cuoredicapit...@gmail.com wrote: Hi everybody I’ve a big trouble but maybe, for you is an easy trouble. I’m working on excel2003. I’ve to compare two values, in the

$$Excel-Macros$$ Getting a cell value to change when it is in an Indirect function

Hi Guys, So I a simple indirect function that looks into another file (the name of which is in my sheet in cell I1) and find the value in cell A3 of the sheet in that file called Output. This is that function: =INDIRECT([$I$1.xls]Output!A3) However, when i drag this formula down the reference

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

$$Excel-Macros$$ Re: How to find consodated sale data of previous 3 months

Kalyan, Please find the file: How+to+find+data+of+previous+month.xlsx uploaded to the Files section of this group. I believe it should meet your needs. Thanks. Alpesh On Oct 8, 4:38 am, Kal xcel kalx...@gmail.com wrote: Dear Experts, I want to extract last 3 months consolidated sale data

Re: $$Excel-Macros$$ Job Opening for Excel and VBA

Dear Ayush, Thanks for you, 1) excel group 2) help all time 3) touch you every 4) help find job you are great person in this world. regard Sumit Vyas On Fri, Oct 8, 2010 at 9:20 PM, Ayush jainayus...@gmail.com wrote: Dear Group, There is a opening for one person with the following

Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months

Hi Worawat, Thanks for your advice. But I can't use pivot table in this scenario. Because lot of other issues attached with this. Thanks Kalyan On Sat, Oct 9, 2010 at 3:43 AM, worawat kh worawat...@gmail.com wrote: Hi Kalyan You can use pivot table to solve this , better than use many

Re: $$Excel-Macros$$ Re: How to find consodated sale data of previous 3 months

Hi Alpesh, please help me that how to get that file. Thanks Kalyan On Sat, Oct 9, 2010 at 6:57 AM, pesh alpes...@gmail.com wrote: Kalyan, Please find the file: How+to+find+data+of+previous+month.xlsx uploaded to the Files section of this group. I believe it should meet your needs.

Re: $$Excel-Macros$$ Re: How to find consodated sale data of previous 3 months

Thanks Alpesh, Got the file, checking. Thanks once again Kalyan On Sat, Oct 9, 2010 at 10:38 AM, Kal xcel kalx...@gmail.com wrote: Hi Alpesh, please help me that how to get that file. Thanks Kalyan On Sat, Oct 9, 2010 at 6:57 AM, pesh alpes...@gmail.com wrote: Kalyan, Please

Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months

Dear one colum set structure :- month = jan-2008 jan-2009 jan-2010 then use use pivot table On Sat, Oct 9, 2010 at 10:34 AM, Kal xcel kalx...@gmail.com wrote: Hi Worawat, Thanks for your advice. But I can't use pivot table in this scenario. Because lot of other issues attached with this.