wildsideuk
New Member
- Joined
- Sep 6, 2020
- Messages
- 1
- Office Version
- 365
- 2016
- Platform
- Windows
- Mobile
- Web
Hi all, any help appreciated.
I often need to produce simulated sales orders for a client with up to 10 seperate customers and up 20 products each (with up to 7 of each product). At present I have to do this one customer at a time, I have a macro that randomly selects 1 of 493 customers and then I have a msgbox to enter number of products which are randomly selected from 1300. Both the customer and the products aer on separate sheets but copd to single sheet with the products listed in columns K and quantity in L (I manually need to add this). I do this for all 10 random customers.
Is there any way to have excel take a random customer from sheet 1, however many products I entered from sheet 2, combine both in sheet 3 and then if I run the process again it adds the new data to the next empy rows? I need headers for this process too although I can add them as a final process if omited intially. Headers appear in all 3 sheets, sheet 3 headers are also present in sheets 1 & 2.
I often need to produce simulated sales orders for a client with up to 10 seperate customers and up 20 products each (with up to 7 of each product). At present I have to do this one customer at a time, I have a macro that randomly selects 1 of 493 customers and then I have a msgbox to enter number of products which are randomly selected from 1300. Both the customer and the products aer on separate sheets but copd to single sheet with the products listed in columns K and quantity in L (I manually need to add this). I do this for all 10 random customers.
Is there any way to have excel take a random customer from sheet 1, however many products I entered from sheet 2, combine both in sheet 3 and then if I run the process again it adds the new data to the next empy rows? I need headers for this process too although I can add them as a final process if omited intially. Headers appear in all 3 sheets, sheet 3 headers are also present in sheets 1 & 2.