Need a macro that references a list and then prints data retrieved

[Crimson Bourne]

Can someone help me please. I am needing a macro that will go through a range of departments on "dept" tab and put the dept number in cell A5 of the "Expenses" tab and then print the Expenses. As the department number changes I have a database that will retrieve new data for each department so I am wanting to print after each department's data is populated.
In addition, if anyone knows how I could email instead of print based on a range of mail reciepients tied to each department would be great. My email platform is Lotus Notes.
Thanks in advance.

[JBeaucaire]

Based on your example, this would cycle through the dept codes and print the Expenses sheet.

Please Login or Register  to view this content.

No clue on Lotus Notes.

[Crimson Bourne]

JBeaucaire - this worked great for the file that I uploaded. However, my actual dept list has depts such as "0502.100" and when the macro cycles through the list it drops the zero in front and will not refresh the data.

thanks for the help

[JBeaucaire]

Format cell A5 as TEXT instead of GENERAL. Then try again.

[Crimson Bourne]

Format cell A5 as TEXT instead of GENERAL. Then try again.

That did it. Thanks again.