H. Lee Moffitt Cancer Center & Research Institute

EIC Merge


Intruction

EIC Merge abstrct a particular column - EIC - from all the sheets of a Workbook and create a new sheet by combine these columns.


Implementation

EIC Merge is deployed as an Add-in of Microsoft Excel application. This add-in will add a new menu to Excel as the following figure shows:
Picture1

The new menu is called “Haura Lab” and it currently has three menu items:

  • Get Sum
  • Merge EIC
  • About
The second menu item – Merge EIC – is used to abstract the "Area" column in each sheets of the Excel workbook as show in the following figure:
Picture1

The "Area" columns from all the sheets are combined together to create a new seet called "Merged EIC" as the following figure shows: Picture1


Download

The Excel add-in can be download here.

 


© Copyright 2008 Bioinformatics, H. Lee Moffitt Cancer Center & Research Institute