Pamella
07-24-2019, 02:20 AM
Hello,
I have a file which I have to extract data from. Unfortunately when it is converted to Excel it all prints to Column A but separate rows.
First condition within the file search in column A, within row - 1) Find "Host Fee"
2) Find "Sum Total"
Move 1 row down.
The no. of rows may vary could be between 1-4
CUSTOMER US DOLLAR XXXX .00 .0 56.99 88.9 55.6 44.5 10.00
CUSTOMER US DOLLAR YYYY .00 .0 56.99 88.9 55.6 44.5 20.00
CUSTOMER AUD DOLLAR XXXX .00 .0 56.99 88.9 55.6 44.5 30.00
CUSTOMER AUD DOLLAR YYYY .00 .0 56.99 88.9 55.6 44.5 40.00
loop until the word "DDDD" is reached
I need it to extract in different columns and paste to Outputsheet
1) Currency,
2) Bits which are XXXX AND YYYY
3) the last amounts i.e. 10.00, 20.00 , 0.00 and 40.00
output should look like
colA colB colC
Curr TYPE AMOUNT
US XXXX 10.00
US YYYY 20.00
AUD XXXX 30.00
AUD YYYY 40.00
I have a file which I have to extract data from. Unfortunately when it is converted to Excel it all prints to Column A but separate rows.
First condition within the file search in column A, within row - 1) Find "Host Fee"
2) Find "Sum Total"
Move 1 row down.
The no. of rows may vary could be between 1-4
CUSTOMER US DOLLAR XXXX .00 .0 56.99 88.9 55.6 44.5 10.00
CUSTOMER US DOLLAR YYYY .00 .0 56.99 88.9 55.6 44.5 20.00
CUSTOMER AUD DOLLAR XXXX .00 .0 56.99 88.9 55.6 44.5 30.00
CUSTOMER AUD DOLLAR YYYY .00 .0 56.99 88.9 55.6 44.5 40.00
loop until the word "DDDD" is reached
I need it to extract in different columns and paste to Outputsheet
1) Currency,
2) Bits which are XXXX AND YYYY
3) the last amounts i.e. 10.00, 20.00 , 0.00 and 40.00
output should look like
colA colB colC
Curr TYPE AMOUNT
US XXXX 10.00
US YYYY 20.00
AUD XXXX 30.00
AUD YYYY 40.00