| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Manual entered data on excel ms query is misaligned after refresh
I have done an MS 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 isnt working as there are no unique fields to link together. Please help! Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I import formmail data to a custom excel template? | Excel Worksheet Functions | |||
| Excel 03 DB query pulls data in wrong order, how to resolve? | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
| have dates entered from a list of data into an excel template | Excel Discussion (Misc queries) | |||
Linear Mode
