I am doing a spreadsheet that has a sheet with some stock on it. I have a column entitled 'Product' which contains motherboard products. I have named that range as motherboards.
I have a macro that allows the user to add an item to the motherboard list from a separate sheet; but the named range doesn't continue with the addition.
How can I make it so the named range expands with every addtion to the sheet?
I am really stuck so any help would be appreciated!