bturner2
09-02-2004, 10:27 AM
Here is what I am trying to do. I have a workbook with 10 sheets in it. In cell A1 I have a name. Each sheets has a different name. Such as Bill, Ben, Bob....
What I need is for my script to look at cell A2 of each sheet,and see if the number in the cell is greater than 1. If it is greater than 1 I need it to copy the name that is in cell A1 and remmber it. When it has checked all the sheets I need it to display a mesage listing all of the names of the sheets that cell A2 was greater than 1. I also need to be able to have a button on the message that is displayed that will allow me to print the list.
Anyone want to give this a shot? I just dont have enough hours in the day to figure it out. Thanks.
What I need is for my script to look at cell A2 of each sheet,and see if the number in the cell is greater than 1. If it is greater than 1 I need it to copy the name that is in cell A1 and remmber it. When it has checked all the sheets I need it to display a mesage listing all of the names of the sheets that cell A2 was greater than 1. I also need to be able to have a button on the message that is displayed that will allow me to print the list.
Anyone want to give this a shot? I just dont have enough hours in the day to figure it out. Thanks.