View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kbob Kbob is offline
external usenet poster
 
Posts: 2
Default copyingsheets between workbooks with same name

Ok, I think this may be a complicated one.

I have two workbooks lets call one A the other B

in A I have 30 sheets and in B I have 10 sheets.
I want to create a form box that will allow the user to first Browse for
Sheet
B (or any workbook name) and then when clicking OK the macro will copy the
data from any sheet in workbook B that has the same sheet name in workbook A.
This could be only five of those sheets. Keep in mind they number of sheets
in each workbook could be more that 5 or 10 and that the sheet names are not
the same each time (although some, the ones I want to copy from B to A would
have the same name)
Make sense.
Thanks and Happy New Year