My first thoughts, Harrish, is to create one workbook with your checklists
on different worksheets. A UserForm in the VBA project could open the
workbook to the sheet indicated by the user's inputs, keeping the others
hidden.

HTH
Ed

"Harish" wrote in message
om...
Hello,
I have different kinds of checklists based on the requirements. As of
now I have a separate excel sheet for each of these checklists. Is it
possible that I can have everything in a single excel sheet wherein if
a user selects few options he will be shown with the corresponding
checklist items. Can that be done in excel. If so could anyone provide
me with some guidelines as how to do it
Thanks
Harish