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!

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

Combining Worksheets

Status
Not open for further replies.
solidjp

solidjp

Programmer
Jul 16, 2002
29
US
I have 2 or more different excel workbooks with 1 worksheet of data in each workbook. I need to put all the worksheets into one new excel workbook. Either by combining all the worksheets into one big worksheet, or each having there own worksheet in one big workbook. Do I need to do some copy and paste methods for doing this or is there a better way. I know it can be done, I just can't figure it out. Oh yeah, using VB 6 and Excel to do this.

Thanks in advance.
 
Sort by date Sort by votes
Surely you'd be better off posting this in one of the many VB forums Rgds
~Geoff~
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

K
  • Locked
  • Question
How to resolve define worksheets array
Replies
1
Views
581
combo
combo
arvarr
  • Locked
  • Question
Excel Help - Worksheets by UserID 3
2
Replies
39
Views
781
arvarr
arvarr
BxWill
  • Locked
  • Question
MS Excel VBA - Create Hyperlink to Worksheets based on value in row
Replies
2
Views
106
Andrzejek
Andrzejek
BxWill
  • Locked
  • Question
MS Excel VBA - Merge certain worksheets into one worksheet 1
2
Replies
23
Views
376
SkipVought
S
Eitel13
  • Locked
  • Question
Creating Worksheets based on Filenames
Replies
9
Views
244
Eitel13
Eitel13

Part and Inventory Search

Sponsor

Back
Top