Copy paste table and name the header based on a list

[nadeem505]

Hi Experts,

I have a sample table that I have create in row B7 to J16.

I want to copy this table (below each table leaving one blank row in between) as many times as the number of operational groups. I have a list of operational group on another sheet. After copying the table I want macros to put the operational group name in cell B10 (**Operational Group**) (B10 will change to B18 in new table and so on...)

Is it too much to ask?

Cheers,

NK

 

[nadeem505]

Copy of the table

Excel 2016 (Windows) 32 bit
	A	B	C	D	E	F	G	H	I	J
1		FACILITY / SERVICE BUSINESS MODEL
2
3		School/Division	e.g. SAFS
4
5		Purpose:	What services are provided by the facility and who are they for?
6
7
8
9	1	2	3	4	Space		Staff		Student
10		**Operational Group**		% of Total Budget	% Dependency	$ Allocation	% Dependency	$ Allocation	% Dependency	$ Allocation
11
12		Service #1		50%
13		Service #2		40%
14		Service #3		10%
15
16		Overall %		100%	0.0%		0.0%		0.0%
Sample

Cell Formulas
Range	Formula
D16	=SUM(D12:D14)
E16	=($D12*E12)+($D13*E13)+($D14*E14)
G16	=($D12*G12)+($D13*G13)+($D14*G14)
I16	=($D12*I12)+($D13*I13)+($D14*I14)