basically I have a list of products that are provided by most vendors, when I build the cell quantity of a particular product, I would like to create as many sheets quant are suppliers who own the product. and so on for each product
This serivrà I then send a request the quote to each supplier with prodtti that I want and that any vendor can provide.
in short there a file that contains all prdotti, divided by sheets
then there are many files as there are suppliers (each file contains a list of vendor product that has the same code that is present in the fiel General)
Each time that the cell quantity is not empty, we must create many sheets estimates how many suppliers, and these new sheets must contain the entire line of that product if it is contained in the file of the supplier.
I hope I was clear
13 freelancers are bidding on average $78 for this job
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards