Hi There,
I have several macro buttons, the majority being on one sheet within Excel called 'Control'.
What I want to achieve is when one of the buttons is clicked it registers the following on another sheet within the same workbook:
Date and Time
The Button Name
Who pressed the button
The actual reason (Name of the button "Email sent for TradeWeb")
The date and time and who pressed the button can go into the same cell as 'TradeWeb' along with the button name.
Also, I have another button 'Aladdin' which will relate to the same 'Fund', so I would like to press that and the information checks the row and if it relates to 'Fund ABC' the date/time and who pressed it, along with the button name goes into 'Aladdin'. Then if another Fund is added called DEF on the next line below, the code becomes dynamic.
I have several macro buttons, the majority being on one sheet within Excel called 'Control'.
What I want to achieve is when one of the buttons is clicked it registers the following on another sheet within the same workbook:
Date and Time
The Button Name
Who pressed the button
The actual reason (Name of the button "Email sent for TradeWeb")
Aladdin | Fund | TradeWeb |
ABC |
The date and time and who pressed the button can go into the same cell as 'TradeWeb' along with the button name.
Also, I have another button 'Aladdin' which will relate to the same 'Fund', so I would like to press that and the information checks the row and if it relates to 'Fund ABC' the date/time and who pressed it, along with the button name goes into 'Aladdin'. Then if another Fund is added called DEF on the next line below, the code becomes dynamic.