Re: $$Excel-Macros$$ Macro to highlight Max Value in a Column and copy/transpose data in another file

This is what I did (with my limited knowledge) It gives me Object Required error but not highlighting any particular row Runtime Error 424 Would you correct me please? Sub Transpose() Dim wk As Workbook Dim ws As Worksheet Dim ex As Workbook Dim es As Worksheet Dim k As String Set wk = ThisWorkbo

Re: $$Excel-Macros$$ Macro to highlight Max Value in a Column and copy/transpose data in another file

Hi Dear. You can self change of range that which range u want and remove the come workbook.save /close. And create one new modul anf paste that code. Thanks P Pramod On 24 Sep 2014 14:38, "prkhan56" wrote: > Hi Pramod > Thanks for your response. > If you check my Input data sheet on File 1 o

Re: $$Excel-Macros$$ Macro to highlight Max Value in a Column and copy/transpose data in another file

Hi Pramod Thanks for your response. If you check my Input data sheet on File 1 of my original post. I want it to paste transposed data it in B9, C9, D9 and E9 downwards. Second, please assign a shortcut or Button to the macro as clicking on the Cell is bit risky...it paste the data again and ag

Re: $$Excel-Macros$$ Macro to highlight Max Value in a Column and copy/transpose data in another file

Hi prkhan56 , Please find the your second macro.Kindly see the path as i mention your attached file.[File2.xlsb] your will be second file. Thanks P On Tue, Sep 23, 2014 at 9:23 PM, prkhan56 wrote: > > > Hello All, > Can someone help me with the Second Macro? > Thanks > On Monday, September 2

Re: $$Excel-Macros$$ Macro to highlight Max Value in a Column and copy/transpose data in another file

Hello All, Can someone help me with the Second Macro? Thanks On Monday, September 22, 2014 7:34:17 PM UTC+4, prkhan56 wrote: > Hi Pramod, > Thanks for your prompt reply. > Works great! > > The second macro should run when the Cell Pointer is in Column T on a > Highlighted Cell (in red). *Can

Re: $$Excel-Macros$$ Macro to highlight Max Value in a Column and copy/transpose data in another file

Hi Pramod, Thanks for your prompt reply. Works great! The second macro should run when the Cell Pointer is in Column T on a Highlighted Cell (in red). *Can red be given the RGB value mentioned on my sample data?* I want to copy and transpose cells from the Row where the Max value is found in Co

Re: $$Excel-Macros$$ Macro to highlight Max Value in a Column and copy/transpose data in another file

Hi Dear, Please find the Attached file ... Regards P On Mon, Sep 22, 2014 at 2:53 PM, prkhan56 wrote: > Dear All, > > I am using Excel 2010 and have attached a file with my problem. > > I need Two Macros for my problem. > > > > There are two Files (both in a shared location - Path S:\...\...\