User Entry Columns with ODBC

[kristaO]

I have an Excel workbook that is pulling information from a database through ODBC, I want to have user entered columns that will "stay" with the row. Currently refresh will result in misaligned data, I understand why but have yet to get a fix that works. I though I found a solution with the thread listed below but cannot get it to work the way it's described, it was easy setting up the query to pull the user entered information and unique identifier to the 2nd sheet but I'm having trouble with when adding the 2nd sheet to the original query. I'm pretty familiar with SQL and complete newbie in VBA but will to incorporate anything to get this to work. Fingers crossed someone can help because i have plans to do something similar using 3 workbooks. An example of how my columns are setup is below the link (F-M are all from the ODBC).

http://www.mrexcel.com/forum/excel-questions/376984-database-query-possibilities.html

A B C D E F ..........M
User User User User User Unique Ident.

 

[kristaO]

So my formatting got messed up A-E are user entered columns F-M are from the ODBC, F will have my unique identifier.