VBA - Command Button to Multiply Value In Cell in Last Updated Column

[ollie]

Hey DocAElstein

Thanks so much for getting back to me and thanks for your efforts to help thus far. It's really appreciated.

I will offer a little more context to my problem as the solution you have provided isn't quite what I need. Although, that's due to me not being clear enough in my requirements.

I've created a Productivity Tracker to measure employees productivity throughout the working day. This workbook contains three worksheets

'Productivity Tracker (WFH)' - Sheet 1

'Productivity Output' - Sheet 2

'AVHT_Task Store' -Sheet 3 is just table being used to lookup average handling times (AVHTs) so we can immediately disregard.

Sheet 1 contains 3 drop downs which describe all the different tasks the user could do in the office. The user will select through the three drop downs and hit an already existing command button to log the piece of work they are doing and time and date stamp it. This is stored in sheet 2. The user repeats this process throughout the day logging the work they have completed. Every time a task is completed they select the drop downs, hit the command button and it populates a row on sheet 2 (Range A:J). Column A = ‘Activity’ (Drop Down 1), Column B = ‘Task’ (Drop Down 2), Column C = ‘Sub Task’ (Drop Down 3), Column D = ‘Reference Number’, Column E = ‘Time’, Column F = ‘Date’, Column G = ‘Average Handling Time (AVHT)’, Column H = ‘Time Taken’, Column I = ‘Percentage of time taken vs AVHT’, Column J = ‘Username’.
This is all working great!
However, I would like to add a second command button on sheet 1. The command button should multiply by 10, the value found in the last populated cell of column G (AVHT) of sheet 2. So in essence I need the user to be able to multiply the AVHT (Column G) of the last task they logged by 10.
I'm really sorry if I've confused things more! I'm happy to privately and securely share a copy of the tracker if this would help?

Many Thanks in advance

Ollie

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://teylyn.com/2017/03/21/dollarsigns/#comment-191
https://www.youtube.com/watch?v=7VwD9KuyMk4
https://eileenslounge.com/viewtopic.php?p=326972#p326972
https://eileenslounge.com/viewtopic.php?p=326853#p326853
https://eileenslounge.com/viewtopic.php?p=326446#p326446
https://eileenslounge.com/viewtopic.php?f=27&t=41986
https://eileenslounge.com/viewtopic.php?p=325610#p325610
https://eileenslounge.com/viewtopic.php?p=325609#p325609
https://eileenslounge.com/viewtopic.php?p=325605#p325605
https://eileenslounge.com/viewtopic.php?p=325548#p325548
https://eileenslounge.com/viewtopic.php?p=316441#p316441
https://eileenslounge.com/viewtopic.php?p=324736#p324736
https://eileenslounge.com/viewtopic.php?p=324990#p324990
https://eileenslounge.com/viewtopic.php?f=27&t=41937&p=325485#p325485
https://eileenslounge.com/viewtopic.php?p=325609#p325609
https://eileenslounge.com/viewtopic.php?p=325610#p325610
https://www.youtube.com/watch?v=3t8Mk4URi6g&lc=UgzoakhRXOsCaoRm_Nd4AaABAg. 8xzeMdC8IOGADdPM65i9PG
https://www.youtube.com/watch?v=3t8Mk4URi6g&lc=UgzoakhRXOsCaoRm_Nd4AaABAg. 8xzeMdC8IOGADdPQHFk_zm
http://www.eileenslounge.com/viewtopic.php?p=324457#p324457
http://www.eileenslounge.com/viewtopic.php?p=324064#p324064
http://www.eileenslounge.com/viewtopic.php?p=323960#p323960
https://www.youtube.com/watch?v=7VwD9KuyMk4&lc=UgyZCnNfnZRfgwzDlQF4AaABAg
https://www.youtube.com/watch?v=7VwD9KuyMk4&lc=UgyZCnNfnZRfgwzDlQF4AaABAg. ADd4m2zp_xDADd6Nnotj1C
s://www.youtube.com/watch?v=7VwD9KuyMk4&lc=UgySdtXqcaA27wQLd1t4AaABAg
http://www.eileenslounge.com/viewtopic.php?p=323959#p323959
http://www.eileenslounge.com/viewtopic.php?f=30&t=41784
http://www.eileenslounge.com/viewtopic.php?p=323966#p323966
http://www.eileenslounge.com/viewtopic.php?p=323959#p323959
http://www.eileenslounge.com/viewtopic.php?p=323960#p323960
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA