AboutAidan Heritage Expertise I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for
all versions from 2 onwards
Experience My background is in the insurance industry and call centre areas, but have been called upon to provide many varied solutions.
Education/Credentials I'm educated to UK A level standard, but as I left school some 30 years ago that is rather irrelevent - university of life has provided more of a background!
Hello! I've created an excel workbook which works as a costing tool for my business.The 1st sheet contains all my supplies where I can add/update items to if need be, and then the 2nd sheet is my costing sheet where I have several comboboxes from which I can select certain supply items that I have listed on the 1st sheet.My question is, is there a worksheet function/macro/code that'll automatically update the comboboxes in the costing sheet as I make additions to my supply list? Because now,as I add more items to my supply list,it messes up the selections in the costing sheet because the comboboxes aren't updating as I make changes to the supply list on sheet 1. Since I use the costing sheet as a main form to cost several groups of items separately and need to generate copied sheets of it as an archive, it would be highly impractical for me to keep updating the combobox input range and re-selecting the correct items that are now messed up because of the changes made to the supply list
(because naturally the combobox's cell link would be referring to another item). I'm really not that well versed with codes and such so any help you can give me would be really appreciated. Hope you can help me, thank you :)
Answer I think you basically need a supply list that continues to grow, but never re-orders - the issue (as I see it) at the moment is that the list is being re-ordered. I would PROBABLY see Visual Basic as the solution, where a stock list is kept up to date but seperate from the main file
It would help to see the file you are working with - my email is aidan.heritage@virgin.net.
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
