I posted a similar file to the one I'm sending a while back. I thought the issue was resolved, but when I download the information, it comes out asymmetrical, and the code used to find it picks up some cells that are out of range.
The situation is:
I work with an accounting system called SAP, and ever so often I've got the "privilege" of updating a vendors list. The System spits out the information in a jumbled manner. I thought the information was uniformed, but to my dismay, it isn't. In Columns C, J, and M, on the sheet named "Confused Dump" I need to get the information relating to the cells beside the cells B8, B19, B22, B28, etc (vendor, City, Street, Pay Term, etc, I've highlighted them in green), and I need to put them on the sheet named "Completed_Format" in the format on that sheet.
The columns always have the same data, but not in the same row sequence.
I tried adapting a code seen here, but it didn't work. Is there some code that can solve my problem?
I've attached the file with the information changed. The Confused_Dump information goes over 40000 lines on the original dump.
Leith Ross gave me the following code, but it worked because most of the information was symmetrical.
Thanks,
Xrull
Bookmarks