Hi
I'm trying to automate a sales quote sheet with selected products/rows from a main price list sheet. I have this "All Products" sheet with appx. 500 rows and 12 columns. When an item is selected - number of the item is put in column "F" - I would like to auto copy 9 of the 12 columns in that row to a different sheet "Quote" The items list in the "All Products" sheet start in row 9 but in the "Quote" sheet the selected items could start in row 5.
I´ve attached a sample xlsx file with part of the list.
Hope this is clear enough - thanks for any response.
Kind Regards
Agust
Bookmarks