ggtrixabell
New Member
- Joined
- Sep 18, 2017
- Messages
- 7
Hi,
I am very new to VBA and have been struggling to find everything I need in one place to complete a task I'd like to do. Any help would be much appreciated.
I have a risk register which captures threats and issues that may occur within my projects. The outcome of those could be a task or an opportunity. I would like to be able to have the team click a button which then runs a macro to look at any risks or issues that have an outcome as 'TASK' and then copy the details to a separate worksheet in my workbook so that the task table can be progressed away from the main capture table. The same goes for any opportunities.
The data would need to be copied and then have the values only pasted to the relevant table in the other 2 worksheets because I have formulas working out the reference number for each new threat/issue in the main table.
My data table on Sheet1 looks like this:
When the activex button is pressed, I'd like the macro to look for any new "TASK" or "Opportunity" (In column V) that has been added since the last time it was run and to then copy the data in that row but only cells A-I and W-X (I've starred the columns above) if possible, to the corresponding worksheet - Task or Opportunity..
I've managed to get as far as identifying the task or opportunity and copying the row onto the correct worksheet but that's it..
Sorry if this is a complicated explanation, my first time posting too...Any help much appreciated.
Thank you
I am very new to VBA and have been struggling to find everything I need in one place to complete a task I'd like to do. Any help would be much appreciated.
I have a risk register which captures threats and issues that may occur within my projects. The outcome of those could be a task or an opportunity. I would like to be able to have the team click a button which then runs a macro to look at any risks or issues that have an outcome as 'TASK' and then copy the details to a separate worksheet in my workbook so that the task table can be progressed away from the main capture table. The same goes for any opportunities.
The data would need to be copied and then have the values only pasted to the relevant table in the other 2 worksheets because I have formulas working out the reference number for each new threat/issue in the main table.
My data table on Sheet1 looks like this:
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD |
REF | Project Code | Project Name | Project Lead | Status | Date Raised | TYPE | Raised By | Desc | Impact | Proximity1 (Dept) | Proximity2 (Dept) | Proximity (Timeline) | Cost | Revenue | Quality | Timeframe | Absolute Prob | Absolute Impact | Risk Score | Risk Level | Outcome | Assigned to | Action | Status | Approved By | Approval Date | Completion Date | Notes | Doc Ref Number |
| Calculated using the project code B & Name C with unique number -001 etc | * | * | * | * | * | * | * | * | TASK | * | * | ||||||||||||||||||
| * | * | * | * | * | * | * | * | Opportunity | * | * |
When the activex button is pressed, I'd like the macro to look for any new "TASK" or "Opportunity" (In column V) that has been added since the last time it was run and to then copy the data in that row but only cells A-I and W-X (I've starred the columns above) if possible, to the corresponding worksheet - Task or Opportunity..
I've managed to get as far as identifying the task or opportunity and copying the row onto the correct worksheet but that's it..
Sorry if this is a complicated explanation, my first time posting too...Any help much appreciated.
Thank you
