Hi Chaps,
File in Question: Excel Help.xlsx
I'm trying to get my invoices slightly more automated as it's taking me time just to make them up, currently I just have a word template that I am using and I manually fill out all the spaces then go to export it all as a PDF.
I've recently found out that I am export order information from my website (a weebly shop) and it seems that I am missing a trick here getting my invoices automatically (or as much as they can) filled out for me so I can concentrate on some other stuff. I can build the same template I have again in excel no problem, it's just going to take some time, but I need some help and guidance in how I should proceed.
What I am struggling with
Now I get the raw data in and it is all laid out according to the order number, but the rows do not contain all the data I need, instead each item they buy is listed with the same order number on the line below.
What I am trying to do
What I am trying to do, is to just be able to use a drop down list to select an order number. This then pulls all the rows with that associated number into a different sheet. What I have so far just uses a VLOOKUP to pull the different columns I need in, but it can't bring in the different items ordered as they are on different rows BUT have the same order number.
It's a bit hard to explain, but here is my best attempt.
You first select which order number you want to invoice for (seen here you can see multiples of the same order number... that's because it exports whatever items you have bought onto a different line.)
hnSbTWz.png
When you select the order number you want, it pulls in everything for that number but leaves out the other order numbers.
D2TRw6f.png
After this, I can just match cells to cells to get my template working all okay. The reason I need it like this is so I can itemize the invoice for separate items and not just the whole lot. Again, this might not be the best way to do it ... but I don't know how to use macros and my excel knowledge is limited!
Any help is greatly appreciated. If I can get this done, its going to save me so much time at work that I could be spent doing other things... like reddit!
Cheers,
Grady
Bookmarks