VBA LOOP Help

[dbright]

Hi all,

I have a repetitive process that I am trying to automate which consists of the following steps:
1) Take 5 pieces of data from a record on worksheet A with 200 records and input those pieces of data into worksheet B
2) Take Worksheet B and save the tab as a PDF in a new location
3) Name the PDF after a cell in the record
4) Repeat until all 200+ records are done resulting in 200+ PDFs in a Folder

I have the VBA done for one record, but how do I loop all of these steps over and over until all records are completed?

Any help would be greatly appreciated as any attempt at looping has been unsuccessful thus far.

Thanks,

DB

 

[RCBricker]

you need to dim and set a couple range variables.

dim rng as range, cell as range

set rng=activesheet.range("A1:A10")     'your range of data in worksheet A (only need one column)
for each cell in rng
your code for creating and naming the PDF file
next cell

 

[dbright]

Ok thank you. I will create my code and may have an additional question if I mess it up.

you need to dim and set a couple range variables.

dim rng as range, cell as range

set rng=activesheet.range("A1:A10")     'your range of data in worksheet A (only need one column)
for each cell in rng
your code for creating and naming the PDF file
next cell

 

[Norie]

Can you post the code you have for one record?