I have an excel sheet that imports 7 columns of home data (with lots of rows) and prepares 2 pivot tables on 2 separate tabs.
It's been working great but now I get a "subscript out of range" error when I try to import new data.
I've tried reducing the data file, but that didn't work so not sure what it causing it. There were other tabs that cre...
Skills: excel vba, microsoft excel