Hi,
I have several workbooks (each with just one worksheet) in a directory folder. I want to consolidate them (move them all) into one workbook (can be the first one of the bunch or a new one) each as a separate worksheet. I can do this manually by move/copy each sheet to the main one, but am looking for a simple macro to automate this.
TIA,
--Rao.
I have several workbooks (each with just one worksheet) in a directory folder. I want to consolidate them (move them all) into one workbook (can be the first one of the bunch or a new one) each as a separate worksheet. I can do this manually by move/copy each sheet to the main one, but am looking for a simple macro to automate this.
TIA,
--Rao.