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 Col T. (Cells to be copied are colored and shown under various Steps)
See the output required is in the Input Data Sheet. I have made a sample output on Input Data sheet for values on Row 25 on SM Data sheet I have shown the Input Data shown here for sake of explanation. It would be in File 2 which would be on the shared folder Path S:\..\...\ Hope it is clear now. Thanks once again for your time. Rashid On Monday, September 22, 2014 5:23:52 PM UTC+4, pramodb35 wrote: > > Hi Dear, > > > Please find the Attached file ... > > > Regards > P > > On Mon, Sep 22, 2014 at 2:53 PM, prkhan56 <prkh...@gmail.com <javascript:>> > 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:\...\...\) > > > > File 1 has sheet name SM > > > > File 2 has sheet name Input Data (shown here to explain the problem) > > > > > > > > Data in set of 24 rows i.e for 24 Hours x 10 days > > > > Data Set is starting from A25 to Z > > > > > > > > First Macro should run upto Row 264 and highlight the Max Value in Col T > > > > 24 Rows data should be considered when highlighting the Max Value > > > > eg Row 25 - 48, 49 - 72 and so on till Row 264 > > > > > > > > > > > > Second Macro should run only when the Cell pointer is on the highlighted > > Cell in Col T > > > > > > > > It should copy the values found in the highlighted Row and paste it in > File > > 2 as follows: > > > > Step 1 - Values from Cell C to I should be copied and transposed in File > 2 > > in Cell B9 down > > > > Step 2 - Values from Cell J to M should be copied and transposed in File > 2 > > in Cell C9 down > > > > Step 3 - Values from Cell N to S should be copied and transposed in File > 2 > > in Cell D9 down > > > > Step 4 - Values from Cell T to Z should be copied and transposed in File > 2 > > in Cell E9 down > > > > > > > > Colored only for sake of explanation > > > > > > > > Second Macro should run only once and then as and when required, as > further > > work needs to be done after copy/transposing the data. > > > > > > > > TIA > > > > Rashid > > > > -- > > 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 thread titles. Poor thread titles, like Please > > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will > > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Jobs posting is not allowed. > > 6) Sharing copyrighted material and their links is not allowed. > > > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > > members are not responsible for any loss. > > --- > > You received this message because you are subscribed to the Google > Groups > > "MS EXCEL AND VBA MACROS" group. > > To unsubscribe from this group and stop receiving emails from it, send > an > > email to excel-macros...@googlegroups.com <javascript:>. > > To post to this group, send email to excel-...@googlegroups.com > <javascript:>. > > Visit this group at http://groups.google.com/group/excel-macros. > > For more options, visit https://groups.google.com/d/optout. > > > > -- > PramodSingh > -- 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 thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
