dynamic lists

Hi, I have a list of Current Ingredients Used and I want to use this list in a variety of different workbooks. When I change the source, delete or add an ingredient, I would like all the lists to reflect the change. I know there is a way with named ranges but that doesn't allow you to add...

Hello everyone- I'm not quite sure how to phrase my question, so I'll ask by way of an example. Let's say I have a dynamic data set like the one below. (Assume people are always adding, deleting, and changing entries.) <colgroup><col width="79" span="2" style="width:60pt">...

Hi guys, I've been looking around for ages but can't seem to find anything similar to what I'm looking for. I have a spreadsheet with a list of peoples names running down column A starting at A15 to A90 (The range will grow and shrink) A14 is labelled name. b14 is option 1, c 14 option 2 etc...

I need to find a way using VBA to identify multiple activites on a particular day. Example: Monday ------------Morning Session with Adam Adam Monday ------------Lunch with Adam Adam Monday ------------Afternoon Session with Adam Adam. These...

Hi all, I've been trying to build a dynamic array that can be changed by using 2 combo boxes. I have managed to populate an array of "pizza places" that can carry the same peer group. So that one dropdown box selects a pizza place the other selects a peer group. Currently, if I select "Pizza...

Hi guys, I have created a userform where I have a combo box and an options box. I want the combo box to reference a specific list of values. And if the check box is selected, I want the same combo box to reference a different list of values. This is the present syntax I am using. For some...

I need help with a formula that will dynamically create a subset list of names from a larger list. I can use countif to get the number of results but how do I get it to show the actual results? For instance, I have a list of employees and the offices that they work in. on a separate sheet in...

I was wondering if anyone on this forum could assist me. I am an attorney (don't hold that against me lol), and I'm setting up an Excel spreadsheet for my small firm's data set. On Sheet1 I have a list of client Names, for example: SHEET 1 COLUMN A Adam Bob Charles Daniel Edward Frank On...

Hi, I produce a radio show of foreign-language music. I have a huge table (currently 6000 rows) of all songs I've played, organized alphabetically by country. I'd like to create a list of all unique countries, with sublists of every time a band was played. Every list will be a different length...