Posts by GOAT2G

    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)

    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!