| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
| Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
| Display 2 formulas from source workbooks to destination workbooks | Excel Discussion (Misc queries) | |||
| suddenly my excel workbooks are "shared workbooks" | Excel Discussion (Misc queries) | |||
| Set buttons to own workbooks, but not to general workbooks. | Excel Programming | |||
Threaded Mode
