How do I set a table's range to automatically adjust to source data?

holt3130

New Member
Joined
Jul 23, 2013
Messages
14
I cant figure out how or if it is even possible to have a table automatically adjust its range or the number or rows it has based on another table

I have two tables:

Table1 is raw data that is added two daily

Table2 has formulas with column header references to Table1 that processes the information and converts it to a readable format. (basically barcodes to words)

Is there a way to get Table2 to automatically resize to the same number of rows that Table1 has whenever data is added??
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,095,822
Messages
5,446,716
Members
405,414
Latest member
wayne_p

This Week's Hot Topics

Top