VBA to Refresh and PDF

[dash11]

I'm working on a project that involves refreshing a Template report and PDF'ing it to a folder.

I have 3 different tabs:
Tab 1) Template
Tab 2) Data
Tab 3) Company Names

Tab 1 is a report that has formulas that all refresh when one cell is changed, which is the "Company Name".

Tab 2 is the raw data that is used to update the Template once the "Company Name" in the first page is entered.

Tab 3 is a list of all of the unique "Company Names" that are individually entered into the 1st tab to create a unique report for each company name

I'm trying to create a macro that loops through a column of company names in tab 3 bringing in each name one at a time, placing it in the "Company Name" cell, refreshing the report/worksheet, and then PDF'ing it to a specified folder. The loop would in turn do this for each company name listed in tab 3.

Please help!!
Michael

[rcm]

Better to send a sample. Try recording a macro and walk it through one iteration. Then code a loop around it with the row as variable incrementing until there are no more companies..

[dash11]

Attached is the spreadsheet. Normally there are formulas in all of the cells in the "Template Report" sheet that are pulling from a tab called "Data" but I left it off since it's really not needed to build the macro. Essentially I just need to create a loop that pulls from the "Company Name" tab one at a time and puts that value in cell C5 of the Report Template sheet, creates a PDF using the Company Name in the name of the PDF being saved. Then loop through all of the company names until reaching the end.