Muliple print outs from one proforma

[rhino4eva]

i work in a hospital laboratory and we are performing an antibiotic study.
i have a work book consisting of 2 sheets
1 sheet is a list 7 antibiotics in a column for a1 to a8
2 sheet is a blank results sheet

what i want to do is print out the blank result sheet once for every antibiotic on sheet 1
with the name of the antibiotic in sheet 2 pos "a,1"

i have copied the blank 7 times and linked to the antibiotic list but this seems very untidy

is there a way to print out 7 identical sheet2's differing only by reference to sheet 1 a1 to a8

[dilipandey]

Hi Rhino,

Welcome to the forum.

You can have multiple sheets where A1 of those sheet would be linked back to a1 to a8 of the original sheet respectively... Hope I have understood your query, if not please elaborate more. thanks

Regards,
DILIPandey


<click on below 'star' if this helps>

[rhino4eva]

perhaps it's because i'm a newbie

but

i was looking for a macro to print out the 7 report sheets from just one "constant" report with the antibiotic variable in the top corner of each, not simply printing out 7 separate reports

Thats too untidy

[dilipandey]

Okay... so you need that the same report will be printed but with different variable (antibiotic name) which you have in A1 to A8 ?

regards,
DILIPandey

<click on below 'star' if this helps>

[rhino4eva]

in a nutshell yes.. as long as the antibs are on sheet 1 and "report" is on sheet2

[dilipandey]

Hi rhino4eva,


Firstyou should create different copies of sheet 2 and then you can use lookup function / offset function to have antibs name per sheet. Upload a sample workbook in case of any issues. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>