Bonzopookie
New member
Hello,
I am not very good with VBA programming, however I am somewhat knowledgeable with figuring out Excel formulas. I could really use some help with solving a problem that I am faced with (I am attaching a sample workbook for reference).
I have 2 worksheets: 1 Formulas, and 1 JanTable- which contains a bunch of records for tracking fitness and activity.
At the end of each day, the user can choose from a pull-down Actions menu, and select the option of "Daily Totals". When the user selects this item, I would like to populate the total sums from that day, across the worksheet row.
I created a table on the "Formulas" Page that can correctly sum the totals for each day. However I am not sure if/how I can use VBA code to then take the summed totals from the Formulas page, and place them across the worksheet row where "Daily Totals" was selected from the Actions Menu pull-down.
Attached is a simplified workbook example, showing my problem in more detail. Hopefully, it will be easier to explain what I am trying to convey here. Please let me know if I need to provide even more details.
Thank you in advance, for any help you can offer me.
Sincerely,
I am not very good with VBA programming, however I am somewhat knowledgeable with figuring out Excel formulas. I could really use some help with solving a problem that I am faced with (I am attaching a sample workbook for reference).
I have 2 worksheets: 1 Formulas, and 1 JanTable- which contains a bunch of records for tracking fitness and activity.
At the end of each day, the user can choose from a pull-down Actions menu, and select the option of "Daily Totals". When the user selects this item, I would like to populate the total sums from that day, across the worksheet row.
I created a table on the "Formulas" Page that can correctly sum the totals for each day. However I am not sure if/how I can use VBA code to then take the summed totals from the Formulas page, and place them across the worksheet row where "Daily Totals" was selected from the Actions Menu pull-down.
Attached is a simplified workbook example, showing my problem in more detail. Hopefully, it will be easier to explain what I am trying to convey here. Please let me know if I need to provide even more details.
Thank you in advance, for any help you can offer me.
Sincerely,