Sun 19 Jan 2020

Excel Quiz 60

By |Sunday, January 19th, 2020|Categories: Quizzes|Tags: , , , |0 Comments

A general quiz on Excel

Sat 04 Jan 2020

Article 48 - Split A Workbook into Multiple Workbooks on the basis of a Column

By |Saturday, January 04th, 2020|Categories: Articles, VBA|Tags: , , , , |0 Comments

Sometimes, we need to prepare multiple workbooks on the basis of entries in a column. It is all the more useful in organizations where you need to send files to stakeholders.  For example, in below sheet, you want to split the files on the basis of entries in column C. You may also like to prepare 3 files on the basis of entries in column D. (more…)