Consolidation Values only

[ravichandavar]

Hi All,

I need a macro which can consolidate the data from all the sheets in file and gives master sheet in same file.
(Master file should have only values ).

Thanks,

[Excel Fox]

Hi ravichandavar,

This is what you are looking for

http://www.excelfox.com/forum/f13/consolidate-multiple-workbooks-from-a-folder-into-one-master-file-vba-569/