ggtrixabell
New member
- Local time
- Today, 08:29
- Joined
- Sep 18, 2017
- Messages
- 6
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: Sorry, it didn't copy properly..
RefProject CodeProject NameProject LeadStatusDate Raised TYPERaised ByDescriptionImpactProximity #1 (Department)Proximity #2 (Department)Proximity (Timeline)COSTREVENUEQUALITYTIMEFRAMEAbsolute Probability Absolute Impact
Risk ScoreRisk LevelOutcomeAssigned To Action / UpdatesStatusApproved ByApproval DateCompletion Date NotesDocument Ref NoCHRL-001CHRLChocolate RollJDCLOSED12-Dec-16THREATChoc Supplier lostetcetcetcetcetcetcetcetcetcetcetcetcTASKsupply ChainAlternative supplier neededetcetcetcetcetcetcPNCH-002PNCHPeanut Chip CookieJDCLOSED12-Dec-16THREATRival company openedetcetcetcetcetcetcetcetcetcetcetcetcOpportunityMarketingMarket research - Possible commercial agreementetcetcetcetcetcetc
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 from cells in columns AtoI and WtoX 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.
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: Sorry, it didn't copy properly..
RefProject CodeProject NameProject LeadStatusDate Raised TYPERaised ByDescriptionImpactProximity #1 (Department)Proximity #2 (Department)Proximity (Timeline)COSTREVENUEQUALITYTIMEFRAMEAbsolute Probability Absolute Impact
Risk ScoreRisk LevelOutcomeAssigned To Action / UpdatesStatusApproved ByApproval DateCompletion Date NotesDocument Ref NoCHRL-001CHRLChocolate RollJDCLOSED12-Dec-16THREATChoc Supplier lostetcetcetcetcetcetcetcetcetcetcetcetcTASKsupply ChainAlternative supplier neededetcetcetcetcetcetcPNCH-002PNCHPeanut Chip CookieJDCLOSED12-Dec-16THREATRival company openedetcetcetcetcetcetcetcetcetcetcetcetcOpportunityMarketingMarket research - Possible commercial agreementetcetcetcetcetcetc
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 from cells in columns AtoI and WtoX 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.
Attachments
Last edited: