I'm using Excel and Access 2007. I'm having an issue at work and my current knowledge of Access and Excel isn't enough. I have an Access database that has certain data in it. I have an Excel spreadsheet that imports the data from that database (through linking), and adds three more columns. The problem is that new rows are entered into the database every day, and when I update the link in Excel, the rows in the linked table move down accordingly, but the three Excel columns do not. Also, I highlight certain cells and when it updates, the same (now incorrect) cells are highlighted instead of the data I wanted to highlight. Some rows get deleted, so I can't just move the Excel columns down to where they need to be.
Can I get the three Excel columns to be linked to the exact row of data they need to be linked to so that when the linked table updates, they move or disappear accordingly? I just need to make sure everything stays together, I'm not picky about how that's done.
Thanks so much for your time.