ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 302
- Office Version
- 2016
- Platform
- Windows
I have a very large Date Table 8 Cols wide 10,000 rows long. (Called Table1)
I am trying to make a new table 20 rows long (Called Table2) that will index a certain part of this table, it will be dynamic based on a Chosen name.
This will allow me to work on a small table.
I am able to extract the range from the large table and have named it TestA
I would like Table2 starting with the first non header row represent what is in TestA range.
Table2, row 1 would be the first line of TestA range.
Table2 row 2 would be the 2nd line of TestA range.............
Thanks in advance
I am trying to make a new table 20 rows long (Called Table2) that will index a certain part of this table, it will be dynamic based on a Chosen name.
This will allow me to work on a small table.
I am able to extract the range from the large table and have named it TestA
I would like Table2 starting with the first non header row represent what is in TestA range.
Table2, row 1 would be the first line of TestA range.
Table2 row 2 would be the 2nd line of TestA range.............
Thanks in advance