bdasovic
05-15-2023, 12:33 AM
hello,
Thank you in advance for any help provided.
I am currently working on a cost analysis for our construction project. So basically, for each activity from our contract I have to provide a separate calculation. Obviously there are hundreds of activities in this project so I was hoping that some things could be automated. I have created a template on a sheet named "Template". So I would like to create a separate sheet based on a template for each activity from a sheet with a list of activities. The list of activities looks something like this:
A
B
C
D
E
1
1.
Preparation works
compl.
1
100 €
2
2.1.
Concrete works C25/30
m3
20
120 €
3
2.2.
Concrete works C 30/37
m3
15
130 €
Also it would be great if I could automatically fill the data from activity list to a newly created sheets based on a template. For instance, for row 1 in the table the VBA macro should create row named "1." based on a A column, and fill data A1 to B4 in a new sheet, B1 to C4 cell on a new sheet, and C1/D1/E1 to D8/E8/F8 on a new sheet.
Could someone help me with this, because i was doing this manually for days now.
Sincerelly,
bdasovic
Thank you in advance for any help provided.
I am currently working on a cost analysis for our construction project. So basically, for each activity from our contract I have to provide a separate calculation. Obviously there are hundreds of activities in this project so I was hoping that some things could be automated. I have created a template on a sheet named "Template". So I would like to create a separate sheet based on a template for each activity from a sheet with a list of activities. The list of activities looks something like this:
A
B
C
D
E
1
1.
Preparation works
compl.
1
100 €
2
2.1.
Concrete works C25/30
m3
20
120 €
3
2.2.
Concrete works C 30/37
m3
15
130 €
Also it would be great if I could automatically fill the data from activity list to a newly created sheets based on a template. For instance, for row 1 in the table the VBA macro should create row named "1." based on a A column, and fill data A1 to B4 in a new sheet, B1 to C4 cell on a new sheet, and C1/D1/E1 to D8/E8/F8 on a new sheet.
Could someone help me with this, because i was doing this manually for days now.
Sincerelly,
bdasovic