Hello All , I have taken interest in excel VBA recently and am trying to learn and apply some optimizations to my daily excel workflow sheets.
I have an excel table which has date that is replugged into multiple sheets in my workbook. Instead of pluging them in each table. I would like to find a way to plug the information in one table which is then distributed to all the selected tables (which have slightly different formatting) in the correct location. I will provide an example below to further illustrate the question.
I feel there is a macros where to automate this mundane task.
Appreciate the support and thank you.
Example Below
I have an excel table which has date that is replugged into multiple sheets in my workbook. Instead of pluging them in each table. I would like to find a way to plug the information in one table which is then distributed to all the selected tables (which have slightly different formatting) in the correct location. I will provide an example below to further illustrate the question.
I feel there is a macros where to automate this mundane task.
Appreciate the support and thank you.
Example Below