Hi! I'm new here and this is my first post. Hope you can help!
I just landed my first job after finishing my education and one of my first tasks was to try and speed up the paper work processes in the office. We function as a sales/service/contractor for parts and systems in the energy sector. Whenever a client needs something, a parts list pops up in my email chain. This might be a .pdf, .jpg or just plain text, so it is manually entered into a quote calculation sheet in MS excel 2016. This is fine and works great.
However there are four more excel sheets that needs to be filled out in order to have everything properly arranged and billed. The customer gets a quote, an invoice and also a packing slip. Additionally we send a purchase order to the supplier.
What i would like to do is to somehow make excel auto fill these documents so that they also dont have to be typed up manually. They all contain the same information from the first document (quote calculation) and the text and numbers entered into these cells (manually) needs to be copied and pasted into different cells in different sheets, so that the four new documents gets created automatically.
I had a look around and i found a video showing how to combine two different spreadsheets into one in the same workbook. This is generally what i need to do. It showed how to use the "data from other source" and "microsoft query", which i think is the key here. But i don't know!? I'm relatively new to this and would definitely like to learn more.
Anyone know if and how this is possible?
Thanks in advance.
"Im using excel on Mac as we speak, but when my company laptop arrives, i'll be on Windows"