hey..
Let me tell you how this code works..
Put data set which you want to use for finding min diff. in col A. You can
use duplicate number if your data set have duplicate then there is no issue.
Cheers!!
On Thu, Jun 5, 2014 at 11:59 AM, 'Sleek' via MS EXCEL AND VBA MACROS <
excel-macros@googl
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' c
hey
we didn't hear you back on this..
Cheers!!
On Wed, Jun 4, 2014 at 5:45 PM, Vaibhav Joshi wrote:
> Is there diff set of data for individual target cell? send me excel with
> sample for which yiu are getting error.'
>
> Cheers!!
>
>
> On Wed, Jun 4, 2014 at 5:14 PM, Vaibhav Joshi 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
Hi
on which line you are getting error?
Also in VB editor, goto Tools, Reference and let us know you have ticked
which objects / libraries?
Cheers!!
On Thu, Jun 5, 2014 at 10:38 AM, finu kodokodan wrote:
> it is working properly. can you enable macro and try .
>
>
>
> On Wed, Jun 4, 2014 at
Hi Vaibjav... you are great
On Thu, Jun 5, 2014 at 9:08 AM, Vaibhav Joshi wrote:
> Cheers Dude..
>
>
>
>
> On Thu, Jun 5, 2014 at 1:32 AM, Nasir Khan
> wrote:
>
>> Thank you very much my friend.
>> Works to my requirement.
>> Your help will save me lot of time.
>> Regards
>> Nasir
>>
>>
>
it is working properly. can you enable macro and try .
On Wed, Jun 4, 2014 at 2:30 PM, Sagar Kasangottuwar <
sagarkasangottu...@gmail.com> wrote:
> error 1006 is showing when I am running after changing the path.
>
> Please help
>
> Thanks & Regards,
> Sagar
>
>
> On Thu, Mar 7, 2013 at 5:53 PM
Cheers Dude..
On Thu, Jun 5, 2014 at 1:32 AM, Nasir Khan
wrote:
> Thank you very much my friend.
> Works to my requirement.
> Your help will save me lot of time.
> Regards
> Nasir
>
>
> On Wed, Jun 4, 2014 at 2:53 PM, Vaibhav Joshi wrote:
>
>> PFA
>>
>> Cheers!!
>>
>>
>> On Wed, Jun 4, 2014
Thank you very much my friend.
Works to my requirement.
Your help will save me lot of time.
Regards
Nasir
On Wed, Jun 4, 2014 at 2:53 PM, Vaibhav Joshi wrote:
> PFA
>
> Cheers!!
>
>
> On Wed, Jun 4, 2014 at 1:51 AM, Nasir Khan
> wrote:
>
>> Hello,
>> I am enclosing a sample of Excel sheet to w
Is there diff set of data for individual target cell? send me excel with
sample for which yiu are getting error.'
Cheers!!
On Wed, Jun 4, 2014 at 5:14 PM, Vaibhav Joshi wrote:
> Are you putting unique values only in Column A?
>
>
> On Wed, Jun 4, 2014 at 4:59 PM, 'Sleek' via MS EXCEL AND VBA M
Are you putting unique values only in Column A?
On Wed, Jun 4, 2014 at 4:59 PM, 'Sleek' via MS EXCEL AND VBA MACROS <
excel-macros@googlegroups.com> wrote:
> Not workable the macro is omitting some figures & placing duplicate of
> others.
> The data should be used once but juggled around.
>
>
>
Not workable the macro is omitting some figures & placing duplicate of
others.
The data should be used once but juggled around.
On Saturday, May 31, 2014 12:11:22 PM UTC+3, Sleek wrote:
>
>
> I need a minimum or zero difference, against the target totals i have set.
> i have 3 columns, juggle ar
error 1006 is showing when I am running after changing the path.
Please help
Thanks & Regards,
Sagar
On Thu, Mar 7, 2013 at 5:53 PM, Pravin Gunjal wrote:
> *Thanks Anil.*
>
> -- Forwarded message --
> From: अनिल नारायण गवली
> Date: Thu, Mar 7, 2013 at 10:19 AM
> Subject: Re:
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'
14 matches
Mail list logo
