Forum Discussion
HOW TO MAKE 3 TABLES RANGE DYNAMIC WITHOUT CONVERTING IT WITH TABLE
HI ALL, AS I HAVE 3 TABLES IN FINAL DATA SHEET. 1ST IS DEAL SUMMARY TABLE WHICH IS EXIST IN DEAL SUMMRAY SHEET 2ND IS CONTACT LIST TABLE WHICH IS EXIST IN CONTACT LIST SHEET 3RD IS REFERENCE COMP...
IF those tables are 'Formatted as a Table' then the dynamic range of the table WILL automatically change but you will need to use proper table references: Table1[column 1]
I think they call it structured notation but once the data is formatted as a table (see home tab and click that button) then when you have a formula and you go to that table you can select the column and it will automatically insert that notation.
alternative 'old school' way:
=A$1:index(sheet1!A:A,counta(sheet1!A:A))
I think they call it structured notation but once the data is formatted as a table (see home tab and click that button) then when you have a formula and you go to that table you can select the column and it will automatically insert that notation.
alternative 'old school' way:
=A$1:index(sheet1!A:A,counta(sheet1!A:A))
- but my tables are one under the other
- Then all the more reason you should be formatting the tables as tables and using structured references.
- i cant convert the range into table .it won't work in our software. is there any other way to do in excel 2016?
