Hello,
Currently working on a workbook that has inventory allocation on one sheet and another sheet that is going to pull data and make an order sheet for the customer. On the order sheet, I have a table with a dropdown that is selecting the customer. Once a customer is selected, then I would like to be able to fill in the line items from the allocation sheet, on consecutive lines (old sheet had a row per product that used VLOOKUP's to pull the product information) so there are no blank row(s) between each allocated product on the order sheet.
The way I am thinking about making the macro is to first find the customer on the allocation sheet from the selected customer drop down on Order sheet. Second find all the cells with values in the column of that customer in the allocation sheet>copy and pasting into the order sheet on the respect rows. Third would be to make sure there are enough lines on the order sheet before copying a line. I can visualize what the macro will need to do, just have been not successful with the second part or combining all three parts together. any help is appreciated, even if it is part of the solution (inserting rows, finding customer, copying data). I feel like this is very complicated, but the last time I asked for help on this forum the solution wiped my 10 line macro for a 1 line code....
Thank you,
Mack
Allocation Sheet
Order Sheet
Currently working on a workbook that has inventory allocation on one sheet and another sheet that is going to pull data and make an order sheet for the customer. On the order sheet, I have a table with a dropdown that is selecting the customer. Once a customer is selected, then I would like to be able to fill in the line items from the allocation sheet, on consecutive lines (old sheet had a row per product that used VLOOKUP's to pull the product information) so there are no blank row(s) between each allocated product on the order sheet.
The way I am thinking about making the macro is to first find the customer on the allocation sheet from the selected customer drop down on Order sheet. Second find all the cells with values in the column of that customer in the allocation sheet>copy and pasting into the order sheet on the respect rows. Third would be to make sure there are enough lines on the order sheet before copying a line. I can visualize what the macro will need to do, just have been not successful with the second part or combining all three parts together. any help is appreciated, even if it is part of the solution (inserting rows, finding customer, copying data). I feel like this is very complicated, but the last time I asked for help on this forum the solution wiped my 10 line macro for a 1 line code....
Thank you,
Mack
Allocation Sheet
Order Sheet