On May 24, 9:08*am, Drew wrote:
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