Hopefully someone here can help
I have a product list in one spreadsheet, which has a load of dependent drop down boxes, so i can select the supplier, brand, product etc
Once i have select the product i want from the drop down boxes i want to press a "button" of some sort that will transfer the data in the boxes to another excel file
However this file then needs to be emailed so it cant actually have "links"/llookups to the product list file, so need to do something similar to a mail merge i guess
Im guessing i will need to play around with VBA/Macros?
If so what would the code be so that when i press an "order" button, data in A2 in "db.xlsx" goes to D6 in "orderform.xlsx" and data in C2 goes to E10?
Hope this makes sense! its been many many years since ive done tricky excel/vba stuff so any help is appreciated