Is there a macro to transform System data to Column Form . Pls refer attached [ Format in Vendor Bank Sheet ]
Vendor Name Name 2 Name 3 Name 3 Bank name Bank acct SWIFT code IBAN Created by Created on
Hi David,
there's no attachment.
Phil
sorry file size too big . now trim the file for testing
Your sample is all over the place, could you possibly supply a couple of rows showing your desired results?
Hi David,
Your source data is a bit of a mess, but this might be a good start.
Ben.
Yes I know but they are consistent somehow, what I want is to extract the follow row data in column form filed data using a macro, detaisl filed to be extract as follows :
| Vendor | Name | Name 2 | Name 3 | Name 3 | Bank name | Bank acct | SWIFT code | IBAN | Created by | Created on |
I hope those data you given are dummy as they contain some sensitive data such as bank a/c no etc.
Data not genuine ie modified for macro extract purpose ..
Hi David
Give this a try.
Sunny
I tried with the test data OK
But when replace with actual ie data to run failed with following error.
so what should I pay attention when copy and place the data to the macro file
Hi David
What is the error message?
Can you post your actual file with (without the personal data)?
A few records will do, as I need to see what is in column B
Sunny
Hi David,
If the macro works with test data but not with real data then your test data is not an accurate reflection of your real data.
You need to provide test data that is an accurate copy of real world data.
If you just provide us with a screenshot of the line causing the error, but not the error message or the data that caused it, we can't debug it.
Phil
BUT CAN NOT DISLCOSE ACTUAL DATA IN THE FORUM,
MAY BE I TRIED MANUIPULATE THE ACTUAL DATA AGAIN, SEE WHAT CAUSE THE PROBLEM..SORRY THE CONFUSION
TRY SEND TEST FILE AGAIN.
