I think you are going to have to post more information than this! Remember that no-one here knows your sheet layout, contents, format - or anything else!
Andy.
>i want to create an excel sheet where by i can get the inventory pre > calculated by just changing one or two data cells