VB Code that looks at a cell and changes the field in a pivot table.

[VB Newbie]

Hi

I've got a cell in a report, which is changeable and I want it to change the report filter in a pivot table.

I am wanting to create a bit of VB, I have looked through the majority of comments but I cant find the solution.

I have a spreadsheet where by there is a drop down menu with a list of 'Products' upon choosing a product it then calculates all the other fields, e.g. sales. stock that I have etc.

However as my website http://www.thecampingoutlet.co.uk expands I don't have time to go through each product and save to PDF.

I am hoping for a bit of VB which looks at the drop down list and produces all the PDF files. (Will give me more time to actually analyse the reports not just run the reports) and hopefully create a much better website.

The problem is that in sheet two it has two pivot tables and in the first one is how many returns I've had off a product, and second how many page views each page has had. (on Some occasions these can be blank, especially the first pivot table).

I then need to the VB to look at these two pivots and if anything matches the product code paste the information into the report, before publishing.

I'm more used to using MySql etc but have been told that by using a bit of VB on my reports I can save time, I've learnt the basics etc but this is above my head.

Any help would be kindly appreciated.

Thanks in advance

Andy