Combining Two Workbooks

  • Thread starter Thread starter VETcalc
  • Start date Start date
V

VETcalc

I have two applications that I would like to combine into one
workbook.

Is there away to do that?

Thanks,

Bo
 
Hi
not very specific: What kind of data do you want to combine, how is
your current data layout, etc.
 
If you mean you have two workbooks atht you would like to have as one, then open
both, then pick one and select all sheets by clicking on the first tab, holding
down SHIFT and then clicking on the last tab. Now right click, select Move or
Copy, then from the dialog box presented choose your other file from the
dropdown (Do NOT tick the create copy option, else you may end up creating
unwanted links between the files) and hit OK.
 
Move all your code in workbook with XLA extension (and save it under
that extension). Then use reference to that file over Excel menu
Tools|Add-Ins..
You can call then any of your function to any your workbooks.

HTH
Billy
 
Back
Top