My, my, my.... Excel Forum it has been too long! I have one that is stubbing me. I have always dealt with Access Connections where I could use a parameter to reference a cell and pull data based on that value. Now working with a different company I have access to the SQL read only data feeds!!! Yay Right?

I have a workbook that pulls headcounts of our employees based on a particular field. This workbook will be used as a template and will have multiple versions made every 6 months. So my employees will populate a cell based on their line of business and make their file. I plan to have on Worksheet_Change event with a target of the designated Cell to run this script to change the Command Text within the connection. Sounds Simple Right? About 10 lines into adding chr(1o)&""&chr(13) to the entirety of the script of changing the command text completely, I wanted to see if there was a more efficient way and easier to read!

So the command text is rather lengthy, 456 lines of code, but there is one and one line only that I am trying to change in here.

AND D19.[Shift Bid Group] = 'MAW Bid'
Any thoughts on having the triggered event to search the command text and replace the MAW Bid with Worksheets("Configuration").Range("B1").Value

Thanks in advance everyone!!