Hi Guys,

I have generated multiple workbooks from a single worksheet and later edit individual workbooks according to requirement of the data needed in each of them. Now after doing all this I am expected to generate a single master worksheet merged from different edited individual workbooks to cross check whether data present in each of the edited individual workbooks is exactly what is required.

I have about 500 edited individual workbooks and cross checking each of them individual is very difficult, and time consuming.

Hope will get some quick answers. Many thanks in advance

Regards,

Veejar