If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copying Certain Worksheets depending on certain criterion
I have an excel file that contains multiple templates that I need to copy
depending on certain criterion. I have set up two columns for this purpose. The first column contains the names of the worksheet to be made and the second column will be which template to copy. I have been trying to figure out a way but stuck and would appreciate it if you guys can help. The pseudo code of what I'm trying to do is as follow: Loop if cell A is not null and cell B is null copy template 1, else if cell A is not null and cell B is "Temp 1" copy template 2 else if cell A is not null and cell B is "Temp 2" copy template 3 else if cell A is not null and cell B is "Temp 3" copy template 4 else if cell A is not null and cell B is "Temp 4" copy template 5 end loop Thank you. -- Message posted via http://www.officekb.com |
Thread Tools | |
Display Modes | |
|
|