Multiply different excel files based on a cell value in a master file and rename them

[annamemma]

Hi!

I am trying to find an automated process in VBA for a very time-consuming task. This is my monthly table:

​

column A​	Column B​	Column C​	Column D​
Store type​	How many stores?​	Type of file template​	New name of the file​
Store 1	4​	1. 2023_Store 1_C1._feb.xlsx	2123 Store 1
Store 2	2​	1. 2023_Store 2_C2._feb.xlsx	2123 Store 2
Store 3	4​	1. 2023_Store 3_C3._feb.xlsx	2123 Store 3

For each type of store, I have a specific template I have to use and I have to multiply them depending on how many times it is mentioned in column B.

Any chance I can automate this process using VBA? I'm no expert in it, I can just make basic stuff in VBA..

Any help would be greatly appreciated!

Thanks!

 

[annamemma]

Hi!

I am trying to find an automated process in VBA for a very time-consuming task. This is my monthly table:

​

column A​	Column B​	Column C​	Column D​
Store type​	How many stores?​	Type of file template​	New name of the file​
Store 1	4​	1. 2023_Store 1_C1._feb.xlsx	2123 Store 1
Store 2	2​	1. 2023_Store 2_C2._feb.xlsx	2123 Store 2
Store 3	4​	1. 2023_Store 3_C3._feb.xlsx	2123 Store 3

For each type of store, I have a specific template I have to use and I have to multiply them depending on how many times it is mentioned in column B.

Any chance I can automate this process using VBA? I'm no expert in it, I can just make basic stuff in VBA..

Any help would be greatly appreciated!

Thanks!

and I forgot to add. I have to rename them at the end of the process like so: "2123 Store 11","2123 Store 12","2123 Store 13", "2123 Store 14" - because there are 4 stores using this type and so so.