data modeling
1 TopicData modeling and table lengths in Excel
Hi, In an Excel solution, I bring in data from SQL connection to worksheet 1 (WS#1), thus the data set number of rows changes each time. A second worksheet (WS#2)runs calculation on WS#1. My problem starts when the WS#2 ends up with bunch of N/A or Errors dow at the button due to the table size not matching to the correspond number of rows pulled from WS#1. I suspect this must be a clear question for pro data modelers? I appreciate any help.Solved2KViews0likes5Comments
