Forum Discussion
Solved
Stocksheet cells to update on invoice
Hi I have stock sheet with a list of products. There are only 26 on the test sheet. I would like to reference the cells in an invoice. The products have a name, stock code and price. I added ...
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