The below formula is to return the quantity of the product from another sheet.
=VLOOKUP(MID(CELL("filename"),FIND("[",CELL("filename"),1)+1,10),'Z:\PartList\[DESC.XLS]Sheet1'!$A:$C,3,0). I have individual sheets for products and one master sheet for quantity.All the file name for the products is the file name itself. So I can use the above formula.
But the problem is when I press F9 for one product, the quantity for that product is applied to all the open files with the above formula. I know the problem is with =Cell("filename").
Hope the problem is explained well. Need attachments? Any solution to stop changing quantity in all open files.
Thanks,
Itty.
Bookmarks