VBA # How to store list

[Rasika21]

Hello,

I would like to know if in VBA I can store list of a specific data summary to use in any other or new open worksheet.
I am using below mentioned type of list for the every report i need to prepare, I just copy paste it from any available excelsheet but is there any shortcut to save this list and i can paste it in a single click.
[TABLE="width: 276"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Branch Name[/TD]
[TD]City[/TD]
[/TR]
[TR]
[TD]Malad[/TD]
[TD]Mumbai[/TD]
[/TR]
[TR]
[TD]Wanwarie[/TD]
[TD]Pune[/TD]
[/TR]
[TR]
[TD]Vashi[/TD]
[TD]Navi Mumbai[/TD]
[/TR]
</tbody>[/TABLE]

 

[Kenneth Hobson]

Does Clipboard not suffice?

 

[Rasika21]

Yes clipboard is enough but I just wanted to know if i can do this through VBA

 

[Kenneth Hobson]

There are several ways. If you want the full content and not plain text values, then saving to a master xlsx file method would be used. If text values is sufficient, there are several ways to do that. e.g. Registry storage, txt file, etc.

 

[Rasika21]

Yes, its only text values.