Hello,
I am new to VBA. i am needing help uploading a workbook sheet from different workbook file. Im learning VBA from one of my bosses and need some help completing his next project for me. i dont know how to upload a sheet to start the project and could figure out the rest of the project myself. here is the project below if any one can help. and thank you to the people that point me in the right direction
--------------------------------------------------------------------------------------------------------------------------------------
I would like for you to input that data on a spreadsheet as follows:
<tbody>
</tbody>
In Cell A, put the person’s name, in cell B input the persons score and in cell C put whether they were Above, Meet or Below the CPH goal. However there are a few extra pieces that I would like to add to make it more challenging:
1. On the spreadsheet with your code, I would like only the name in column A filled in before the code fires, meaning B and C columns only contain headers, no data.
2. The code will open the attached spreadsheet, locate the colleagues name and pull the data for column B based on a name match.
3. Then the code, based on the data pulled in column B, will fill in column C based on this formula (10.99 or < = Below); (11-12.99 or < = Meets); (13+ or >= Above).
4. All of the code must be placed in a module and not in a SUB. For instance, if I press the button (FIRE CODE), there should only be one line of code in the SUB, all of the rest of the code should be written in a module.
I am new to VBA. i am needing help uploading a workbook sheet from different workbook file. Im learning VBA from one of my bosses and need some help completing his next project for me. i dont know how to upload a sheet to start the project and could figure out the rest of the project myself. here is the project below if any one can help. and thank you to the people that point me in the right direction
--------------------------------------------------------------------------------------------------------------------------------------
I would like for you to input that data on a spreadsheet as follows:
| Full Name | Calls Per Hour | Above/Below Goal |
| Rep 1 | 14 | Above |
| Rep 2 | 11 | Meets |
| Rep 3 | 10.99 | Below |
<tbody>
</tbody>
In Cell A, put the person’s name, in cell B input the persons score and in cell C put whether they were Above, Meet or Below the CPH goal. However there are a few extra pieces that I would like to add to make it more challenging:
1. On the spreadsheet with your code, I would like only the name in column A filled in before the code fires, meaning B and C columns only contain headers, no data.
2. The code will open the attached spreadsheet, locate the colleagues name and pull the data for column B based on a name match.
3. Then the code, based on the data pulled in column B, will fill in column C based on this formula (10.99 or < = Below); (11-12.99 or < = Meets); (13+ or >= Above).
4. All of the code must be placed in a module and not in a SUB. For instance, if I press the button (FIRE CODE), there should only be one line of code in the SUB, all of the rest of the code should be written in a module.
