Re: $$Excel-Macros$$ Multiple filters in one spreadsheet area

Can you attach the sample sheet On Mon, Aug 1, 2011 at 9:56 AM, Guzal Yusupova <9uzal.yusup...@gmail.com>wrote: > Is there any way to set up more than one filter in one sheet? > Thank you! > > -- > > -- > Some importa

Re: $$Excel-Macros$$ journal entry

can you explain it in detail On Sun, Jul 31, 2011 at 11:34 AM, Ananta Sapkota wrote: > I have attached file which gives us simple idea whatever i want to do. > Please help me. It's urgent for me to keep accounting record. > > ananta Sapkota > > -- > >

$$Excel-Macros$$ Multiple filters in one spreadsheet area

Is there any way to set up more than one filter in one sheet? Thank you!! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our L

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Welcome Krish On Sat, Jul 30, 2011 at 10:01 PM, krishna mummina wrote: > vijaykumar and venkat > > thank you very much for your valuable input. > > > On Sat, Jul 30, 2011 at 8:23 PM, P.VIJAYKUMAR wrote: > >> Dear Krishna, >> >> >> The profile of MIS Executive changes with the type organisatio

RE: $$Excel-Macros$$ $$Excel-Macro$$ - Optimize Formula

Hi, Try this: =IF(A5<=$T$5,$S$5,IF(A5<=$T$6,$S$6,IF(A5<=$T$7,$S$7,IF(A5<=$T$8,$S$8,IF(A5<=$T$9,$S$9,IF(A5<=$T$10,$S$10,"")) The multiple IF statement stops as soon as it finds a TRUE. So you don't need to use AND statements to create 'windows' The above asks: Is A5 greater or equal to T5?

Re: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

Dear Sir The formula given by Mr.Daniel is awesome but will give wrong results except for the first set. A slight modification as given below will bring out the intended result. =INDEX($A$1:$AE$1,1,MAX(IF($B2:$AE2="P",COLUMN($B2:$AE2 In the above formula, the second and the third ranges shoul

$$Excel-Macros$$ $$Excel-Macro$$ - Optimize Formula

Any help in shortening or optimizing this formula would be great. Im limited by the nested if statements to match week numbers (column s) and week ended date (Column T), and continue to bog down the recalculations. It does work, but slows things down.I'm using it to determine if a date falls

RE: $$Excel-Macros$$ Help needed to comine VBA modules

Can you attach a sample file such as issued from SAP ? The next point to discuss is the detail sheets from the pivot. Do you want all of them or only the ones you double clicked on the value field Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de

$$Excel-Macros$$ Learn VBA with Videos

Hey All, Please find the below link... http://www.familycomputerclub.com/ http://www.wuala.com/subashvt/Excel%20Macro%20Training/ -- -- Some important links for excel users: 1. Follow us on TWITT

Fwd: $$Excel-Macros$$ Help needed to comine VBA modules

Dear daniel, Actually the raw data for worksheet "*ANALYSIS*" was downloaded from *SAP -ERP *,With help of macro it is consolidated into a*pivot table * in worksheet *analysis"*.Every day i have to do this process many times,That's why i propose to include in Personal macro workb

Re: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

Hello Maulik, If you just have single characters in cells like "A","P" etc... use this, AF2 copy down. =LOOKUP(10,SEARCH("p",B2:AE2),B$1:AE$1) Or, =LOOKUP(2,1/(B2:AE2="p"),B$1:AE$1) The first one is more faster than second one. HTH Haseeb For tips visit; http://www.excelfox.com/forum/forum.

Re: $$Excel-Macros$$ urgent help needed.

This helps . Thank you much. On Sun, Jul 31, 2011 at 1:18 AM, ashish koul wrote: > Try this see if it helps > > > On Sun, Jul 31, 2011 at 12:18 AM, Sara Lee wrote: > >> hello >> >> i need to combine multiple excel files(15) into one excel file. Each file >> has 2 sheets... R and S and data fro

Re: $$Excel-Macros$$ urgent macro required pls

Thank You Daniel. I really appreciate it. On Sun, Jul 31, 2011 at 10:52 AM, Daniel wrote: > Open the workbook where the results are to be copied in. The macro adds > maps and shipment sheets so there should be no such sheets in the workbook. > Press the Alt+F11 keys, this opens the VB Editor win

Re: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

Dear Maulik, Please try it with ctrl+shift+Enter =OFFSET($A$1,0,LARGE(IF(B2:AE2="P",COLUMN($B$1:$AE$1),""),COLUMN(1:1))-1) -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Sun, Jul 31, 2011 at 1:56 PM, maulik desai wrote: > Hi

RE: $$Excel-Macros$$ Entered data should be locked

Hello, I protected the sheet (password : excel). In the sheet module I put the macro : Private Sub Worksheet_Change(ByVal Target As Range) Dim c As Range ActiveSheet.Unprotect "excel" For Each c In Target If c <> "" Then c.Locked = True Next c ActiveSheet.P

RE: $$Excel-Macros$$ urgent macro required pls

Open the workbook where the results are to be copied in. The macro adds maps and shipment sheets so there should be no such sheets in the workbook. Press the Alt+F11 keys, this opens the VB Editor window. Now, keep in mind that I use a French version of Excel, so the words I use may not be Exactly

RE: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

Sorry, it should have more correct to write "SUMPRODUCT" IS an array function. -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Daniel Envoyé : dimanche 31 juillet 2011 15:31 À : excel-macros@googlegroups.com Objet : RE: $$Excel-Ma

RE: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

Yes, that's true. However, do not forget that "SUMPRODUCT" IS an array formula, just designed to be entered as a standard formula by MS. Best regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de GoldenLance Envoyé : d

Re: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

HI, just copy paste the below formula till your last employee which will give you accurate results =INDEX($A$1:$AE$1,1,MAX(IF($B2:$AE2="P",COLUMN($B$2:$AE$2 as mentioned bellow with Ctr+shift+Enter On Sun, Jul 31, 2011 at 5:50 PM, Daniel wrote: > Hi, > > ** ** > > In AF2 (array formul

Re: $$Excel-Macros$$ Remove HyperLink without Macro

Nice one XLS S On Jul 31, 10:41 am, XLS S wrote: > Dear All, > > Try this > >    1. In a blank cell, enter the number 1. >    2. Select the cell and press *Ctrl+C*. >    3. Hold down the *Ctrl* key as you click each hyperlink you want to >    remove. >    4. Right Click and Choose Paste Special f

Re: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

=INDEX($A$1:$AE$1,SUMPRODUCT(MAX(($B2:$AE2="P")*COLUMN($B$1:$AE$1 will work without an array formula Dan :) On Jul 31, 5:20 pm, "Daniel" wrote: > Hi, > > In AF2 (array formula, validate with Ctrl+Shift+Enter) : > > =INDEX($A$1:$AE$1,1,MAX(IF($B$2:$AE$2="P",COLUMN($B$2:$AE$2 > > Copy down.

$$Excel-Macros$$ Entered data should be locked

Dear Friends, If any one can helped can be appreciated i have data like frequently repeated data so i would like to lock the entered data and it should not be modified i.e. my file should allow empty cells should be entered, if any correction or modification needed that should ask the password.If

RE: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

Hi, In AF2 (array formula, validate with Ctrl+Shift+Enter) : =INDEX($A$1:$AE$1,1,MAX(IF($B$2:$AE$2="P",COLUMN($B$2:$AE$2 Copy down. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de maulik desai Envoyé : dimanche 31 j

Re: $$Excel-Macros$$ urgent macro required pls

i would like to add rows of respective sheets to be added below one another. i have never run a macro. Can you please give step by step instruction. On Sun, Jul 31, 2011 at 5:27 AM, Daniel wrote: > Hi, > > Do you want to add the rows of each sheet below the preceding ones, or do > you intend to

$$Excel-Macros$$ Use of MS access in case of SAP R/3

Dear Experts Is there any use of MS access when a company is using SAP R/3 ? Regards Jatin -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/excel

Re: $$Excel-Macros$$ Help with Refreshing Multiple Pivots on different sheets

Hey Thanks people.. never knew that the Refresh All option eixsted !..appreciate the help. Regards, Ruchi On Tue, Jul 26, 2011 at 8:13 AM, NOORAIN ANSARI wrote: > Sub allpivotsofworkbook() > activeworkbook.Refreshall > end sub > > On Mon, Jul 25, 2011 at 11:55 PM, XLS S wrote: > >> Easy way i

RE: $$Excel-Macros$$ urgent macro required pls

Hi, Do you want to add the rows of each sheet below the preceding ones, or do you intend to consolidate the sheets like you'll do it with Data, Consolidate menus ? Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de

RE: $$Excel-Macros$$ Help needed to comine VBA modules

It will be very difficult to move the code to the personal.xlsb workbook without the initial file retaining some code. Can you explain why you want to do so ? Maybe there should be alternative solutions. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroup

Re: $$Excel-Macros$$ Recover the VB password

Where is the file? On Fri, Jul 29, 2011 at 3:14 PM, ICWAI Help wrote: > HI Ashish, > > i have updated the VB password for my excel file while but i am not able to > open now.could you please let me knwo is there any other way to open the > codes.in that. > > > Thansk, > ICWAI. > > -- > > --