Dynamic range for table

[maps5]

Hello.

I would like to place a question regarding resizing a table.

I have a sheet with 2 tables, 1 button with a recorded macro.
The macro was recorded with a advanced filter for extracting unique records from table 1 and paste the results on P1.
These results become the first column of table 2.


Other columns on table 2 update automatically using lookup and sumproduct functions...



Table 2 is being used for a line chart.


The idea is, I enter values on table 1 (on columns A, B and C), and table 2 as well as the chart will update with new entered values.

My issue comes when a new week is starting.
Because when I enter a date belonging to a new week number, than run the macro, this new week number will not be listed within table 2’s dimensions.
If table 2 was P1-T5, after running the macro, it will still be P1-T5 but there will be a new value on P6 that was not placed within the table.


Can I resize table 2 as needed??
Perhaps on the same macro that runs the advanced filter.

Or maybe you have a better suggestion on how I could work around this.

If you don't understand my problem description, please let me know.
I'm not able to upload a example of my sheet, because I'm currently at work.
But I can do it as soon as I get home.



Thanks in advance.

Regards.

 

[maps5]

As promised, here is a sample of my excel file.

When I add a new row of data on Table 1 and hit the button (which runs a macro for advanced filter to extract unique records, Table 2 should update.

The problem is that, if the new row belongs to a new week, this new week will not be inserted on table 2.

And I need table to remain a table (or dynamic range) because I need to use in a chart, which will also update automatically.

I really hope you can help me out on this one.
Regards.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Date	Week #	Production 1	Production 2	Total	Comments	*	*	*	*	Week #	Production 1	Production 2	Daily Average P.1	Daily Average P.2
2	ti 01-feb-2011	5 / 2011	400	300	700	*	*	*	*	*	5 / 2011	2300	1850	575,00	462,50
3	on 02-feb-2011	5 / 2011	600	600	1200	*	*	*	*	*	6 / 2011	4100	2500	820,00	500,00
4	to 03-feb-2011	5 / 2011	700	550	1250	*	*	*	*	*	7 / 2011	3600	2800	720,00	560,00
5	fr 04-feb-2011	5 / 2011	600	400	1000	*	*	*	*	*	8 / 2011	800	700	800,00	700,00
6	ma 07-feb-2011	6 / 2011	800	450	1250	*	*	*	*	*	*	*	*	*	*
7	ti 08-feb-2011	6 / 2011	600	500	1100	*	*	*	*	*	*	*	*	*	*
8	on 09-feb-2011	6 / 2011	900	540	1440	*	*	*	*	*	*	*	*	*	*
9	to 10-feb-2011	6 / 2011	800	480	1280	*	*	*	*	*	*	*	*	*	*
10	fr 11-feb-2011	6 / 2011	1000	530	1530	*	*	*	*	*	*	*	*	*	*
11	ma 14-feb-2011	7 / 2011	600	400	1000	*	*	*	*	*	*	*	*	*	*
12	ti 15-feb-2011	7 / 2011	800	600	1400	*	*	*	*	*	*	*	*	*	*
13	on 16-feb-2011	7 / 2011	600	800	1400	*	*	*	*	*	*	*	*	*	*
14	to 17-feb-2011	7 / 2011	1000	400	1400	*	*	*	*	*	*	*	*	*	*
15	fr 18-feb-2011	7 / 2011	600	600	1200	*	*	*	*	*	*	*	*	*	*
16	ma 21-feb-2011	8 / 2011	800	700	1500	*	*	*	*	*	*	*	*	*	*
17	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
18	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
19	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
20	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
21	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
22	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
23	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
Data

 

[maps5]

Hello.

I would like to follow up on this old thread of mine.

If you don't understand what I'm asking for, please let me know and I will try to rephrase the issue/request.

regards
maps