Log In
Register
Home
December 5, 2016
Offline
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
October 5, 2010
Offline
Hi David,
there's no attachment.
Phil
December 5, 2016
Offline
sorry file size too big . now trim the file for testing
December 21, 2018
Offline
Your sample is all over the place, could you possibly supply a couple of rows showing your desired results?
Active Member
August 25, 2016
Offline
Hi David,
Your source data is a bit of a mess, but this might be a good start.
Ben.
December 5, 2016
Offline
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 |
VIP
Trusted Members
June 25, 2016
Offline
I hope those data you given are dummy as they contain some sensitive data such as bank a/c no etc.
December 5, 2016
Offline
Data not genuine ie modified for macro extract purpose ..
VIP
Trusted Members
June 25, 2016
Offline
Hi David
Give this a try.
Sunny
December 5, 2016
Offline
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
VIP
Trusted Members
June 25, 2016
Offline
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
October 5, 2010
Offline
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
1 Guest(s)
