I want to build a dynamic list from an existing list.
From the image you can see the list of budget items in column C. Some of those items are "savings items". Meaning I don't buy tires every month, but I want to save a little every month towards a future purchase of tires.
The list in Column I is a list I want to dynamically create from the Budget Items list in C. If you notice there is an Asterisk in column B (could be any character) that indicates if that budget item is a "savings item".
Question: How can I create a list of savings items by searching for the asterisk and populating the item and monthly savings amounts in column I, L, and M? At any time I could change any item in column B to a savings item by placing an asterisk next to the item. I would then expect the list in column I to reflect that new change.
From the image you can see the list of budget items in column C. Some of those items are "savings items". Meaning I don't buy tires every month, but I want to save a little every month towards a future purchase of tires.
The list in Column I is a list I want to dynamically create from the Budget Items list in C. If you notice there is an Asterisk in column B (could be any character) that indicates if that budget item is a "savings item".
Question: How can I create a list of savings items by searching for the asterisk and populating the item and monthly savings amounts in column I, L, and M? At any time I could change any item in column B to a savings item by placing an asterisk next to the item. I would then expect the list in column I to reflect that new change.