Hi Dear,
Please find the Attached file ... Regards P On Mon, Sep 22, 2014 at 2:53 PM, prkhan56 <prkha...@gmail.com> 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+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. -- 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.
File no 1-Group.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
