Also there is on blank point.. what if .. cab parked area (as in 'area' sheet) is *NOT *matching with the areas or on route areas??
On Thu, Jun 5, 2014 at 10:18 PM, Vaibhav Joshi <[email protected]> wrote: > hey > > check this.. > > you can run macro on test sheet by pressing A;t + F8 then enter.. > > > PS. You will be required to unmerge cell in col I before running macro. > > > Cheers!! > > > On Thu, Jun 5, 2014 at 11:54 AM, Jack Tribhuvan <[email protected]> > wrote: > >> Hi, >> >> Yes I sort the data before running the macro. >> Now the DP stand for drop and PU stands for pick up >> so only cab going for drop (DP) will bring pick up (PU) >> therefore only those two consecutive rows DP followed by PU >> are coloured yellow. >> and the full lines are not merged but only the 'final km' column two >> cells are merged and formula >> used to define the total. >> >> Thanks >> >> >> On Thu, Jun 5, 2014 at 11:09 AM, Vaibhav Joshi <[email protected]> wrote: >> >>> 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 a topic in the >>> Google Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/excel-macros/cb4ff453jUA/unsubscribe. >>> To unsubscribe from this group and all its topics, 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. >> > > -- 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.
