I have another problem with my spreadsheet, I have some index functions referring to another sheet but even when there is no value from my combo box, it still has a price in there! How can I solve this?
(here's a shot: click here)
Posts by GOAT2G
-
-
I have just been working on a .doc file that I opened directly from an email... I saved before I exited but the changes were not saved! Is there anyway I can get it back? It must have saved it somewhere musn't it?
Please help quick!
-
My product entries start at B2 and go down. When I use the macro, it inserts a row between the headings and the 1st entry, so would this still work?
-
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!