Hi Joel,
Have added a sample of the attachment. appreciate ur help!!!!
Thanks,
Rosana
Rosana;686512 Wrote:
Hi,
We have an invoice in text format in excel. I need to convert in a
table format to be able to convert it into a pivot
I need macros created which can
1) delete blank rows
2) delete rows which start with certain text in a particular (the
invoice heading appears frequently in every page)
3) each transaction is in 2 lines- need it to be in one line
PAGE
ROSANA ALAM 36422299601017
FINANCE CONTROLLER 30/03/10
MICROSOFT GULF FZE LLC
MICROSOFT STAFF 1
P O BOX 52244
DUBAI
AGN CODE:01 AGN NAME :DNATA TEMPORARY STATEMENT FOR MARCH
2010
DATE TICKET TRANS PASSENGER NAME DESCRIPTION VALUE TAX DISCOUNT
AMOUNT
REF. NO. TYPE ROUTING PAYABLE
OPENING BALANCE 2 ,840,384.13
PAYMENT RECEI VED
28/03/10 Payment Received 0.00 0.00 0.00 1 ,465,957.00CR
EB290316
TOTAL 1 ,465,957.00CR
DEPARTME NT 1
23/02/10 681 0000330760 SVC MR XXXXXXX InvNo:XXXXXXXXXXXX 140.00 0.00
0.00 140.00
1333843 140.00
23/02/10 176 3842850331 ATB MR. ABDCDEEEE InvNo:XXXXXXXXXXX 2,830.00
280.00 0.00 3,110.00
33495 ACC/DXB 3,110.00
+-------------------------------------------------------------------+
|Filename: excel statement.xlsx |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=511|
+-------------------------------------------------------------------+
--
i-roalam
------------------------------------------------------------------------
i-roalam's Profile: 1695
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=191856
http://www.thecodecage.com/forumz