Macro to fill tables that have changing number of rows

[haganator]

Greetings everyone,

I'm trying to write a macro that will read data from one spreadsheet and graph it in another when the number of rows is variable. The data consists of 8 tables. Each table will have a maximum of 24 rows. The number of columns are different for each table, but they don't change. I have a macro that will populate my tables correctly when there is a full days' worth of data (24 rows)...I can hard code the size of each table. What I'm trying to do is write a macro that will populate my tables if there's only a partial days' worth of data. Each table has a title and a header. The header could be 2-4 rows. I initially thought of searching for the table title and then using an offset command to get to the first row, but I couldn't figure out how to make that work. Any ideas would be greatly appreciated. Below is a clip of 2 of the tables showing 14 hours of data

Many thanks in advance,
Jeff

PCSS0-Session-Stats
	RPP0	RPP1	RPP4	RPP5
Hour	A	D	A	D	A	D	A	D
0	397	9204	401	9292	392	9009	389	9324
1	351	8559	330	8610	329	8425	328	8685
2	331	8153	317	8147	314	7985	310	8290
3	319	7901	299	7924	331	7857	318	7966
4	351	7880	333	7928	329	7714	320	7906
5	375	8379	408	8481	395	8298	385	8565
6	467	9250	462	9494	476	9218	469	9576
7	592	10405	602	10489	613	10180	579	10688
8	689	11212	672	11447	680	10894	677	11203
9	738	11427	728	11779	723	11127	739	11633
10	749	11453	747	11984	765	11456	749	11833
11	744	11749	752	12194	720	11530	793	12154
12	754	11969	749	12222	695	11732	728	12387
13	756	11908	774	12205	759	11856	734	12569
PCSS0-CPU-Stats
Hour	PMP	RPP0	RPP1	RPP4	RPP5	PEP0	PEP1	PMP	RPP0	RPP1	RPP4	RPP5	PEP0	PEP1
	PK	PK	PK	PK	PK	PK	PK	AV	AV	AV	AV	AV	AV	AV
0	17	9	8	8	8	4	3	8	6	6	6	6	3	2
1	17	7	7	7	7	4	3	7	5	5	5	5	3	3
2	16	6	6	6	6	4	3	7	5	5	5	5	3	3
3	16	6	6	6	6	4	3	7	5	5	5	5	3	3
4	17	6	6	6	7	4	3	7	5	5	5	5	3	3
5	16	7	8	8	7	5	5	7	6	6	6	6	3	3
6	17	9	9	9	9	4	3	8	7	7	7	7	3	3
7	17	12	12	11	12	4	3	8	9	9	9	9	3	3
8	18	14	14	13	13	4	3	8	11	11	10	11	3	3
9	18	15	15	14	15	4	3	9	12	12	12	12	3	3
10	17	15	15	15	15	4	3	9	12	13	12	13	3	2
11	18	15	15	14	16	4	3	9	12	13	12	13	3	3
12	18	15	15	14	15	4	3	9	13	13	12	13	3	3
13	17	15	15	15	15	4	3	9	12	13	12	12	3	3

<colgroup><col span="15"></colgroup><tbody>
</tbody>