I would suggest that you post a file with some sample data. that way everyone can see or understand what exactly you need to accomplish. enter some sample data as it would appear after import , then show the result you need after the formula or VBA code is ran against that data.
Bookmarks