$$Excel-Macros$$ VBA Code against VLOOKUP function

Hi Masters, Needed the VBA code which work similar to VLOOKUP function where I can call data from master worksheet to fill my report Attached file will explain you my requirement Master worksheet contains - GL Code master where each GL code has details and grouping While putting GL code in

$$Excel-Macros$$ Need a Macro

Hello Friends, I need your help to make macro. I need a macro which work like format painter for different format not only one format. * --- Kαяαη* -- -- Some important links for excel users: 1. Follow us on TWITTER

Re: $$Excel-Macros$$ VBA Code against VLOOKUP function

Dear Anil, Please see attached Sheet, -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Fri, Jul 15, 2011 at 11:32 AM, Anil Bhange anil.bha...@tatacommunications.com wrote: Hi Masters, ** ** Needed the VBA code which

Re: $$Excel-Macros$$ Need a Macro

http://www.excelforum.com/excel-programming/353482-macro-to-create-format-painter.html On Fri, Jul 15, 2011 at 12:29 PM, karan 1237 karan1...@gmail.com wrote: Hello Friends, I need your help to make macro. I need a macro which work like format painter for different format not only one

Re: $$Excel-Macros$$ Need a Macro

It's working...Thank you so much... * Kαяαη* On Fri, Jul 15, 2011 at 12:33 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: http://www.excelforum.com/excel-programming/353482-macro-to-create-format-painter.html On Fri, Jul 15, 2011 at 12:29 PM, karan 1237 karan1...@gmail.com wrote:

$$Excel-Macros$$ Merge Vertically

Hello Friends, Once again I need your help. There is option for merge across in excel but is there any macro to merge vertically. It will merge selected range in vertically. Thnx Karan -- -- Some important links

RE: $$Excel-Macros$$ VBA Code against VLOOKUP function

Thanks Noorain, One more help please, If the GL code doesn't match can I able to color these cell in Red color Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Friday,

Re: RE: $$Excel-Macros$$ Find and replace in all open Excel Workbook

Thank you Daniel.. It Worked.. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @

Re: $$Excel-Macros$$ Merge Vertically

Dear Karan, Please try it Sub mergecell() With Selection .HorizontalAlignment = xlGeneral .MergeCells = True End With End Sub On Fri, Jul 15, 2011 at 12:56 PM, karan 1237 karan1...@gmail.com wrote: Hello Friends, Once again I need your help. There is option for merge across in

Re: $$Excel-Macros$$ Merge Vertically

PFI On Fri, Jul 15, 2011 at 2:56 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Karan, Please try it Sub mergecell() With Selection .VerticalAlignment = xlBottom .MergeCells = True End With End Sub On Fri, Jul 15, 2011 at 12:56 PM, karan 1237 karan1...@gmail.com

Re: $$Excel-Macros$$ Merge Vertically

* Hey friend, I facing this problem. I want to merge all columns in one time. Kαяαη* On Fri, Jul 15, 2011 at 2:56 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Karan, Please try it Sub mergecell() With Selection .HorizontalAlignment = xlGeneral .MergeCells =

Re: $$Excel-Macros$$ VBA Code against VLOOKUP function

Dear Anil, Please see attached Sheet.. -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Fri, Jul 15, 2011 at 12:54 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: Thanks Noorain, ** ** One more help please,

Re: $$Excel-Macros$$ Merge Vertically

Sub mergeall() Worksheets(Sheet4).Rows.Select With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlBottom End With Selection.Merge End Sub On Fri, Jul 15, 2011 at 3:03 PM, karan 1237 karan1...@gmail.com wrote: * Hey friend, I facing this

$$Excel-Macros$$ Re: sumproduct and pivot table on same data ranges - different results - any reasons

Sorry every who read this post, The mistake is not located on the productsum table or on the pivot table. It's simply located in the table below the productsum table which as an incoherent formula (it takes twice a value) which makes the difference...sorry On 14 juil, 20:11, Pascal Baro

$$Excel-Macros$$ Re: sumproduct and pivot table on same data ranges - different results - any reasons

I forgot to update values as i tried to make the size of the file smaller with less rows and columns ...on sheet4, line 28 should be the same as line 34 on sheet trt_june On 14 juil, 20:11, Pascal Baro bpascal...@googlemail.com wrote: Please find a file attached for more on this query. Thanks

$$Excel-Macros$$ Re: sumproduct and pivot table on same data ranges - different results - any reasons

Sorry every who read this post, The mistake is not located on the productsum table or on the pivot table. It's simply located in the table below the productsum table which as an incoherent formula (it takes twice a value) which makes the difference...sorry On 14 juil, 20:11, Pascal Baro

$$Excel-Macros$$ RE: Want to copy two rows in all sheets except few

Dear All, I want to copy paste special rows 5 6 of sheet “Heading” to all the sheets starting from “Balance Sheet” to “Note 31” Can someone suggest code for the same. शुभकामनाओं सहित, अजय मित्तल, वित्त प्रबन्धक पाइपलाइंस मुख्यालय टेलीफोन:0120-2448312 ई-मेल : amit...@iocl.co.in This Message

Re: $$Excel-Macros$$ Merge Vertically

Hi Karan/Norain, what is use of merging all the cells on a sheet. After merging what are you going to do with the sheet as it will become like a Notepad page and you cant use any other formula/function. I am asking this just out of my curiousity, would appreciate your answer. Thanks, Anish On

Re: $$Excel-Macros$$ RE: Want to copy two rows in all sheets except few

Hello Sir, I guess, I answered this query yesterday with attachment. Please let me know if it didnt work or you want a different solution. This was the code.. Sub copy_rows() Dim sht As Integer For sht = 5 To Worksheets.Count Sheets(4).Select Rows(5:6).Copy

Re: $$Excel-Macros$$ Need Formula

Hi Venkat, Thanks for the update... But this is not what I was looking for... I need a formula in the table above that.. The ones already show the result that I desire to achive. Thanks On Fri, Jul 15, 2011 at 10:57 AM, Venkatesan c venkat1@gmail.comwrote: Hi Rahim, Look attached file

Re: $$Excel-Macros$$ Multiple excel files

Hi Shrinivas, Attached please find the Dump file with macro. You will have to copy and paste your unique account numbers in Cell *M1 *before running the macro. Data will be splitted based on the account numbers and new files will be saved with account names. Also note that I have done it with

Re: $$Excel-Macros$$ Multiple excel files

Hello Group, It would be an add-in for my learing, if you can suggest the code for finding unique account values from Column A using the code so that Shrinivas doesnt have to copy and paste the unique account values manually in cell M1. Thanks, Anish On Fri, Jul 15, 2011 at 5:27 PM, Anish

$$Excel-Macros$$ Re: Total displayed as -1.776E-13 .. why not Zero????

Hi Markkim, I have checked that the answer of the formula =IF(A54=0,1,0) is 1 because A54 is blank in your sample sheet. If I assume that you will have some value in A54, then the answer will be 0 and then your below code is working fine :- If range(A54) 0 then Else . End

Re: $$Excel-Macros$$ sumproduct and pivot table on same data ranges - different results - (part 2)

Hi U have consider G1 = 2527 in pivot table not in sumproduct sheet. Please check Thanks Mahesh On Fri, Jul 15, 2011 at 6:20 PM, Pascal Baro bpascal...@googlemail.comwrote: Hi, This time there really is a difference between the pivot table and productsum function. It seems it's all

$$Excel-Macros$$ Hi I need your help , Please explain it with example.

Hi Sir, Can you please tell me what is difference between these two codes, Please guide me. Private Sub Worksheet_Change(ByVal Target As Range) End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub --

$$Excel-Macros$$ there are two code , please explain this code.

Hi, I need your help . I have query in VBA. Please help me . Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 3 And Target.Column = 3 Then 'calculate criteria cell in case calculation mode is manual Worksheets(ProductsList).Range(I3).Calculate

RE: $$Excel-Macros$$ Hi I need your help , Please explain it with example.

Hi, Private Sub Worksheet_Change(ByVal Target As Range) is fired when you enter a value into a cell Private Sub Worksheet_SelectionChange(ByVal Target As Range) is fired when you select another cell or if you change the current selection. In both cases, “Target” represents the

RE: $$Excel-Macros$$ Hi I need your help , Please explain it with example.

Note that in some cases, there is a difference between “Target” and “ActiveCell”, when the active cell moves downwards or sidewards after you hit the “Enter” key. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Daniel Envoyé : vendredi 15

Re: $$Excel-Macros$$ Hi I need your help , Please explain it with example.

*1. **Worksheet.Change Event* * *Occurs when cells on the worksheet are changed by the user or by an external link. This event doesn't occur when cells change during a recalculation. Use the Calculate event to trap a sheet recalculation. This example changes the color of changed cells to blue.

RE: $$Excel-Macros$$ there are two code , please explain this code.

Hello, Here are some comments : ‘executes when a value is entered in a cell (or the cell contents are deleted) Private Sub Worksheet_Change(ByVal Target As Range) ‘only if the value is entered in cell C3 If Target.Row = 3 And Target.Column = 3 Then 'calculate criteria cell in case

Re: $$Excel-Macros$$ sumproduct and pivot table on same data ranges - different results - (part 2)

thanks Mahesh, btw, I guess it would be better to use getpivotdata function instead of a sumproduct function that requires the entire excel application to update data if any modification to the data or the function is made... thanks again On 15 juil, 15:08, Mahesh parab mahes...@gmail.com wrote:

$$Excel-Macros$$ $$Excel VBA$$ Sorting worksheet with grouped rows and/or validation lists

I am working on a code that has a series of metrics listed in rows. Each metric is uniquely specified by several headings listed in the header row. The (relevant) categories in the header are as follows: |ID|Category|Sub-Category|Metric|Sub-Metric|Unit|Priority|etc... (irrelevant)| The entire

Re: $$Excel-Macros$$ Need Formula

Hi Mahesh, Thanks so much for the formula... I really appreciate your work..!!! Have a Great Weekend..!! Warm Regards, Rahim Sharieff. On Fri, Jul 15, 2011 at 9:55 PM, Mahesh parab mahes...@gmail.com wrote: Hi Rahim find attach Thanks Mahesh On Thu, Jul 14, 2011 at 10:35 PM, Rahim

$$Excel-Macros$$ Excel 2007 Quick Access Toolbar- Take it with me...

Is there a way to have my Quick Access Toolbar portable (like on a jump drive) so any computer with Excel 2007 can have my customized Quick Access Toolbar when I use it? Thank you. John -- -- Some important links