I have done an MS SQL Query in excel.
I have added extra colums in the excel sheet which I want to enter manual
data in.
When I refresh the data, these manually inputted columns become misaligned
to the imported data they refer to.
Is there any around this happening.
I have tried to link the imported data sheet to a manual data sheet via
vlookup
but this isn't working as there are no unique fields to link together.
Please help!
Thanks
Excel version is 2010. MS SQL version is 2005. There is no unique data. Because excel firstly looks like this.
when we entered a new order in to database Excel looks like this