H HJL :) New Member Apr 15, 2015 #1 I am attempting to create multiple tabs with dynamic subtables from a master sheet. I continue to get a #num error. Any help is greatly appreciated!!!! Attachments Subtable_Template.xlsx Subtable_Template.xlsx 22.3 KB · Views: 1
I am attempting to create multiple tabs with dynamic subtables from a master sheet. I continue to get a #num error. Any help is greatly appreciated!!!!
XOR LX Active Member Apr 16, 2015 #2 Hi. Not sure I understand. There are no formulas in either of the tabs in that workbook. Regards
H HJL :) New Member Apr 16, 2015 #3 Sorry! The formulas are in this file. Any assistance is GREATLY appreciated. Attachments Subtable_Template.xlsx Subtable_Template.xlsx 83.4 KB · Views: 0
N NARAYANK991 Excel Ninja Apr 16, 2015 #4 Hi , If you use a Helper Column , the formulae become simpler. See the attached file. Narayan Attachments Subtable_Template.xlsx Subtable_Template.xlsx 29.5 KB · Views: 2