Hi,
I would like to create a macro which does the following:
1) Write a string in cell J16 in "worksheet1". The first string is taken from cell B2 in "Worksheet2". Step 1-3 should be repeated for the range B2-B292 in "Worksheet2" (290 times)
2) The string in cell J16 is used by other cells in "Worksheet1" to find reference values in several other worksheets (no separate coding needed for this step).
3) After each "new" string in cell J16 the first 10 pages of "worksheet1" should be saved as pdf. The name of the pdf file should be taken from cell J16.
This should lead to 290 different pdf reports. That is it. Thanks in advance for you help!
Kind regards,
Rene
I would like to create a macro which does the following:
1) Write a string in cell J16 in "worksheet1". The first string is taken from cell B2 in "Worksheet2". Step 1-3 should be repeated for the range B2-B292 in "Worksheet2" (290 times)
2) The string in cell J16 is used by other cells in "Worksheet1" to find reference values in several other worksheets (no separate coding needed for this step).
3) After each "new" string in cell J16 the first 10 pages of "worksheet1" should be saved as pdf. The name of the pdf file should be taken from cell J16.
This should lead to 290 different pdf reports. That is it. Thanks in advance for you help!
Kind regards,
Rene
