Creating lists based on category

**NearClueless** · 03-06-2009, 02:04 PM

The goal here is for users of this form to enter the "type" of tool and automatically create a list of tools based on the "type" in another sheet (NEW SHEET). See the heading on that sheet in the file for more info.

Also, keep in mind that this would be a template (.xlt) for 2003 and all the sheets would be individually locked -- password protected.

Since this form will be filled in by folks that aren't very computer savvy in general, I'm trying to make this as simple/automatic as possible. I myself have a limited toolbox as well. I'm not entirely sure a program would be needed (IF statements in the cells?) so please let me know if this thread belongs elsewhere...

Thanks in advance.

**NearClueless** · 03-09-2009, 10:52 AM

bump -- no reply

**NearClueless** · 03-10-2009, 03:55 PM

bump bump.

Please let me know if there's a solution in a different thread or if this doesn't belong here...

**teylyn** · 03-10-2009, 04:02 PM

Hi,
I'm sure there is a solution, it's just that I have not figured out the question yet. Looking at your sheet, I still don't have a clue what you are trying to do. Can you try and put it in words like WHERE data is being entered and what you think should happen with it and where it should be displayed?

cheers