We have an excel query that runs off of a parameter. There are formulas in cells that work off of this refreshable data. When the parameter is cleared data and formulas on the sheet disappear. Which is what we want. When a new parameter is entered, the formulas change. For example our data starts on row 8. If the previous data set ended on row 10. We clear the parameter and put a new parameter in, the formulas on row 8 which should look for data on the same row will look for data on row 10. They then copy down right looking at 11, 12 etc but they are not looking at the right data.
Any help would be appreciated
Thanks
Bookmarks