Just to say a big thank you,
I am using your program which i will use continuously to sort out my
exercise on a monthly basis,
I salute you, Vaibhav.
S.Lakhani
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 se
Thanks, VABZ,
Actually making you do extra work, i don't know how to re-pay.
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 around with figures.there is no barrier to how
> many
Ok, i got that now..
So you are finding min diff between Invoices & multiple payment received &
allocating in a way which yields you min difference.!!
will change the code to suits your need.
Cheers!!
On Thursday, June 5, 2014 4:30:50 PM UTC+5:30, Sleek wrote:
>
> You can use the data once &
You can use the data once & once only.
You have done it, but i have to juggle the targets around.
The best way is to run macro twice only then in column C of Table to place
what is data is left behind.
When data loads onto column A of table, then remove that data from Column A
of excel(not table
ok,
what is data to be used then?
is it same for each target or different..?
On Thu, Jun 5, 2014 at 3:19 PM, 'Sleek' via MS EXCEL AND VBA MACROS <
excel-macros@googlegroups.com> wrote:
> NB: you used 96850 twice yet in my data appears only one, 193600 appears
> nowhere in your table but i have
NB: you used 96850 twice yet in my data appears only one, 193600 appears
nowhere in your table but i have it in my data.
Those are constants to move around.
You are so close, yet so far.
On Saturday, May 31, 2014 12:11:22 PM UTC+3, Sleek wrote:
>
>
> I need a minimum or zero difference, against
hi
see file i sent, it gives better result..
let me know if i paste wrong data set in col A.
I used same data for col A, b & c
Cheers!!
On Thu, Jun 5, 2014 at 12:33 PM, 'Sleek' via MS EXCEL AND VBA MACROS <
excel-macros@googlegroups.com> wrote:
> Sequence of events: first i pasted all my actu
Sequence of events: first i pasted all my actual data on column A ,then i
set it aside whatever has been utilised, then run the macro on remaining
(remove blanks) , place aside the other data, whatever is left i then,
place it final part of table(or array?)
the macro is run twice but can as well
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
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:
>
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
thats great!!
Cheers!!
On Tue, Jun 3, 2014 at 12:14 PM, 'Sleek' via MS EXCEL AND VBA MACROS <
excel-macros@googlegroups.com> wrote:
>
>
> 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 co
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 around with figures.there is no barrier to how
> many you can put in column but use only the figures i give you. I think
> maybe
15 matches
Mail list logo
