print file if value exist

[erwindebruin]

Hello,

I've a question: I like to have an excel sheet with in column a an activity and in column b a name of an person. Example:

activity1 name1
activity2 name2
activity3 name3
activity1 name4

Now i like to run a macro which:

*print document1 if value in column A is activity1 with the name listed in column B copied in document1 cell A1

*print document2 if value in column A is activity2 with the name listed in column B copied in document1 cell A1

*print document3 if value in column A is activity2 with the name listed in column B copied in document1 cell A1

Etcetera...

There are:
* 10 different activities with 10 different documents
* variabel number of names
* number of rows (in the excel sheet with the activities and the names)

How can I make this working ok?

Thanx in advance.

Erwin

 

[dtchan]

Do you mean this instead?

*print document1 if value in column A is activity1 with the name listed in column B copied in document1 cell A1

*print document2 if value in column A is activity2 with the name listed in column B copied in document2 cell A1

*print document3 if value in column A is activity2 with the name listed in column B copied in document3 cell A1

When you say document, i suppose you mean a workbook right? or is it another worksheet in the same workbooK? or is it an actual separate word document?

 

[erwindebruin]

yeah that's correct. I see i've made a mistake....

with "document" I mean "workbook"

 

[dtchan]

I can think of two ways of doing it right now.

1. add another column, that column would be the file path of the document.

You would have to write code to open the workbook and put the name in it and print it.

2. add all the individual documents as worksheets into the main workbook.
That way you can just refer to specific sheet without having to write code to open workbooks.

If you need help writing the code, let me know.