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.

Branch Name	City
Malad	Mumbai
Wanwarie	Pune
Vashi	Navi Mumbai

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[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.