Hello,
I'm trying to set up a file that makes it possible to search through a pricelist and quickly adds the data from the item you picked to another table (where you do all the calculation ndr).
I solved the search part through a simple Conditional Formatting Formula, but I've no idea how to set a Macro Link for each row that picks the data (Item, Description, Price) and adds it to the "Products" table, so that people can do the configuration in the first sheet and then do all the calculation in a second one.
Thank you in advance for the help!!
Silvia.
I'm trying to set up a file that makes it possible to search through a pricelist and quickly adds the data from the item you picked to another table (where you do all the calculation ndr).
I solved the search part through a simple Conditional Formatting Formula, but I've no idea how to set a Macro Link for each row that picks the data (Item, Description, Price) and adds it to the "Products" table, so that people can do the configuration in the first sheet and then do all the calculation in a second one.
Thank you in advance for the help!!
Silvia.
