MS Access table issue after adding row

[strongman86]

Lads,

I'm working with Table that uses query from MS Access and I have added manually few columns like you would normally do on excel. I have manually filled cells with data. When data is refreshed from query and if rows are automatically added it shifts all data to different rows, but data entered manually by me on added columns stays on the same row. Is there a way to make them also shift? Thanks.

 

[Andywaller]

Hi Rondeondo

Sorry for jumping onto this thread but i've got a similar issue and have tried to understand where you are coming from with your solution. I've got a raw data spreadhseet, which i pull data from into another spreadsheet, using Data Query. I then need to be able to add comments next to the cases. I tried to add columns to my data table but when the data refreshed, the comments were moved to different cases. To get around this, i've got another sheet that uses vlookup to pull the data from the data table, which allows me to add comments. However, if the original data changes (case is removed from the filter as it's no longer open for example), whilst the case is no longer in the data table, and no longer showing in my vlookups, the comments remain where they are.

Each case has a unique ID, so how would i go about implementing your suggestion?

 

[strongman86]

Hi Andyaller,

Check out my post below.
https://www.mrexcel.com/forum/excel...identifier-found-delete-row-if-not-found.html

Hope this helps.

 

[rondeondo]

Hi Andy
I’d need to see an example to follow your situation. Where you add comments needs to be a static list. ie. a sheet in your workbook that is not produced elsewhere and is thus not going to change with refreshing data. This would consist of a column for case id and a column for comments. This sheet is then your source to look up from your dynamic data sets.