Help with Excel

H

Harish

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
 
E

Ed

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
 
E

Ed

Re-reading your original post, I may have gotten the wrong idea. I think
when you said you have "a separate excel sheet for each of these
checklists", I assumed - perhaps incorrectly - that you have a separate
Excel *workbook* for each checklist.

My first idea was one workbook with all of your lists as separate sheets in
one workbook. If you have 10 checklists, you would have one workbook with
10 sheets. When the workbook opened, a UserForm with option buttons,
drop-down list, or other input control would pop up, allowing the user to
select which checklist was required, and then show only that worksheet,
hiding all the others.

Another idea - and maybe closer to what you wanted - would be to put the
checklists down one sheet (list 1 would take, say, rows 1-25, list 2 rows
26-50, etc.). A form would take user input to determine which list was
required, and take the user to the first row for that list. Any rows not
needed for that checklist could be hidden. Or the workbook could hide the
first sheet and open to a second sheet, which explains everything and allows
the user to make inputs(s) by selecting or inputting a value into a cell. A
button on the second sheet would evaluate the input, hide the second sheet,
show the first sheet, and take the user to the correct list.

Anything sound like what you want?
Ed
 
H

Harish

Hello Ed,
I have followed your suggestion and was successful in implementing it.
Thanks for the help

Harish
 
Top