Excel Query Parameter Paste Relative to Row

[Tommy44]

I have an excel sheet that I'm getting external data from and using an excel parameter (4 cells to the left of the query cells). This works well, except I need to paste the query in the following 200 or so cells and I'd like the parameter to automatically paste using the cell directly to the left in that row. right now whenever I paste the query the parameter is always locked into the original cell and it doesn't move relative to the pasted row. I even removed the $ signs from the parameter formula and it doesn't have any effect. How can I do this? I'd like to stay away from VBA because I don't really know it.

Thanks!

 

[Tommy44]

Does anyone have any ideas how to do this? I am still trying to figure it out. Thanks!