Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to consolidate several workbooks into one?

Status
Not open for further replies.

rao1soft

Programmer
Nov 7, 2002
17
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top