Create a macro to remove previous data from an excel and populate with data in another

Hi

I am trying to create a macro or VBA script where I can remove the data stored previously and then automatically populate it with data stored in another workbook.

Apart from this also looking for macro where I can club data from many workbooks into a single workbook and same sheet.

Thanks a tons!

Here is code to cycle thru all excel files in given folder,
then combine the data into 1 sheet.

here, the given start folder is in: Range("B1").Value
ex: C:\temp

paste this code into a module, then run: CombineFiles

Please Login or Register  to view this content.

Ok thanks. Also can you help me with creating a macro or VBA script where I can remove the data stored previously and then automatically populate it with data stored in another workbook. I am able to create the macro but on running it, it populates the data only partially and not the complete data from the file it has to copy from