Hi Guys,
I am currently using pivot tables to get our current cost of good prices for thousands of products via thousands of lines of data, so as you could imagine its very time consuming. I've been trying to come up with a way to automate it, but I'm coming up with blanks.
I'd like to be...