Forum Discussion
Stocksheet cells to update on invoice
In the attached file there is a defined name "Product". This defined name refers to column A (column name is "Product") in sheet "Stock Sheet". In the screenshot the german "Bezieht sich auf" means "refers to".
This defined name is entered as source list for data validation.
Hi
I have managed to get the formula you gave me to work with the separate tab for the stock sheet. I also need the stock code to automatically populate as well.
=IFERROR(INDEX('Stock Sheet'!$C$2:$C$100,MATCH($A14,'Stock Sheet'!$A$2:$A$100,0)),"")
I added a product as test but this is not pulled in. I had to go back in and go to the Data Validation Tab again. Is there a way to avoid this please apart from selecting a large amount of empty cells?
Apologies for all of the additional posts.
Thanks
Dave
In the attached file there is a defined name "Product". This defined name refers to column A (column name is "Product") in sheet "Stock Sheet". In the screenshot the german "Bezieht sich auf" means "refers to".
This defined name is entered as source list for data validation.
Hi
sorry but I cannot get products part to work. I have attached the test sheets, really not sure where I am going wrong. If you can help it would be greatly appreciated.
Thanks
Dave
Hi, in the attached file i've converted the table in the "Stock Sheet" worksheet into a dynamic table. The dropdowns in the "Invoice" worksheet don't show empty cells anymore.
- Hi
This has been a great help, thanks very much
Dave
- Thanks very much for your help, it is very much appreciated
Thanks
Dave