macros... help!

[Guest]

How do I write a macro... I need to create one that will
print a form for me. The macro will need to go through a
list of several departments and insert that departments
info in the form & than move on to the next on. We are
in the process of converting from Lotus to Excel... the
macro worked in Lotus... but it has been around much
longer that I have!

 

[Ron de Bruin]

Hi

Do you have formulas (Vlookup) on the form to get the information
of each department.
So if you change the department name in a cell all other cells change???

 

[Guest]

No... there is one row at the top of worksheet "B" (which
is where all the info is located) that links to the form
on worksheet "A". For example if we need to reprint only
one form we just copy the row that department's info is
located on & paste it on the row that links to the form.
The problem is when we need to print all of the
departments... it would be crazy to go through that
process one by one.

 

[Ron de Bruin]

there is one row at the top of worksheet "B" (which

is where all the info is located) that links to the form
on worksheet "A".

Are the rows of the other departments also on this sheet