-
It is possible but unreasonable to do so with the raw data as provided. For data to be processed, it has to be consistent. Your date information has varying formats; the layout differs between sheets; you have blank sheets and one full of 6Ô\'søÂÓñª’Ð (I quote).
The inconsistency in sheet order that you do note is not important.
Fix your data and repost the workbook.
From which book do you intend to run the code?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Reply With Quote