Sage MAS 90/200 Quick Tip from Zip: Excel Sheets Separator

This is a neat little tool:  Excel Sheets Separator - “Are you still bothered by the cumbersome job of splitting multi-worksheet Excel files into single-worksheet ones?  You may have created one too many sheets in Excel, and now you want to move the sheets to separate Excel files.  Excel Sheets Separator is your right choice in simplifying your tedious Excel Worksheets Separation work.  Excel Sheets Separator can divide an Excel file of multiple work sheets into several new Excel files each containing one of the work sheets of the original one.  Excel Sheets Separator 2009.6 Office Tools software developed by Excel-Tool. ($50)

One situation with Sage MAS 90/200 where this could be extremely useful is for Visual Integrator (VI) importing.  For example, lets say you receive an Excel file from your Vendor, and it contains 25 Sheets/Workbooks which represent 25 different invoices.  To properly import you’d need to manually create 25 individual Excel files.  Kind of a pain.  But this $50 program helps to really automate the process.  And don’t worry if the master Excel file contains a reference or VLOOKUP worksheet that all the other worksheets feed off of.  The data in all the newly created Excel files stays in tact.

Posted by Brett A. Zimmerman - www.brettzimmerman.com.

© 2010, Brett Zimmerman. All rights reserved. Formed in 2005. the 90 Minds Consulting Group is a collaboration of 100 Sage partners who independently join together online in a 24 x 7 private communication network to solve difficult issues for their customers. The group is not affiliated with Sage and our collaboration provides for unparalleled member access to early warnings of bugs and other issues which members in turn are encouraged to use to provide an exceptional customer experience.

Brett is an ERP and Business Management Systems professional (15+ years), based in Norfolk, MA (Metro Boston), 5 minutes from Gillette Stadium - home of the New England Patriots. Brett is a client-focused, experienced and polished hands-on professional with a versatile blend of accounting, systems and business expertise, along with a good amount of creativity and common sense. Expert level understanding of the Sage MAS 90/200 product line and related applications, including solid comprehension of integrated business management systems and accounting, as well as effectively managing and sustaining cross-functional and inter-departmental relationships with clients and prospects. Excels at performing ERP implementations, consulting, project management, report writing, import development, upgrades, training, addressing business challenges, problem-solving, needs-analyses, and proposing business solutions - while consistently maintaining client/staff retention and internal/external team moral. Impeccable organizational skills and attention to detail; exceptional presentation, verbal articulation and written proficiency standards; superb client service experience; and an absolute team player with goal-oriented personality.

Brett Zimmerman

View all posts by Brett Zimmerman
Brett's website

« What will Sage ERP MAS Intelligence include? | Home | The directory in P/L Journal and Register Maintenance Is Invalid (SOLVED) »

• 
  
  
  
  
  
  
• Ask a Question on Ask The 90 Minds Group