Quote Originally Posted by geekgirlau
When you say you are "consolidating" them, what exactly are you doing?
I posted for help on the consolidation work last time in this forum (Solved: Copy Paste using macro involving 6 different workbooks). Well, what happens when macro runs:
1. prompts user to select folder to clean
2. cleans all excel sheets in folder (several Excel sheets inside. Each .xls has one sheet only)
3. create a new folder called 'Cleaned' & dumps every cleaned file into it with a saved as name (new name)
4. creates a new workbook called Master
5. copies from all the cleaned files & pastes into the Master. Saves Master. Macro ends.

So now, I'm facing some probs with the formatting when I paste it into the Master. In the cleaned file, it is ok. But once it transfers, the formatting goes bonkers.

Eg: Original text: 5/13, 10/53, 8/37 (it's column size per cm)
After consolidation: May-13, October-53, August-37'

How to solve this when I've already included the codes (in previous reply) into my macro? All help much appreciated!!