I have a number of worksheets that follow the same naming format. I want a macro that will copy information from the "Client" sheet and paste the information to the "Agent" sheet. I don't want to write 25 different different macros to accomplish this. For example, if the active sheet is "Branch_550_Client", I want to copy information to sheet "Branch_550_Agent". If in 788_client, copy to 788_agent; and so on. Is there a way to do this? (I am willing to change the sheet name in properties to "112_Client", "Client_112", or any other combination if that makes it easier).
I have 25 sheets named as follow (first 5 sheets only)
Branch_112_Client
Branch_300_Client
Branch_550_Client
Branch_612_Client
Branch_788_Client
I have 25 sheets named as follows (first 5 sheets only)
Branch_112_Agent
Branch_300_Agent
Branch_550_Agent
Branch_612_Agent
Branch_788_Agent
I have the macro as follows (assume activesheet is "Branch_112_Client"):
Bookmarks