Announcement

Collapse
No announcement yet.

Excel Sheets in Separate Tabs

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel Sheets in Separate Tabs

    Hi,

    Would it be possible to have data comparisons for excel workbooks launch a separate tab for each corresponding worksheet? That is, assuming two workbooks to be compared have matching worksheet names, I'd like to see each one compared side-by-side in a different tab in BC3.

    Thanks,
    ojc

  • #2
    Multisheet comparison is on our Wishlist, but is not currently supported in BC3's Data Compare. To compare multiple sheets, you can use our Text Compare additional download:
    http://www.scootersoftware.com/downl...oreformats_alt

    Alternatively, after installing that additional download, you can create a custom Data Compare file format that uses the same conversion process. This will not separate the data into separate tabs, but would throw all of your rows into a single large spreadsheet.
    Here is a KB article discussing how to setup a custom External Conversion:
    http://www.scootersoftware.com/suppo...rnalconversion
    Aaron P Scooter Software

    Comment

    Working...
    X