Hi all,

It's my first post here so please don't be too harsh if my post in miscategorized. I am working on a relatively simple nutrition tracking calculation worksheet.

I have two worksheets:

Worksheet A-contains a table with a list of foods and several columns that contain the nutrition information.

Worksheet B-contains food entry drop down lists and runs simple SUM() calculations on them and presents me with a chart of the data.

My question is the following; my food list drop down is populated from the food list table. How can I make it dynamically expand the selected range of cells whenever I add a new food (row) into my food table? I would like my source range selection to grow by the number of rows that I am adding to my table.

Any input is appreciated.