Hello.
I have a workbook that tallies sales information for individual sales reps and needs to automatically send that information to a summary page. The rep sheet has seven columns of possible information, but the summary sheet needs to only summarize five of those columns, but fill in an additional unique column with the reps name (taken from the sheet name).
I have posted about this workbook before, but my company has just changed the "official" format of part of it - which basically amounts to a complete overhall, which happens to mess up the code entirely and I have to start all over .
I have posted a basic version of the workbook, so whatever solotion comes of this, I will probably need your help to expand the code to cover and additional 13-15 worksheets for the real workbook.
Everyone's continued help is greatly appreciated.
ragamuffin