Hey, Questions for you!!
Whether data will be sorted or you want it to be sort before running Macro? Explain this line .. (always PU has to be followed by DP no two PU or DP or PU then DP is taken) pl explain in steps specially that sentences between or.. Why do you want to merge lines & is it ok to get it done using formula & conditional formatting istead of Macro. Cheers!! On Wed, Jun 4, 2014 at 2:58 PM, Jack Tribhuvan <[email protected]> wrote: > Hi, > > I have basic knowledge excel and have 2010 office > if anyone could help as I have lot of data. > I have attached sample of working needed. > > The procedure I do manually is as below: > > I have two sheets 'data' and 'area' > in 'data' sheet monthly entries are done (which are new each month) > in 'area' sheet fixed areas and on route locations are given. > > In data look for two consecutive row having the below > First DP then PU (always PU has to be followed by DP no two PU or DP or PU > then DP is taken) > then I look for Cab No. (if they are same no.) > Then I look for area if they same or on route (as given in 'area' sheet) > I check if cab parked area (as in 'area' sheet) is matching with the areas > or on route areas > on the two rows > then colour the two rows yellow > merge the last two cells of the rows > and use the formula as in the merged cell > > If this can happen with code I can save days of work. > > Thanks. > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
