Hi
Is there an equivalent LoadPicture command for Excel 2011 for Mac ? Or
is there some sort of workaround ?
TIA
Andrew B
Dear sir,
thanks for your reply
I am using MS OFFICE only this data comming from one of our
Accounting package i am export data to Excel-2003
P. code mean Vendor Code list
This is consolidate balance
P.Code Balance Amount
100 25000
101 1300
102 7800
--------------------------------------------------------------------------------------------
this actusla outstanding Bills Details
------------------------------------------------------------------------------
P.Code Bill No. Bill Amount
100 A123 1000
100 a213 15000
100 b153 5000
100 b215 8000
------------------------------------------------------
101 abz 500
101 a19 800
101 b89 500
Party Total Balance is Only 25000 But we have Bill wise details
More than Rs. 25000 . we need Last in first out method Bills only
i want to tak say exame
we need OUTPUT Like this
This Party code Total Balance is Rs.25000/- so that i will take
last two full value other bill balance amount only take
100 a213 12000 (Actuals Bill value is
18000, )
100 b153 5000
100 b215 8000
-----------------------------------------------------------------------------
Next part will come contineously this Vendor balance is only
1300 so i will take last in two bills only
101 a19 800
101 b89 500
Best regards
Chandru
