Re: $$Excel-Macros$$ Need Code for data

2014-06-06 Thread Jack Tribhuvan
hen >>> check_on_route = True >>> Exit Function >>> End If >>> >>> Set FoundCell = Range("DESTINATIONS").FindNext(after:=FoundCell) >>> If FoundCell.Address = FirstAddr Then Exit Do >>&

Re: $$Excel-Macros$$ Need Code for data

2014-06-04 Thread Jack Tribhuvan
ne .. > > (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. &g

$$Excel-Macros$$ Need Code for data

2014-06-04 Thread Jack Tribhuvan
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'