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...
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?
- so if i understand you correctly, on 1 sheet you have 3 tables 'stacked' and each table may grow in size? What do we know? is there unique header lines and/or at least 1 or more blank lines in between?
- YES HEADER IS SAME
- we need more information. please attach a sample sheet and if you can't attach then use onedrive or dropbox or other option to provide a link. or PM one of us and we can post it