Hello All,
I am currently working on an excel sheet that is a master list of all the products sold by the company I work for. Some of the information on this sheet will be used to fill out an individual Product Order sheet which is a word document. What I would like to do is auto-fill the information from the excel sheet into the sections of the word document.
Each product has a "style code" that would be picked from a drop-down box that would possibly trigger this auto-fill. I'm also wondering if maybe there is a function in excel where I could essentially create a "button" by each row that could be clicked and would then auto-populate the word document.
My knowledge of Excel is intermediate I would say, but basically self-taught. I know that it will probably be a "macros" function but I've never used that and don't really know what it does. If there is any more information I need to provide to help figure this out let me know.
Thank you very much in advance, this would be huge for effeciency and saving time.