Data Validation per Column while Merging into One

[pab]

Hi All,

A have an excel with multiple sheets being worked on by our staff, its of same format but different location - I need to put them into one master sheet and while it is being merged there will be data validation and formatting to come up with the desired format of data.

Thanks,

 

[Deepak]

Pls share the sample files...

 

[pab]

Hi Sir, attache is the sample output file - there will be 30 worksheets of the same data format, I need to consolidate all of those 30 into one master sheet, then during the process of merging into one I need data validation like (date formats should be dd-mm-yyyy, amounts should be in two decimal places, one data should not be greater than one data).

Thanks,